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:
On the menu bar, select Data > Manage Data Connections.
Click Add New > Data Connection and select Vertica.
To add a new Vertica connection to an analysis:
Click Files and data .
In the Files and data flyout, click Connect to.
In the list of connectors, click Vertica.
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: |
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. |