Details on HP Vertica Connection


This dialog is used to set up a connection to a HP Vertica database, allowing you to 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

Username

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

Password

The password for the specified username.

See also:

Introduction

HP Vertica Data Types