Teradata Connector Guide > Teradata 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 Teradata Connector.
Description
Description of the Teradata Connector.
Type
The type of connection. Select Teradata.
Runtime Environment
The name of the run-time environment where you want to run the tasks.
You cannot use the Informatica Cloud 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 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 runs 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 when it returns data to the Secure Agent.
Minimum is 256. Maximum is 64,000. Default is 64,000.
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.
Default is Native.
Metadata Advanced Connection Properties
The values to set the optional properties of the JDBC driver to fetch the metadata.
For example, tmode=ANSI.
User Name
Database user name with the appropriate read and write database permissions to access the database.
Password
Password for the database user name.