How to connect to HPE Vertica from Spotfire Information Designer.

How to connect to HPE Vertica from Spotfire Information Designer.

Product: TIBCO Spotfire Server

Version: All Supported Versions

OS: All Supported Operating Systems

There is no default data source template for HPE Vertica included in the TIBCO Spotfire Server configuration. It is possible to create a custom data source template which can be used to create a JDBC connection to your HPE Vertica instance for use in the Information Designer. This can then be used to create data sources and information links.

1. Download the HPE Vertica driver .jar file from the vendor.

2. Place that .jar file in the /tomcat/lib/ folder.

3. Open the Spotfire configuration tool - Start > Programs > TIBCO Spotfire Server X.X > Configure TIBCO Spotfire Server .

4. Enter the configuration tool password to unlock the configuration.

5. Click on "Configuration" tab.

6. Select "Data Source Templates" in the left panel.

7. Click on "New..." button at the bottom.

8. In the "Add data source template" dialog:

o In the "Name" field, enter "Vertica".

o In the "Data source template" input field, enter the following basic example template:

Vertica Vertica com.vertica.jdbc.Driver jdbc:vertica://VerticaHost:portNumber/databaseName

true

o Click OK.

9. Click on the check box located next to the new template to enable it. Make sure the status bar at the bottom shows "XML Parsed OK" which means the driver is present in the tomcat\lib folder and the XML is valid.

10. Click the "Save Configuration" button and save the configuration to the database.

11. Restart the TIBCO Spotfire Server service.

Now when you open the Information Designer and create a new Data Source, you will see the new data source template. If you have any issues, check the server.log and sql.log in /tomcat/logs/ for any errors.