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 database in a Replicate task. Teradata Database Client requires the DataDirect ODBC driver manager (provided with Teradata Database Client).
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.
These instructions assume that Teradata Database Client 15.10 is being installed in the following location:
/opt/teradata/client/15.10
If you are installing another version or to a different location, simply change the instructions accordingly.
- Install Replicate on the Linux machine as described in Setting up Qlik Replicate on Linux.
-
Install Teradata Database Client 15.10 or later for Linux.
-
Run the following commands:
TD_CLIENT=/opt/teradata/client/15.10/odbc_64/lib:/opt/teradata/client/15.10/lib64; export TD_CLIENT
ODBCINI=/opt/teradata/client/15.10/odbc_64/odbc.ini; export ODBCINI
ODBCINST=/opt/teradata/client/15.10/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/15.10/odbc_64/odbc.ini
- Add the export commands to the site_arep_login.sh file.
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.