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).
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.
-
Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.
-
Install Teradata Database Client 17.20 or later for Linux.
Download the driver from https://downloads.teradata.com/download/connectivity/odbc-driver/linux
-
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
-
Run the following command:
LD_LIBRARY_PATH=$TD_CLIENT:/opt/attunity/replicate/lib:/lib64:/usr/lib64; export LD_LIBRARY_PATH
-
To verify that the path is updated, run the following command:
echo $LD_LIBRARY_PATH
-
Run the following command:
export ODBCINI=/opt/teradata/client/17.20/odbc_64/odbc.ini
- Add the export commands to the site_arep_login.sh file.
-
Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.
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.