Preparing Vertica datasources for Campaign

Follow these guidelines to use a Vertica database as a data source for Campaign.

About this task

For information about supported versions, see the Recommended Software Environments and Minimum System Requirements.

To download the latest Vertica documentation in zip or tar format: http://www.vertica.com/v-zone/product_documentation

Procedure

  1. Install the HP Vertica client driver on the server where the Campaign analytical server (listener) is installed.

    Obtain the driver here: http://www.vertica.com/resources/vertica-client-drivers/

  2. Configure the odbc.ini file.

    Sample odbc.ini file entry

    
[ODBC Data Sources]

DriverManagerEncoding=UTF-16
ODBCInstLib=/usr/local/lib/libodbcinst.so
ErrorMessagesPath=/opt/vertica/lib64
LogLevel=4
LogPath=/tmp

[Vertica]
Description = VerticaDSN ODBC driver
Driver = /opt/vertica/lib64/libverticaodbc.so
Database = exampleDB
Servername = example.com
UserName = dbadmin
Password = example_password
Port = 5433