IBM Support

How to create an Impact Generic SQL Data Source for HP Vertica

How To


Summary

These are the steps you need to follow to create a Generic SQL Data Source in Netcool Impact for connection to an HP Vertica database.

Steps

The first thing to do is to obtain the JDBC Driver .jar file for your version of Vertica and put it into the $IMPACT_HOME/dsalib directory on your Impact server.  Remember to put it on all servers in a Impact cluster.
It is also a good idea to prototype your connection using a free standing JDBC tool such as SQuirreL or DBVisualiser.  This will allow you to make sure the authentication and connection details are correct before you create the data source in Impact.
Once you are sure the connection details and credentials are correct, from the Impact GUI, in the Data Model tab, in the pull-down for New Data Source, select:  Database (SQL) -> Generic SQL.
Then, in the panel, enter the following:

Data Source Name:  You can use any unique name of your choice - alphanumeric.

JDBC Driver Name:  This should be:  com.vertica.jdbc.Driver  This is the driver class name and not the name of the driver .jar file.

Username:  This the username to access the database. 

Password:  The password for the above user.

Select a non-zero value for the Maximum SQL Connections, a number between 2 and 5 is fine to start with.

Initially I suggest you select 'Disable backup' initially, you might need to change this if you have an HA database configuration.

Hostname:  The hostname for the database server.

Port:  The port for the database server - the default seems to be 5433 for Vertica.

URL:  Typically this will be something like:   jdbc:vertica://<Hostname>:<Port>/<DatabaseName>  where <Hostname> and <Port> are the same values you specified above and <DatabaseName> is the name of the Vertica database you are accessing.

Example:

Data Source Name:  TestVertica

JDBC Driver Name:  com.vertica.jdbc.Driver

Username:  labuser 

Password:  labpass1

Maximum SQL Connections: 2

Failure policy:  Disable backup

Hostname:  Server12.lab.ibm.com

Port:  5433

URL:  jdbc:vertica://Server12.lab.ibm.com:5433/MyDatabase

Document Location

Worldwide

[{"Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSCP78Y","label":"Netcool/Impact"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
10 December 2020

UID

ibm16380848

Page Feedback