17.20 - Database Connect - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

If the username and password boxes are filled, ODBC Driver for Teradata converts them to a simplified logon format which is passed to the Teradata security library (TeraGSS)..

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
Use Integrated Security

Default = Cleared

Clear the check box to enable connection to the database through CSO.

Select the check box to enable connection to the database through SSO.

In a CSO from a network client, the user must supply both a Vantage system username and password. The username and password are sent to the database, where they are validated. If the username exists and the password matches correctly, access is allowed. Otherwise, the connect request is rejected.

In an SSO connection, the database system username and password are not submitted. Instead, the username is derived from the user identity on the client platform.

Mechanism Specify the desired security checking mechanism.

Apple macOS supports only TD2, LDAP, Kerberos (KRB5) and TDNEGO.

Kerberos (KRB5) is for Windows only.

Valid Mechanism values are as follows:
  • Empty – The same as omitting the keyword.
  • TD2 – Selects Teradata 2 as the Authentication Mechanism. Username and password are required.
  • TDNEGO – Selects one of the Authentication Mechanisms automatically based on the policy, without user involvement.
  • JWT – Selects JSON Web Token (JWT) as the Authentication Mechanism. An authentication mechanism based on the JWT needs to be provided in the form of "token=<JWT token>" where <JWT token> is the actual JWT token.
  • LDAP – Selects Lightweight Directory Access Protocol (LDAP) as the Authentication Mechanism. The application provides the username and password.
  • KRB5 – Selects Kerberos (KRB5) on Windows, Unix or Apple macOS clients working with Windows servers. To logon using KRB5, the user needs to supply a domain, username, and password. The domain is specified by setting the username to MyUserName@MyDomain.
  • EXTERNALBROWSER - Selects CloudSSO on Windows and Apple MacOS as the Authentication Mechanism. The users’ identity is obtained through Keycloak or PingFederate login using ran external browser. The user is logged on without providing a username and password.
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 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, ODBC Driver for Teradata 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, ODBC Driver for Teradata 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 Vantage 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 Vantage system has account information being gathered).
Buttons
Change To change the value of an existing parameter or to enter a new value, click Change 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.