Qlik Replicate Server for Linux

The following section describes the steps you need to perform to work with Qlik Replicate for Linux and ODBC as a target endpoint in a Qlik Replicate task.

1. On the Qlik Replicate Server machine, install the ODBC client that you want to use (e.g. postgreSQL).

2. Makes sure that the /etc/odbcinst.ini file contains the correct entry for the driver you installed, as in the following example:

   [PostgeSQL]

   Description = ODBC for PostgreSQL

   Driver = /usr/lib/psqlodbc.so

   Setup = /usr/lib/libodbcpsqlS.so

   Driver64 = /usr/lib64/psqlodbc.so

   Setup64 = /usr/lib64/libodbcpsqlS.so

   FileUsage = 1

   Information note

   To access an IBM DB2 for LUW target using ODBC, make sure that you specify the libdb2o.so driver (and not libdb2.so).

3. Define a DSN for the installed driver by editing the /etc/odbc.ini file, as in the following example:

   [Postgre_DSN]

   Description = Test

   Driver = /usr/lib64/psqlodbc.so

   Endpoint = MyDatabase

   Servername = 12.3.45.678

   Port = 5432