15.10 - Teradata Database Connect - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

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.

 

Table 5: 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

Use Integrated Security

Note: Not applicable in Apple OS X.

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 Teradata Database username and password. The username and password are sent to Teradata 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 Teradata Database username and password are not submitted. Instead, the Teradata Database username is derived from the user identity on the client platform.

Mechanism

Specify the desired security checking mechanism.

Apple OS X supports only TD2, LDAP, and TDNEGO.

Kerberos (KRB5), Kerberos Compatibility (KRB5C), NT LAN Manager (NTLM), and NT LAN Manager Compatibility (NTLMC).

Valid Mechanism values are:

  • Empty – the same as omitting the keyword.
  • TD1 – selects Teradata 1 as the Authentication Mechanism. Username and password are required.
  • 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.
  • LDAP – selects Lightweight Directory Access Protocol (LDAP) as the Authentication Mechanism. The application provides the username and password.
  • KRB5 – selects Kerberos (KRB5) on Windows 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.
  • NTLM – selects NTLM on Windows clients working with Windows servers. The application provides the 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(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.