PowerCenter
- PowerCenter 10.5.6
- All Products
Property
| Description
|
---|---|
Name
| Connection name used by the Workflow Manager. Connection name cannot contain spaces or other special characters, except for the underscore.
|
User Name
| 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.
|
Use Parameter in Password
| 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
| 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
| 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.
|
Attribute
| Description
|
---|---|
TDPID
| The name of the Teradata database machine.
|
Database Name
| Teradata database name.
If you do not enter a database name, Teradata PT API uses the default login database name.
|
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.
Must be a positive integer. Default is 4.
|
Max Sessions
| Maximum number of sessions that Teradata PT API establishes with the Teradata database.
Must be 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.
Must be 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.
Must be 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 PowerCenter Integration Service.
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.
|
System Operator
| Teradata PT API operator type:
Default is Stream.
|