Prerequisites

The following section describes the prerequisites for working with Qlik Replicate and an ODBC source endpoint.

Qlik Replicate Server for Windows

You can connect an endpoint to Qlik Replicate using ODBC by indicating the DSN (Data Source Name). In this case you must be sure that a DSN is defined for the ODBC endpoint on the computer where Qlik Replicate is installed.

1. Install an endpoint client on the computer where Qlik Replicate is installed. The client you install depends on the ODBC provider you are using. For example, if you are using an IBM DB2 endpoint, install an IBM DB2 client.

   Information note

   You must use a 64-bit ODBC provider client to work with Qlik Replicate.

2. Use the ODBC Data Source Administrator to create a System DSN. The Data Source is located in the Windows control panel.

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 source 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