Administrator Guide

10.5
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0

Back Next

Teradata Parallel Transporter Connections

You can create a Teradata Parallel Transporter connection in Test Data Manager to perform data subset and data masking operations. You cannot perform inplace masking and other tasks that require update override queries on Teradata Parallel Transporter connections.

The following table describes the database connection properties for a Teradata Parallel Transporter database:

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: Stream. Performs update, insert, upsert, and delete operations against Teradata database tables in near real-time mode. Load. Bulk loads data into an empty Teradata database table. Update. Performs update, insert, upsert, and delete operations against Teradata database tables. Export. Extracts data from Teradata. Default is Stream.

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Teradata Parallel Transporter Connections

Teradata Parallel Transporter Connections