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.
For information on Teradata Wallet, see Security Administration (B035-1100).