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.
- On the Qlik Replicate Server machine, install the ODBC client that you want to use (e.g. postgreSQL).
-
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 noteTo access an IBM DB2 for LUW target using ODBC, make sure that you specify the libdb2o.so driver (and not libdb2.so).
-
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