15.10 - Using Teradata Wallet in a Teradata PT Job - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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.