Retrieve from Teradata Wallet/ODBC Driver | Teradata Vantage - Retrieving a Password from Teradata Wallet Using ODBC Driver for Teradata - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™

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