Details on Vertica Connection


This dialog is used to configure a connection to a Vertica database. You can choose whether to analyze data in-database or to import it into your analysis. Note that you need to install a driver on your computer to get access to the Vertica connector. See the system requirements at http://spotfi.re/sr/connectors to find the correct driver. You can also view Getting Started with Connectors to learn more about getting access to connectors in Spotfire.

To add a new Vertica connection to the library:

  1. On the menu bar, select Data > Manage Data Connections.

  2. Click Add New > Data Connection and select Vertica.

To add a new Vertica connection to an analysis:

  1. Click Files and data .

  2. In the Files and data flyout, click Connect to.

  3. In the list of connectors, click Vertica.

  4. In the Vertica flyout, click New connection.

Option

Description

Server

The name of the server where your data is located. To include a port number, add it directly after the name preceded by colon.

Example with port number:
MyDatabaseServer:1234

Use connection load balancing

Select whether or not to use load balancing when connecting to the Vertica database.

Username

The username you wish to use when logging into the Vertica database.

Password

The password for the specified username.

See also:

Vertica Data Types

Supported Functions