Methods of Connecting to the Teradata Database - 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

Methods of Connecting to the Teradata Database

Using OLE DB Provider for Teradata, a consumer can connect to a Teradata Database in three ways:

  • Connecting directly by setting the required properties, and then calling IDBInitialize::Initialize
  • Using the Teradata Connection dialog
  • Using the IDBPromptInitialize interface
  • PromptDataSource method
  • PromptFileName method
  • Each of these methods sets the three required properties for establishing a Teradata Database session:

  • User ID
  • Password
  • DBC Name
  • The following table shows the sources of the properties.

     

    Table 2: Property Sources  

    Method

    Property Settings Supplied By

    Direct connection

    consumer

    Login screen

    User via logon screen

    IDBPromptInitialize Interface

    User via interface