Retrieve from Teradata Wallet/ODBC Driver | Teradata Vantage - 17.10 - Retrieving a Password from Teradata Wallet Using ODBC Driver for Teradata - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

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 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); "