Prerequisites
The following describes the prerequisites necessary to prepare your environment to work with Qlik Replicate and Teradata Database.
Teradata Database must be installed in your network and be reachable from the computer where Qlik Replicate is installed.
Replicate server for Windows
You must install the following components on the Qlik Replicate Server machine:
-
Teradata Database ODBC Driver 17.20 for Windows.
Download the driver from https://downloads.teradata.com/download/connectivity/odbc-driver/windows
- Teradata Database Parallel Processor API (TPT API) with the load and Stream TPT operators version 17.20.
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).
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.
-
Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.
-
Install the following Teradata client components:
-
Install Teradata Database ODBC Driver 17.20 for Linux.
Download the driver from https://downloads.teradata.com/download/connectivity/odbc-driver/linux
- Teradata Database Parallel Processor API (TPT API) with the Load and Stream TPT operators
-
-
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:
[ODBC DRIVERS]
Teradata=Installed
[Teradata]
Driver=/opt/teradata/client/17.20/odbc_64/lib/tdata.so
DriverODBCVer=3.51
-
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:
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
-
Add the Teradata Database name to the hosts file as described in Editing the hosts file.
-
Run the following commands:
export LD_LIBRARY_PATH=$TD_CLIENT:/opt/attunity/replicate/lib:/lib64:/usr/lib64
export ODBCINI=/opt/teradata/client/17.20/odbc_64/odbc.ini
export AREP_ODBC_DRIVER_MANAGER=/opt/teradata/client/17.20/odbc_64/lib/libodbc.so
-
Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.