Skip to main content Skip to complementary content

Prerequisites

The following section describes the prerequisites for working with Qlik Replicate and a Teradata Database Source.

Replicate Server for Windows

Install Teradata Database ODBC Driver 17.20 for Windows.

Download the driver from https://downloads.teradata.com/download/connectivity/odbc-driver/windows

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 source endpoint in a Replicate task. Teradata Database Client requires the DataDirect ODBC driver manager (provided with Teradata Database Client).

Information note

These instructions assume that Teradata Database Client 17.20 is being installed in the following location:

/opt/teradata/client/17.20

If you are installing another version or to a different location, simply change the instructions accordingly.

  1. Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.

  2. Install Teradata Database Client 17.20 or later for Linux.

    Download the driver from https://downloads.teradata.com/download/connectivity/odbc-driver/linux

  3. Run the following commands:

    TD_CLIENT=/opt/teradata/client/17.20/odbc_64/lib:/opt/teradata/client/17.20/lib64; export TD_CLIENT

    ODBCINI=/opt/teradata/client/17.20/odbc_64/odbc.ini; export ODBCINI

    ODBCINST=/opt/teradata/client/17.20/odbc_64/odbcinst.ini; export ODBCINST

  4. Run the following command:

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

  5. To verify that the path is updated, run the following command:

    echo $LD_LIBRARY_PATH

  6. Run the following command:

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

  7. Add the export commands to the site_arep_login.sh file.
  8. Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.

Information note

A Replicate task cannot be defined with endpoints that use different ODBC Driver Managers. Teradata Database source is accessed using the DataDirect ODBC Driver Manager while most target endpoints (that can be accessed by Replicate running on Linux) are accessed using the unixODBC Driver Manager.

Consequently, when replicating to all target endpoints excluding Oracle, Hadoop, and File (which do not use the unixODBC Driver Manager), 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.

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!