Teradata Database Connect - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

If the username and password boxes are filled, the ODBC driver converts them to a simplified logon format which is passed to TeraGSS as mech data.

Teradata Database Connect Set Up 
Field, Check Box, or Button Description
DBC Name or Address Specify the COP or AMP for your first connection. This is the list of names and IP addresses that was configured in the Teradata Server Info group box of the OBDC Driver Setup for Teradata Database dialog box.
Authentication group box
Parameter Type in the parameters required for the desired security checking mechanism.

With simplified login support, it is not necessary to fill in the Parameter field for most logins. Sometimes it might be necessary to supply additional information such as Profile=MyProfile to log on to the database. In such cases, the additional information is contained in the Parameter field. The Parameter value can be specified when the DSN is created. Like a password, the value will be masked.

To change the value of an existing parameter or to enter a new value, click on the Change button next to the Parameter field. A new Parameter dialog box opens, which allows the specification of a new Parameter value. If a Parameter value already exists, it will be displayed in clear text in the dialog box and can be edited or replaced. When changes are complete, click OK.

Username Default = Cleared

Shows the default username that was specified during the data source(s) configuration of the driver. The default value can be overridden here. If required, the user is prompted for additional information.

If the Username field is filled in, the ODBC Driver converts it to a simplified logon format which is passed to the Teradata security library (TeraGSS).

Password Sends the password (if any) that was configured for this data source (unless a different password is supplied). If required, the user is prompted for additional information.

If the Password field is filled in, the ODBC Driver converts it to a simplified logon format which is passed to the Teradata security library (TeraGSS).

Optional group box
Default Database Indicate the default data space that has been allocated to the user (when supplied). If provided, the user does not have to supply the fully qualified table name with each request.

If not supplied, the Teradata system automatically assigns the user to the default data space, which might not have the desired permissions and tables.

Account String Identifies the user (if the Teradata system has account information being gathered).
Buttons
Change To change the value of an existing parameter or to enter a new value, click on the Change button next to the Parameter field. A new Parameter dialog box opens, which allows the specification of a new Parameter value. If a Parameter value already exists, it will be displayed in clear text in the Parameter dialog box and can be edited or replaced. When changes are made, click OK.
OK Click to enable the driver to use any changes that have been made in the dialog box. Changes are temporary and are not stored, with the exception of the username, which is stored as the last user that connected to the data source.
Cancel Click to cancel any changes made to the dialog box and abort the current driver and data source selection.
Help? Click to obtain detailed help about this dialog box.