Using Teradata Wallet in a Teradata PT Job - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Using Teradata Wallet in a Teradata PT Job

Users can store certain Teradata PT attributes using Teradata Wallet, which protects the attributes in encrypted form so that only the owning user can access them.

After an attribute is stored, you can use Teradata Wallet to retrieve the stored attribute using a string name.

For example, to specify the option for the Password attribute in a Teradata PT job using Teradata Wallet, use the following syntax:

VARCHAR Password = '"$tdwallet(password alias)"'

where password alias is the string name that contains the value for the stored password as shown in the following example:

VARCHAR Password = '"$tdwallet(MyPassword)"'

To specify the option for the TdpId attribute in a Teradata PT job script using Teradata Wallet, use the following syntax:

VARCHAR TdpId = '"$tdwallet(tdpid alias)"'

where tdpid alias is the string name that contains the value for the stored TdpId as shown in the following example:

VARCHAR TdpId = '"$tdwallet(MyTdpId)"'

You can only use the Teradata Wallet for the following attributes:

  • Password
  • Username
  • TdpId
  • AccountId
  • You cannot use Teradata Wallet to store any other attributes.

    Note: The Teradata PT ODBC Operator does not support Teradata Wallet. Teradata PT interacts with the Teradata Wallet through CLI for its connections only to Teradata.

    For information on Teradata Wallet Security Administration.