Connections > Teradata connection properties
  

Teradata connection properties

When you set up a Teradata connection, you must configure the connection properties.
The following table describes the Teradata connection properties:
Connection property
Description
Connection Name
Name of the connection.
Description
Description of the connection.
Type
Teradata
Runtime Environment
The name of the run-time environment where you want to run the tasks.
You cannot use the Hosted Agent for Teradata Connector.
TDPID
The name or IP address of the Teradata database machine.
Tenacity
Amount of time, in hours, that Teradata PT API continues trying to log on when the maximum number of operations runs on the Teradata database.
Specify a positive integer. Default is 4.
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.
Max Sessions
Maximum number of sessions that Teradata PT API establishes 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 Max Sessions value.
Default is 1.
Sleep
Amount of time, in minutes, that Teradata PT API pauses before it retries to log on 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 higher.
If the Teradata Database version is lower than 16.20, then 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 Teradata logs and verify the Teradata documentation of the same version.
Authentication Type
Method to authenticate the user.
Select one of the following authentication types:
  • - Native. Authenticates your user name and password against the Teradata database specified in the connection.
  • - LDAP. Authenticates user credentials against the external LDAP directory service.
  • - KRB5. Authenticates to the Teradata database through Kerberos.
Default is Native.
Kerberos Artifacts Directory
Directory that contains Kerberos configuration files named krb5.conf and IICSTPT.keytab.
Applicable when you select KRB5 as the authentication type.
Metadata Advanced Connection Properties
The values to set the optional properties of the JDBC driver to fetch the metadata.
For example, tmode=ANSI.
Enable Metadata Quotification
Select this option to enable the Teradata connection to read reserved words used as table or column names from the Teradata database.
By default, the Enable Metadata Quotification checkbox is not selected and the Secure Agent does not read reserved words from Teradata.
User Name
Database user name with the appropriate read and write database permissions to access the database.
If you select KRB5 as the authentication type, you must specify the Kerberos user name.
Password
Password for the database user name.
If you select KRB5 as the authentication type, you do not need to specify the Kerberos user password.