To avoid being prompted for credentials, you can enter your password in the Teradata DSN.
If you do not type an authentication username and password in the ODBC Driver Setup for Teradata Database dialog box while creating a DSN, you will be prompted each time you attempt to access a data source in Teradata Schema Workbench.
Although you will receive a warning about entering a password for a Teradata DSN, it is stored and transmitted in encrypted form.
If you save usernames and passwords in your Teradata DSN, the user must be in either the TBI_WORKBENCH or TBI_USER role. If you plan to use a Teradata DSN with Teradata Schema Workbench, the user must be in the TBI_WORKBENCH role.
For 64-bit versions of Windows, you must use the 32-bit ODBC Data Source Administrator, which is not available from the Control Panel.
-
Do one of the following:
- From the Tools menu, click ODBC Admin 32bit.
The ODBC Data Source Administrator dialog box appears.
- (32-bit Windows systems) From the Windows Start menu, click .
- (64-bit Windows systems) Use Windows Explorer to access the 32-bit version of ODBC Data Source Administrator. To do this, locate and run odbcad32.exe from the C:\%WINDIR%\SysWOW64\ directory.
- From the Tools menu, click ODBC Admin 32bit.
- Click the System DSN tab.
- Click Add. The Create New Data Source dialog box appears.
- Select Teradata.
- Click Finish. The ODBC Driver Setup for Teradata Database dialog box appears. Refer to the ODBC Driver for Teradata User Guide (B035-2509) for assistance. See Additional Information.
- Type the Data Source Name and the Teradata Server Name(s) or IP address(es).
- [Optional] Type an Authentication Username and Password.
- Click OK.