Connect to Teradata

Property	Description
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Type	Teradata
Runtime Environment	The name of the runtime environment where you want to run tasks. Specify a Secure Agent.
TDPID	The name or IP address of the Teradata database machine.
Database Name	The Teradata database name. If you do not enter a database name, Teradata PT API uses the default login database name.
Code Page	Code page associated with the Teradata database. Select one of the following code pages: - MS Windows Latin 1. Select for ISO 8859-1 Western European data. - UTF-8. Select for Unicode and non-Unicode data. When you run a task that extracts data from a Teradata source, the code page of the Teradata PT API connection must be the same as the code page of the Teradata source.

Authentication types

Native authentication

To configure native authentication, you need the user name and password from your Teradata account.

The following table describes the basic connection properties for Native authentication:

Property	Description
Username	User name with the appropriate read and write database permissions to access the Teradata database.
Password	Password for the database user name.

LDAP authentication

To configure LDAP authentication, you need to authenticate user credentials against the external LDAP directory service.

The following table describes the basic connection properties for LDAP authentication:

Property	Description
Username	User name with the appropriate read and write database permissions to access the LDAP database.
Password	Password for the LDAP database user name.

KRB5 authentication

To configure KRB5 authentication, you must configure the Secure Agent hosted on the Linux machine and ensure that the Kerberos artifacts directory contains the Kerberos configuration files.

The following table describes the basic connection properties for KRB5 authentication:

Property	Description
Username	The Kerberos user name that authenticates to the Teradata database.

The following table describes the advanced connection properties for KRB5 authentication:

Property	Description
Kerberos Artifacts Directory	Directory that contains the Kerberos configuration files. This directory contains the following configuration files: - krb5.conf - IICSTPT.keytab

Advanced settings

Property	Description
Tenacity	Amount of time, in hours, that the Teradata PT API continues attempting to log in again when the maximum number of operations runs on the Teradata database. Specify a positive integer. Default is 4.
Max Sessions	Maximum number of sessions allowed for the Teradata PT API to establish connection with the Teradata database. Specify a positive, non-zero integer. Default is 4.
Min Sessions	Minimum number of Teradata PT API sessions required for the Teradata PT API job to continue. Specify a positive integer between 1 and the value specified in the Max Sessions field. Default is 1.
Sleep	Amount of time, in minutes, that the Teradata PT API waits before it attempts to log in again when the maximum number of operations run on the Teradata database. Specify a positive, non-zero integer. Default is 6.
Data Encryption	Enables full security encryption of SQL requests, responses, and data. Default is disabled.
Block Size	Maximum block size, in bytes. Teradata PT API uses this property to read the data block size from source through the Export operator. Maximum is 16775168 bytes for Teradata database version 16.20 and later. If the Teradata database version is earlier than 16.20, Teradata scales down the block size from 16775168 bytes to the maximum allowed value. The block size 16775168 is not allowed in the Spool mode. For more information, see the Teradata logs and verify the Teradata documentation of the same version.
Metadata Advanced Connection Properties	The optional properties for the JDBC driver to fetch the metadata from Teradata. For example, tmode=ANSI.
Enable Metadata Quotification	Determines if a Teradata connection reads reserved words used in table or column names from the Teradata database. Select the Enable Metadata Quotification checkbox for the Secure Agent to read reserved words from Teradata.