Administration of Teradata Connector
As a user, you can use Teradata Connector after the organization administrator ensures that users have access to the Secure Agent directory that contains the success and error files. This directory path must be the same on each Secure Agent machine in the run-time environment.
Before you use Teradata Connector, the organization administrator must also perform the following tasks:
- •Install the Teradata Parallel Transporter utilities.
- •Set the environment variables.
- •Verify the database privileges.
The Teradata JDBC driver is packaged with the Secure Agent. When you install the Secure Agent, the JDBC driver is installed and the JDBC jars are copied to the Secure Agent machine.
Install the Teradata Parallel Transporter Utilities
Before you use Teradata Connector, install the Teradata Parallel Transporter tilities on the machines where the Secure Agent runs.
The following table lists the Teradata Parallel Transporter utilities for versions 15.10x and 16.10.x :
Teradata Parallel Transporter Utilities |
|---|
Teradata Parallel Transporter Base |
Teradata Parallel Transporter Stream Operator |
Teradata CLIv2 |
Teradata Generic Security Services |
Shared ICU Libraries for Teradata |
Set Environment Variables
You must configure Java and Teradata environment variables before you can use Teradata Connector.
The following table describes the environment variables you must set on UNIX:
Environment Variable | Value |
|---|
THREADONOFF | On UNIX and Linux operating systems, set the THREADONOFF environment variable to 1 to enable multithreading support for Teradata processes. |
NLSPATH | Set to the location of the opermsgs.cat file. For example, /opt/teradata/client/15.10/msg/%N |
Also, set the shared library environment variable based on the operating system. The following table describes the shared library variables for each operating system:
Operating System | Value |
|---|
Windows | PATH |
Linux | LD_LIBRARY_PATH |
For example, use the following syntax for Linux:
- •Using a Bourne shell:
export LD_LIBRARY_PATH="/opt/teradata/client/15.10/lib64:${LD_LIBRARY_PATH}"
- •Using a C shell:
LD_LIBRARY_PATH="/opt/teradata/client/15.10/lib64:${LD_LIBRARY_PATH}
After you set the environmental variables, you must restart the Secure Agent.
Database Privileges
Before you use Teradata Connector, verify that you have read and write permissions on the Teradata database and select privileges on specific Data Dictionary tables.
Verify that you have the following database privileges:
- •Read permission to read data from Teradata.
- •Write permission to write data to Teradata.
- •Select privileges on DBC.Tables, DBC.Columns, DBC.UDTInfo, and DBC.Databases.
For information about select privileges, see the Teradata JDBC Driver documentation.