Quick Guide: Installing and Configuring Teradata TTU on Linux for Qlik Replicate

john_wang · Jun 9, 2025 2:35:36 AM

This guide provides a step-by-step process for installing and configuring the TTU (Teradata Tools and Utilities) for use with Qlik Replicate Teradata Target Endpoint. Note that Qlik Replicate should already be installed before proceeding.

In this article the TTU 20 is installed on RHEL 10.00. The steps are similar for TTD 17.20 on other versions of CentOS 8.x, RHEL 8.x/9.x, etc.

For more information, Setting up Qlik Replicate on Linux, a comprehensive list of supported Linux platforms and prerequisites, refer to the Supported Linux Platforms section in the User Guide.

Installation Steps

Access https://downloads.teradata.com/download/tools/teradata-tools-and-utilities-linux-installation-packag...
To access this download, you must log in.
Download the Linux 64-bit TTU 20.00 (or 17.20) and upload it to your Linux Server (in folder "/kit")

TeradataToolsAndUtilitiesBase__linux_x8664.20.00.23.00-1.tar.gz

Optional: TTU 20.00 Linux - Installation Guide

Uncompress the gzip file and extract the installation files:

gzip -d TeradataToolsAndUtilitiesBase__linux_x8664.20.00.23.00-1.tar.gz
tar -xf TeradataToolsAndUtilitiesBase__linux_x8664.20.00.23.00-1.tar

Launch the Installation:

cd /kit/TeradataToolsAndUtilitiesBase 
./setup.sh

..................................................................
1. bteq         - 20.00.00.07  - Teradata BTEQ Application                           923 KB
2. fastexp      - 20.00.00.02  - Teradata FastExport Utility                         711 KB
3. fastld       - 20.00.00.03  - Teradata FastLoad Utility                           520 KB
4. jmsaxsmod    - 20.00.00.02  - Teradata JMS Access Module                          107 KB
5. mload        - 20.00.00.02  - Teradata MultiLoad Utility                          774 KB
6. mqaxsmod     - 20.00.00.01  - WebSphere(r) Access Module for Teradata             263 KB
7. npaxsmod     - 20.00.00.02  - Teradata Named Pipes Access Module                   93 KB
8. s3axsmod     - 20.00.00.08  - Teradata Access Module for S3                     20056 KB
9. gcsaxsmod    - 20.00.00.07  - Teradata Access Module for Google Cloud Storage   16996 KB
10. azureaxsmod  - 20.00.00.05  - Teradata Access Module for Azure                  20341 KB
11. kafkaaxsmod  - 20.00.00.04  - Teradata Kafka Access Module                      16031 KB
12. sqlpp        - 20.00.00.01  - Teradata C Preprocessor                             657 KB
13. tdodbc       - 20.00.00.22  - Teradata ODBC Driver                              96228 KB
14. tdwallet     - 20.00.00.25  - Teradata Wallet Utility                           18375 KB
15. tptbase      - 20.00.00.15  - Teradata Parallel Transporter Base                75502 KB
16. tpump        - 20.00.00.03  - Teradata TPump Utility                              932 KB

Enter one or more selections (separated by space): 1 3 5 13 15 16

While Qlik Replicate does not require "1. bteq", it is strongly recommended for troubleshooting connectivity issues.

Merge lines from
```
/opt/teradata/client/ODBC_64/odbcinst.ini
```
to
```
/etc/odbcinst.ini
```
[Teradata Database ODBC Driver 20.00]
Description=Teradata Database ODBC Driver 20.00
Driver=/opt/teradata/client/20.00/odbc_64/lib/tdataodbc_sb64.so
# Note: Currently, Data Direct Driver Manager does not support Connection Pooling feature.
CPTimeout=60

The default .so file folder is /opt/teradata/client/20.00/odbc_64/lib
(Optional) Add internal parameter "provider" and set its value to "Teradata Database ODBC Driver 20.00"

Verify the DSN name in step five.
Edit file /opt/attunity/replicate/bin/site_arep_login.sh

add /opt/teradata/client/20.00/odbc_64/lib to variable LD_LIBRARY_PATH

For example:
```
export LD_LIBRARY_PATH=/usr/lib64:/opt/attunity/replicate/lib:/opt/teradata/client/20.00/odbc_64/lib:/usr/lib/oracle/23/client64/lib
```
(Optional) Edit file /etc/hosts to add COP Aliases. Make sure that the database name added to the hosts files is the same as the database specified in the Default database field in the Teradata Database target database settings.

For example:

192.168.33.200 targetdbcop1

Where 192.168.33.200 is the IP Address of the Teradata 20.00 Server. targetdb is the database name specified in Teradata target Endpoint:
Restart the Qlik Replicate Service:
```
systemctl restart areplicate
```
Access the Qlik Replicate console using the following URL

https://192.168.33.100:3552/attunityreplicate

Where 192.168.33.100 is the Qlik Replicate Linux Server IP Address.

Teradata client and server connectivity test

To verify the connectivity between the Teradata TTU client and server, you can use bteq and isql by running the following commands:

sudo su - attunity
cd /opt/attunity/replicate/bin
source arep_login.sh
bteq
logon 192.168.33.200/dbc;
Password: dbc
select * from targetdb.kit;

Important Notes

No need to create symbolic links for the ODBC driver libraries.
The AREP_ODBC_DRIVER_MANAGER environment variable is not required when using TTU 17.20 or later.
There is no need to set the ODBCINI or ODBCINSTINI environment variables — Qlik Replicate uses the default configuration files located under /etc.

Quick Guide: Installing and Configuring Teradata TTU on Linux for Qlik Replicate