Configuring access to Teradata databases

To configure access to Teradata databases, you must install Teradata tools and Teradata transporters and set the environment variables.

Before you begin

Install database client libraries.

Procedure

Install Teradata tools and utilities on all nodes that run parallel jobs. For more information, see the installation instructions in the Teradata product documentation.
Install the Teradata Parallel Transporter. For more information, see the installation instructions in the Teradata product documentation.

Set the environment variables.

Operating System Environment variables

AIX

Table 1. Required Environment variables
Operating System	Environment variables
AIX	`TWB_ROOT=/usr/tbuild/08.01.00.02 PATH=$TWB_ROOT/bin:$PATH LIBPATH=$TWB_ROOT/lib:$LIBPATH NLSPATH=$TWB_ROOT/msg/%N export TWB_ROOT PATH LIBPATH NLSPATH`
HP-UX	`TWB_ROOT=/usr/tbuild/08.01.00.02 PATH=$TWB_ROOT/bin:$PATH SHLIB_PATH=$TWB_ROOT/lib:$SHLIB_PATH NLSPATH=$TWB_ROOT/msg/%N export TWB_ROOT PATH SHLIB_PATH NLSPATH`
Solaris	`TWB_ROOT=/usr/tbuild/08.01.00.02 PATH=$TWB_ROOT/bin:$PATH LD_LIBRARY_PATH=$TWB_ROOT/lib:$LD_LIBRARY_PATH NLSPATH=$TWB_ROOT/msg/%N export TWB_ROOT PATH LD_LIBRARY_PATH NLSPATH`

TWB_ROOT=/usr/tbuild/08.01.00.02
PATH=$TWB_ROOT/bin:$PATH
LIBPATH=$TWB_ROOT/lib:$LIBPATH
NLSPATH=$TWB_ROOT/msg/%N
export TWB_ROOT PATH LIBPATH NLSPATH

HP-UX

TWB_ROOT=/usr/tbuild/08.01.00.02
PATH=$TWB_ROOT/bin:$PATH
SHLIB_PATH=$TWB_ROOT/lib:$SHLIB_PATH
NLSPATH=$TWB_ROOT/msg/%N
export TWB_ROOT PATH SHLIB_PATH NLSPATH

Solaris

TWB_ROOT=/usr/tbuild/08.01.00.02
PATH=$TWB_ROOT/bin:$PATH
LD_LIBRARY_PATH=$TWB_ROOT/lib:$LD_LIBRARY_PATH NLSPATH=$TWB_ROOT/msg/%N export TWB_ROOT PATH LD_LIBRARY_PATH NLSPATH