Test Data Management
- Test Data Management 10.5
- All Products
Property
| Description
|
---|---|
Name
| Required. Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, start with a number, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
|
Connection Type
| Required. The connection type. Select Teradata Parallel Transporter.
|
Description
| The description of the connection. The description cannot exceed 255 characters.
|
User Name
| Required. The database user name.
|
Use Parameter in Password
| Indicates the password for the database user name is a session parameter. $Param Name . Define the password in the workflow or session parameter file, and encrypt it using the
pmpasswd CRYPT_DATA option.
Used for data subset and data masking operations. Default is disabled.
|
Password
| Required. The password for the database user name.
|
Owner
| The owner of the connection. Default is the user that creates the connection. You can change the owner of the connection.
|
JDBC Login Password
| Required if Use Parameter in Password is selected. The password for the JDBC user.
Used for import from source and data discovery operations.
|
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.
|
Data Access Connection String
| The connection string used to access data from the database. Enter <database name>.
|
Database Name
| Teradata database name. If you do not enter a database name, Teradata PT API uses the default login database name.
|
TDPID
| Name 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. Must be a positive, non-zero 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 Integration Service.
Default is 6400.
|
System Operator
| System operator to extract or load data. Select one of the following values:
|