Prerequisites
The following section describes the prerequisites for working with Qlik Replicate on Windows or Linux and the Vertica target database.
Replicate server for Windows
The following section describes the steps you need to perform to work with Qlik Replicate for Windows and Vertica as a target database in a Replicate task:
On the Qlik Replicate Server machine, install version 11.x of the following drivers:
- Vertica ODBC 64-bit
- VSQL CLI Client
Replicate server for Linux
The following section describes the steps you need to perform to work with Qlik Replicate for Linux and Vertica as a target database in a Replicate task:
-
On the Qlik Replicate Server machine, install Vertica ODBC driver 11.x for Linux.
Example:
vertica-client-11.1.0-0.x86_64
-
Makes sure that the /etc/odbcinst.ini file contains the following entry for Vertica, as in the following example:
[Vertica]
Driver = /opt/vertica/lib64/libverticaodbc.so
DriverODBCVer = 3.0
UsageCount = 1