Connection name used by the Workflow Manager. Connection name cannot contain spaces or other special characters, except for the underscore.

Database user name with the appropriate read and write database permissions to access the database.

To define the user name in the parameter file, enter session parameter $Param

Name

as the user name, and define the value in the session or workflow parameter file. The

PowerCenter Integration Service

interprets user names that start with $Param as session parameters.

You can connect to a database that runs on a network that uses Kerberos authentication. To configure Kerberos authentication for the database connection, set the user name to the reserved word

PmKerberosUser

. If you use Kerberos authentication, the connection uses the credentials of the user account that runs the session to connect to the database. The user account must have a user principal on the Kerberos network where the database runs.

Indicates the password for the database user name is a session parameter, $Param

Name

. If you enable this option, define the password in the workflow or session parameter file, and encrypt it using the

pmpasswd

CRYPT_DATA option. Default is disabled.

Password for the database user name.

If you set the user name to

PmKerberosUser

to use Kerberos authentication for the database connection, set the password to the reserved word

PmKerberosPassword

. The connection uses the credentials of the user account that runs the session to connect to the database.

Code page associated with the database.

When you run a session that extracts 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.

The name of the Teradata database machine.

Teradata database name.

If you do not enter a database name, Teradata PT API uses the default login database name.

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.

Must be a positive integer. Default is 4.

Maximum number of sessions that Teradata PT API establishes with the Teradata database.

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

Minimum number of Teradata PT API sessions required for the Teradata PT API job to continue.

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

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.

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

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

Default is disabled.

Maximum block size, in bytes.

Teradata PT API uses this property to read or write the data block size from source or target 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.

Default is Native.

Teradata PT API operator type:

Default is Stream.