Skip to main content
Qlik Resources

Replicate server for Linux

The following section describes the steps you need to perform to work with Qlik Replicate for Linux and Teradata Database as a target database in a Replicate task. Teradata Database Client requires the DataDirect ODBC driver manager (provided with Teradata Database Client).

Information note

A Replicate task cannot be defined with endpoints that use different ODBC Driver Managers. Teradata Database target is accessed using the DataDirect ODBC Driver Manager. With the exception of Oracle, Hadoop, File and Replicate Connect sources (which are not subject to the above limitation), all other source endpoints use the unixODBC Driver Manager.

To configure a task with a unixODBC source and a DataDirect target (e.g. Microsoft SQL Server to Teradata Database Target), you need to use the Replicate File Channel. For more information about setting up a task using the File Channel, see Using the Qlik Replicate file channel.

  1. Install Replicate on the Linux machine as described in Setting up Qlik Replicate on Linux.

  2. Install the following Teradata client components:

    • To work with Teradata Database 15, install Teradata Database ODBC Driver 15.00 for Linux. To work with Teradata Database 16 or later, you need to install Teradata Database ODBC Driver 16.20 for Linux.
    • Teradata Database Parallel Processor API (TPT API) with the Load and Stream TPT operators

  3. Open the Teradata odbcinst.ini file:

    cat $TD_CLIENT_DIR/odbc_64/odbcinst.ini

    Then verify that it contains a definition for the Teradata ODBC client (version 14.10 in the example below):

    [ODBC DRIVERS]

    Teradata=Installed

    [Teradata]

    Driver=/opt/teradata/client/14.10/odbc_64/lib/tdata.so

    DriverODBCVer=3.51

  4. Check that directory /usr/lib64 contains symbolic links to the DataDirect driver manager shared libraries:

    ll /usr/lib64/libodbc*.so

    The output should look like this (e.g. for version 14.10):

    lrwxrwxrwx 1 root root 47 Oct 28 14:58 /usr/lib64/libodbcinst.so ->

    /opt/teradata/client/ODBC_64/lib/libodbcinst.so

    lrwxrwxrwx 1 root root 43 Oct 28 14:58 /usr/lib64/libodbc.so ->

    /opt/teradata/client/ODBC_64/lib/libodbc.so

  5. Add the Teradata Database name to the hosts file as described in Editing the hosts file.

  6. Run the following commands (e.g. for version 14.10):

    export LD_LIBRARY_PATH=$TD_CLIENT:/opt/attunity/replicate/lib:/lib64:/usr/lib64

    export ODBCINI=/opt/teradata/client/14.10/odbc_64/odbc.ini

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!

Leave your feedback here