Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Appendix A: Session Properties Reference
  17. Appendix B: Workflow Properties Reference

PowerExchange for Teradata Parallel Transporter Connections

PowerExchange for Teradata Parallel Transporter Connections

When you configure a Teradata Parallel Transporter API connection, you define the connection attributes that the PowerCenter Integration Service uses to connect to Teradata.
The following table describes the Teradata Parallel Transporter API connection properties that you must configure:
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.
The following table describes the Teradata connection properties that you must configure:
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:
  • Native. Authenticates your user name and password against the Teradata database specified in the connection.
  • LDAP. Authenticates user credentials against the external LDAP directory service.
  • KRB5. Authenticates the credentials of the user account that runs the session against the Kerberos network where the database runs.
Default is Native.
System Operator
Teradata PT API operator type:
  • Export. Extracts data from Teradata. Select Export if the session uses a Teradata Parallel Transporter Reader.
  • Load. Bulk loads data into an empty Teradata database table.
  • Update. Performs update, insert, upsert, and delete operations against Teradata database tables.
  • Stream. Performs update, insert, upsert, and delete operations against Teradata database tables in near real-time mode. Select Stream if you want to enable recovery for sessions that load data to Teradata.
Default is Stream.