Teradata Wallet - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.