Teradata Wallet

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

Teradata Wallet provides access to a client system user’s stored Teradata Database passwords to the user while protecting these passwords from access by other users of the same client system.

Each entry in wallet has two parts, a reference string and value (reference string) and real password. Teradata Wallet returns the password when queried with its associated string to the user who created it. For detailed information on using Teradata Wallet, see the most recent version of Security Administration (B035-1100).

ODBC connect functions can process Teradata Wallet reference strings when used in/as password or authentication parameter. Reference string must be enclosed in $tdwallet() token.

Saving a Wallet String in DSN:

  • On DSN Setup dialog, enter the Wallet reference string in Teradata Wallet String field.
  • In odbc.ini, enclose the Wallet reference string in $tdwallet() token and use it as password under the DSN in odbc.ini.

Using Wallet String in connect functions:

A wallet reference string can be used in place (or part of) password or authentication parameter.