16.10 - Retrieving a Password from Teradata Wallet Using ODBC Driver for Teradata - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

You can specify a Teradata Wallet string in an ODBC SQLConnect, SQLDriver or BROWSEConnect function, when using ODBC Driver for Teradata 14.0 and up. For example:

SQLConnect(hdbc, “mydsn”, SQL_NTS, “myuid”, SQL_NTS, “$tdwallet(abcd)”, SQL_NTS);
SQLDriverConnect(hdbc, NULL, “DSN=mydsn;UID=myid;PWD=$tdwallet(abcd);”, SQL_NTS, szConnStrout, cbConnStrOutMax, &cbConnectStrOutLen, NULL);

On Windows clients, you can also specify a single connect string in the Teradata Wallet String field of the ODBC Driver Setup for Teradata Database dialog box, according to the following rules:

  • Enter only the wallet string. The $tdwallet() token is not required.
  • Entering a wallet string precludes the specification of a password in the adjacent Password field.

On Linux/UNIX clients you can enter the entire string and token in either the:

  • odbc.ini, for example: $tdwallet(password_alias)
  • connection string, for example:
    DRIVER={Teradata}; DBCNAME=platinum; AUTHENTICATION=LDAP; AUTHENTICATIONPARAMETER=authcid=$tdwallet(odbc_krb1_ad) password=$tdwallet(odbc_krb1_ad_pwd); "