Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Connection property
| Description
|
|---|---|
Connection Name
| Name of the connection.
|
Description
| Description of the connection.
|
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 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:
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:
Default is Native.
|
Kerberos Artifacts Directory
| Directory that contains the 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 Qualification
| 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 Qualification 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.
|
