15.10 - ODBC Driver Setup Parameters - 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
 

Table 11: ODBC Driver Setup 

Field, Check Box, or Button

Description

Data Source group box

Name

Enter the Data Source Name (DSN) that the application is to refer to when executing SQLConnect or SQLDriverConnect. The entered DSN is the name that will appear in the Data Sources dialog box during a manual connection.

See the “data-source-name=<driver>” option in Table 21 on page 63.

Description

[Optional] Enter descriptive text about the data source in this box.

This is a comment field that is not retrievable by an SQL or ODBC command.

See the “Description=<data-source-desc>” option in Table 22 on page 63.

Buttons

OK

Save changes to this dialog box.

Cancel

Cancel changes to this dialog box.

Help

? (Apple OS X)

Obtain help about this dialog box.

Teradata Server Info

Name or IP address

Perform one of the following:

  • Enter the Teradata Database name (alias or FQDN) without COP suffix.
  • Enter the name or IP address of the LAN-connected node in your system, one per line.
  • After providing the name, ODBC Driver for Teradata dynamically detects all associated COP entries.

    You must define COP names or the name without COP suffix in either a Domain Name Services (DNS) or the local hosts file. For more information, see Cop Discovery“Cop Discovery” on page 51.

    Authentication group box

    Use Integrated Security

    Default = Cleared

    Clear this check box to enable the user to connect to the database using Conventional Sign On (CSO).

    Select this check box to enable the user to connect to the database using Single Sign-On (SSO).

    In CSO from a network client, the user must provide a Teradata Database username and password. These are sent to Teradata Database for validation. If the username exists and the password correctly matches, access is allowed. Otherwise, the connection request is rejected.

    In SSO, the username and password are not submitted. The Teradata Database username is derived from the user identity on the client platform.

    Mechanism

    Default = determined by a configuration option set in an XML file by TeraGSS program, tdgssconfigure.

    Specify the desired security checking mechanism. Valid 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. The application provides the username and password.
  • NTLM – selects NT LAN Manager (NTLM) on Windows clients working with Windows servers. The application provides the username and password.
  • See complete descriptions at “Authentication Mechanisms” on page 92.

    Parameter

    Users cannot enter parameters in this field. Instead, click the Change button located to the right of the field, and a new dialog box opens, allowing the parameter to be entered.

    Once a parameter is entered, the text will be masked with * characters.

    Indicate a string of characters to be regarded as a parameter of the authentication mechanism. The string is opaque to ODBC Driver for Teradata and is passed to the Teradata authentication software called to set the mechanism.

    Enclose characters [] {} () , ; ? * = ! @ in braces.

    You can use a Teradata Wallet reference string instead of a plain text parameter by specifying the $tdwallet() token. For example:

    $tdwallet(WalletRefString)

    For more information, see “Teradata Wallet” on page 98ODBC Driver for Teradata User Guide.

    Username

    Default = Cleared

    Specify a username for the default Teradata Database.

    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. The username and password are Teradata-specific, not to be confused with Windows user ids and passwords.

    The username is interpreted in the context of the authentication mechanism. If, for example, the authentication mechanism is NTLM, then the username is assumed to be a Windows username.

    If the authentication mechanism allows fully qualified usernames, then the username can contain a domain or realm; for example, {judy@linedata}. Values containing a character such as @ must be enclosed in braces.

    SSO is indicated by the absence of a Username and Password.

    See the “Username=<name>” option in Table 22 on page 63.

    Password

    [Optional] The password required for the default Username.

    Not applicable on Apple OS X.

    Note: Password stored locally (Windows registry) in encrypted form, but storing sensitive information in DSN is not 100% secure. Using this feature is not recommended, because it is deprecated. For more information, see Appendix E: “Deprecated Features.”

    Instead of storing the actual password in DSN, it is recommended to use a Teradata Wallet reference string as a password. Password and Teradata Wallet String fields are mutually exclusive, so a DSN can have either the Password or a Teradata Wallet String.

    For more information, see “Teradata Wallet” on page 98ODBC Driver for Teradata User Guide.

    Teradata Wallet String

    Enter and save a Teradata Wallet reference string as password for the user. Do not need to enclose the Teradata Wallet reference string in $tdwallet() token.

    It is recommended to use Teradata Wallet Reference string instead of saving the actual password in DSN. Password and Teradata Wallet String fields are mutually exclusive, so a DSN can have either the Password or a Teradata Wallet String.

    For more information, see ODBC Driver for Teradata User Guide“Teradata Wallet” on page 98.

    Optional group box

    Default Database

    Default = Cleared

    Specify a default database.

    See the “DefaultDatabase=<database-name>” option in Table 22 on page 63.

    Account String

    Default = Cleared

    Enter a user in Teradata Database while configuring the data source rather than having to provide account information during configuration of ODBC Driver for Teradata.

    This information can be used to help isolate users, to find out what application the users are running, or to restrict users from logging on.

    See the “AccountString=<account>” option in Table 23 on page 66.

    Session Character Set

    Default = ASCII

    Specify the character set for the session. To use a different character set than is chosen by default, specify or select it here.

    The options available from the drop-down list are:

  • ASCII
  • UTF8
  • UTF16
  • LATIN1252_0A
  • LATIN9_0A
  • LATIN1_0A
  • SJIS
  • EUC
  • BIG5
  • GB
  • NetworkKorean
  • IBM Mainframe (KANJIEBCDIC5038_0I)
  • Note: See the note in “Session Character Sets and Translation DLLs” on page 52 for more information on restrictions.

    Buttons

    OK

    Click to enable the driver to use any changes that have been made in the dialog box. Note that this button does not become available unless the Name box in the Data Source group box and the Teradata Server Info Name(s) or IP address(es) group box are filled in.

    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.

    Options

    Click to display the Teradata ODBC Driver Options dialog box and configure additional options and formats.

  • Teradata ODBC Driver Options
  • Teradata ODBC Driver Advanced Options