Preparing Vertica datasources for Unica Campaign
Follow these guidelines to use a Vertica database as a data source for Unica 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
-
Install the HP Vertica client driver on the server where the Unica Campaign analytical server (listener) is installed.
Obtain the driver here: http://www.vertica.com/resources/vertica-client-drivers/
-
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