What's Teradata Wallet

“Teradata Wallet is a software package that provides secure storage of secret information on the client computer. Via the “tdwallet” utility, database passwords can be stored in a single client user’s “wallet” instead of in a script or other plain text file located on the client system, thereby enhancing security.”
Reference: Teradata Online Documentation | Quick access to technical manuals

How to Install Teradata Wallet

Install Teradata Wallet on Windows platform

1. Download Teradata Tools and Utilities - Windows Installation Package from Teradata official website Teradata Tools and Utilities - Windows Installation Package | Teradata Downloads
   
2. Extract the package and execute SuiteSetup.exe from TeradataToolsAndUtilitiesBase__windows_indep.17.10.09.00\TeradataToolsAndUtilitiesBase\Windows\TTU\
   
3. Select “Teradata Wallet” and Install the feature
   

Install Teradata Wallet on Linux platform

1. Download Teradata Tools and Utilities - Linux Installation Package from Teradata official website Teradata Tools and Utilities - Linux Installation Package | Teradata Downloads
   
2. Extract the package and execute ./setup.sh from TeradataToolsAndUtilitiesBase folder
   
3. Choose the number of “tdwallet” to install the utility
   

How to create Teradata Wallet

1. Execute tdwallet help overview to display help information
   
2. Example of adding Teradata Wallet:
   

   
   C:\Users\krbusertd.TECH_SERVICES>tdwallet add tpch 
   Enter desired value for the item named "tpch": 
   Item named "tpch" added. 
   C:\Users\krbusertd.TECH_SERVICES>

   
   
3. Example of listing Teradata Wallet:
   

   
   C:\Users\krbusertd.TECH_SERVICES>tdwallet list 
   tpch

   
   
4. Testing connectivity from ODBC Data Source Administrator: 
   ​​​​Step1: Input Username & Password Wallet String (tpch is the Teradata Wallet item created in the how to create Teradata Wallet section)
   Step2: Click Test button                                                                            
   

Step3: The password will be filled automatically, click OK to test connectivity

How to use Teradata Wallet in Strategy Web

Input $tdwallet(tpch) to Login Password filed (tpch is the Teradata Wallet item created in the how to create Teradata Wallet section)

How to use Teradata Wallet in Strategy Developer

Input $tdwallet(tpch) to Login Password filed (tpch is the Teradata Wallet item created in the how to create Teradata Wallet section)

How to use Teradata Wallet in Strategy Workstation Data Source Management

Input $tdwallet(tpch) to Database Login Password filed (tpch is the Teradata Wallet item created in the how to create Teradata Wallet section)

Notice

The user used to create Teradata Wallet should be the same as the user used to start I-Server.
This is also mentioned in Teradata's official document:
“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.”
Teradata Online Documentation | Quick access to technical manuals
Only the Teradata ODBC driver supports the Teradata wallet while the Teradata JDBC driver doesn’t.