Introduction - OLE DB Provider for Teradata

Introduction

OLE DB Provider for Teradata allows many kinds of users to connect to Teradata Database.

The OLE DB database is a set of Component Object Model (COM) interfaces and objects that provide applications with uniform, standard access to any data store. In this case, the data store is in Teradata Database. OLE DB Provider for Teradata specifically allows access to data stores that do not use Structured Query Language (SQL).

Using this product, an application requests database information from an intermediate program, which in turn accesses Teradata Database. The intermediate program receives the response from Teradata Database and returns a copy of the desired data to the application.

The following OLE DB terminology is used in this manual:

Consumer - Any application- or system-level program that invokes the component object model (COM) objects that access a database.

Provider - Any program that:

Exposes COM objects to a consumer

Provides services that the consumer uses to connect, retrieve, and update a database.

OLE DB also introduces the notion of service providers. A service provider enhances the functionality of a provider; for example, the Microsoft Cursor Service for OLE DB adds client-side cursor support to any provider. Figure 1 shows the functional relationships.

Figure 1: Functional Relationships