Skip to main content

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!