Preparing the Teradata Environment

In this section:

How to:

To configure and use the ODBC or CLI Adapter for Teradata, the Teradata Client components must be installed and configured according to the Teradata Tools and Utilities Installation Guide. TeraGSS, ICU, and ODBC and/or CLI are required. The path to the ODBC or CLI libraries directory must be added to SYSTEM LIBRARY PATH prior to starting the server.

If you are using the z/OS server, the Teradata Channel-Attached CLI needs to be installed. Use the Web Console to configure the Teradata Adapter.


Top of page

x
Procedure: How to Set Up the Environment on Microsoft Windows Using ODBC or CLI

On Microsoft Windows, the Teradata environment is set up during the installation of the product.


Top of page

x
Procedure: How to Set Up the Environment on UNIX

You can access Teradata using the optional UNIX environment variable, ODBCINI. The ODBCINI variable points to the absolute path of the .odbc.ini file.

For example:

ODBCINI=/usr/odbc/.odbc.ini
export ODBCINI

Note: You must not use ODBCINI, if the $HOME directory contains the .odbc.ini file.


Top of page

x
Configuring Teradata CLI for Unicode

The Teradata CLI adapter supports Unicode UTF8 format if:

Contact your DBA to determine whether international language support has been enabled in your Teradata system and/or consult the Teradata documentation for details about International Character Set Support.

Note that, at the present time, when Unicode is enabled the length of a Teradata Column Name and/or TITLE cannot exceed 21 characters.


iWay Software