Details on HP Vertica Connection


This dialog is used to configure a connection to a HP 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 HP Vertica connector. See the system requirements at http://support.spotfire.com/sr_spotfire_dataconnectors.asp to find the correct driver. You can also view Getting Started with Connectors to learn more about getting access to connectors in Spotfire.

  1. Select Tools > Manage Data Connections.

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

  1. Select File > Add Data Tables.

  2. Click Add.

  3. Select Connection To > HP Vertica.

connect_hp_vertica_connection_d.png

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 HP Vertica database.

Username

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

Password

The password for the specified username.

See also:

HP Vertica Data Types

Supported Functions