Bookshelf Home | Contents | Index | Search | PDF |
Transports and Interfaces: Siebel eBusiness Application Integration Volume III > Using Siebel OLE DB Provider > About Siebel OLE DB Provider >
Siebel OLE DB Provider Configuration for Testing
You configure and test Siebel OLE DB Provider using the siebel.udl file that is installed in the
siebel
\bin\l
anguage
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 15 presents the necessary connection properties.
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.
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
;CommandType=Default
CommandText=select * from Contact where 'Job Title'=ManagerNOTE: There should be no blank lines between commands such as QueryType, Version, and CommandText. Connection information should be in one continuous line.
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 16 below defines the syntax.
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
Bookshelf Home | Contents | Index | Search | PDF |
Transports and Interfaces: Siebel eBusiness Application Integration Volume III Published: 23 June 2003 |