Transports and Interfaces: Siebel Enterprise Application Integration > Using Siebel OLE DB Provider >

Connecting Siebel Data Using OLE DB Consumers

You can use existing OLE DB Consumers to connect to a Siebel OLE DB rowset that you create using Siebel OLE DB Rowset wizard. This wizard helps you create an integration object that interfaces to Siebel business objects. For example, if you want to display data about accounts in Microsoft Access to take advantage of its graphical reporting tools, you specify the Account business object when creating Siebel OLE DB rowset. The wizard creates an integration object that, in effect, translates data from the Siebel business object format into data in the OLE DB rowset format.

Siebel OLE DB Provider for Siebel EAI supports four preconfigured applications as OLE DB Consumers:

• Microsoft Excel
• Microsoft SQL Server
• Microsoft Access

NOTE:  Microsoft Access XP is not supported as a Siebel OLE DB Provider.

This section explains how to use the Siebel OLE DB Provider with these applications. After you have installed Siebel OLE DB provider library files and created your OLE DB rowsets within Siebel Tools, you are ready to use Siebel data within the framework.

NOTE:  Siebel OLE DB Provider allows you to retrieve information from the Siebel Database on a read-only basis. You can review the data and incorporate it into spreadsheets, databases, and Web pages as needed. You cannot make changes to the data or affect the Siebel Database in any way with Siebel OLE DB Provider.