Displaying Teradata Connection Dialog - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide
Product
OLE DB Provider for Teradata
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2498
Product Category
Teradata Tools and Utilities

Displaying Teradata Connection Dialog

The Teradata Connection dialog displays when the consumer calls the method IDBInitialize::Initialize.

Figure 3: Teradata Database Connection Dialog

Control how the Teradata Connection dialog displays by:

  • The value for DBPROP_INIT_PROMPT.
  • The properties set from the DBPROPSET_DBINIT Initialization. Property Group. For more information, see “Initialization Property Group” on page 98.

    • The Teradata Connection dialog contains the following fields:

     

    Table 4: Teradata Connection Dialog Fields 

    Field Name

    Required/ Optional

    Purpose

    Use Integrated Security

    Optional

    Enables Single Sign-on (SSO). See “Single Sign On” on page 26 for more details.

    Use Data Encryption

    Optional

    Enables data encryption.

    DBC Name

    Required

    Name or IP address assigned to the Teradata Server. Both IPv6 and IPv4 addresses are supported.

    User ID

    Required

    Teradata User ID.

    Note: This field can be blank for Single Sign-on.

    Password

    Required

    Password that corresponds to the User ID.

    Note: This field can be blank for Single Sign-on.

    Default Database

    Optional

    Database selected when creating the Teradata session. For more information on the default database, refer to the SQL Data Manipulation Language manual, the DATABASE statement.

    Account String

    Optional

    Account string that corresponds to the User ID. For more information on the default database, refer to the SQL Data Definition Language, the CREATE USER statement.

    Session Character Set

    Optional

    The session character set that you want used in communications between OLE DB Provider for Teradata and Teradata Database.

    Options Dialog Box

    When the Options button is clicked, several fields are added to the dialog box.

    Figure 4: Connection Dialog - Options

    The following fields are added:

     

    Table 5: Teradata Connection Options Dialog - Fields 

    Field Name

    Required/ Optional

    Purpose

    Authentication Mechanisms

    Required

    Select the authentication mechanism specified by your system administrator from the list of authentication mechanisms provided in the drop down list. The Authentication Mechanism identifies the mechanism used for connections to the data source.

    Valid authentication mechanism values are:

  • Empty - If no Authentication Mechanism is listed in the drop down list, or if the Authentication Mechanism selected is not supported, the mechanism used is the system default.
  • TD1 - Teradata 1 mechanism.
  • TD2 - Teradata 2 mechanism.
  • ldap - ldap mechanism.
  • KRB5 - Kerberos mechanism.
  • KRB5C - Kerberos Compatibility mechanism.
  • NTLM - NT LAN Manager mechanism.
  • NTLMC - NT LAN Manager Compatibility mechanism.
  • Other - user-defined mechanism.

    • Authentication Mechanisms Data

    Optional

    Enter the parameters required by the selected authentication mechanism. See your system administrator.

    Use As Column Name

    Optional

    Select either column titles or column names as the value. For more information, see “TDPROP_INIT_USEASCOLUMNNAME” on page 101.