Use This Connection for Data Access

Enable data access to the connection.

TDPID

The name of the Teradata database machine.

Database Name

Teradata database name.

Tenacity

Amount of time, in hours, that

Data Integration Hub

continues trying to log on when the maximum number of operations runs on the Teradata database.

Must be a positive, non zero integer. Default is 4.

Max Sessions

Maximum number of sessions that

Data Integration Hub

establishes with the Teradata database.

Must be a positive, non zero integer. Default is 4.

Min Sessions

Minimum number of

Data Integration Hub

sessions required for the

Data Integration Hub

job to continue.

Must be a positive integer between 1 and the Max Sessions value. Default is 1.

Sleep

Amount of time, in minutes, that

Data Integration Hub

pauses before it retries to log on when the maximum number of operations runs on the Teradata database.

Must be a positive, non zero integer. Default is 6.

Enable Data Encryption

Enables full security encryption of SQL requests, responses, and data.

Default is disabled.

Block Size

Maximum block size, in bytes,

Data Integration Hub

uses when it returns data to the PowerCenter Integration Service.

Minimum is 256. Maximum is 64,330. Default is 64,000.

System Operator

Data Integration Hub

operator type:

Export. Exports large data sets from Teradata tables or views. Select Export to use the connection in publications.
Update. Batch updates, inserts, upserts, and deletes data in Teradata database tables. Select Update to use the connection in subscriptions.

Default is Update.

Code Page

Code page associated with the database.

When you run a session that extracts from a Teradata source, the code page of the

Data Integration Hub

connection must be the same as the code page of the Teradata source.