Bookshelf v7.7: Configuring and Testing the Siebel OLE DB Provider

You configure and test Siebel OLE DB Provider using the siebel.udl file that is installed in the siebel\bin\language directory. The siebel.udl file appears this way:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SiebelOLEDB.Provider.1;Persist Security Info=False;

Table 19. Siebel OLE DB Provider Connection Properties
Property	Description
Data Source Name	The connection string as explained in Using Siebel Tools. In the .cfg file, make sure the `DataSource` property in the `[Siebel]` section is set for the local client using Local, Sample, or Server—for example, set this property to Sample for the sample database.
User ID	Your Siebel user ID.
Password	Your Siebel password.

When you have entered these values, test the connection to the data source by clicking the Test Connection button on the Microsoft Data Link Properties dialog box. If the connection is valid, you receive a confirmation. If you receive a successful connection confirmation, you can use the same data source name with any OLE DB-enabled application to connect to the Siebel OLE DB Provider.

About the Siebel OLE DB Provider in the Server Connected Mode

In the server connected mode Siebel OLE DB Provider uses the Siebel Web client to communicate with the rest of the Siebel environment. In this mode, the Data Source name defines the connect string that is used by the Siebel Web client to connect with the Siebel Gateway. A sample Excel query that uses Siebel OLE DB provider in Server mode follows:

QueryType=OLEDB
Version=1

Connection=Provider=SiebelOLEDB.Provider.1;Password=SADMIN;
Persist Security Info=True;User ID=SADMIN;
DataSource=Gateway machine name,name of the Enterprise,name of the Object Manager,name of the Siebel Server;

NOTE: There should be no blank lines between commands such as QueryType, Version, and CommandText. Connection information should be in one continuous line.

About the Siebel OLE DB Provider Local WIN32 Siebel Client Mode

In the local client mode, the Siebel eBusiness Object Manager allows the Siebel OLE DB Provider to connect to the Siebel application residing on the same machine. In the local client mode, the Data Source name defines a path to the Siebel configuration file. Table 20 below defines the syntax.

Table 20. Data Source Syntax
String	Database
`c:\....\siebel.cfg`	Uses the default database
`c:\....\siebel.cfg,Local`	Uses the local database regardless of the default setting
`c:\....\siebel.cfg,ServerDataSrc`	Uses the server database regardless of the default setting

CAUTION: When you install using the Siebel EAI Connectors installation option, the Siebel OLE DB Provider can only be used in the Server Connected Mode. The Local Client Mode is not available.

A sample Excel query that uses Siebel OLE DB Provider in the local client mode follows:

QueryType=OLEDB
Version=1

Connection=Provider=SiebelOLEDB.Provider.1;Password=SADMIN;
User ID=SADMIN;Data Source=c:\Program Files\SiebelApp\bin\siebel.cfg,lang=ENU

CommandType=Default
CommandText=select * from Contact where 'Job Title'=Manager