Bookshelf Home | Contents | Index | PDF |
Transports and Interfaces: Siebel Enterprise Application Integration > Using Siebel OLE DB Provider > Connecting Siebel Data Using OLE DB Consumers > Viewing Siebel OLE DB Rowsets in Microsoft Office ApplicationsThis section discusses a variety of ways to view information using Microsoft Office applications. Business analysts find the Siebel OLE DB Provider support useful for analyzing account data and other information stored in the Siebel Database and incorporating that data in an Excel spreadsheet. To use Siebel OLE DB Provider from Excel, you create an external query that connects to Siebel OLE DB Provider. To view Siebel data in Microsoft Excel
The following example connects to Siebel OLE DB Provider and sends a command to retrieve all records from the Contact virtual table where the position is equal to Manager. You can store any query in a The properties identify the contents of the file as an OLE DB type query and provide the connection parameters and query text. The properties QueryType, Version, Connection, CommandType and CommandText are required. The structure defined is mandatory and cannot be changed. Table 21 shows the required properties for an Excel query file.
Connection=Provider=SiebelOLEDB.Provider.1;Password=db2; NOTE: You should not have any blank lines between each commands such as QueryType and CommandText. Connection information should be on one continuous line. You can use Microsoft Access to create ad hoc reports. Using the Access Data Access Page Designer's drag-and-drop capabilities, you can create Web pages by selecting, dragging, and dropping Siebel OLE DB tables onto the Access form. The underlying OLE DB infrastructure writes the necessary information, and the newly created Web page accesses the Siebel virtual table data transparently. To view Siebel data in Microsoft Access
Viewing Siebel Data Using Microsoft SQL Server Distributed QueriesIn Microsoft SQL Server version 7.0, distributed queries enable SQL Server users to access data outside a SQL Server-based server, within either other servers running SQL Server or other data sources that expose an OLE DB interface. OLE DB provides a way to uniformly access tabular data from heterogeneous data sources. A distributed query for the purpose of this document is any SELECT, INSERT, UPDATE, or DELETE statement that references tables and rowsets from one or more external OLE DB data sources. A remote table is a table that is stored in an OLE DB data source and is external to the server running SQL Server executing the query. A distributed query accesses one or more remote tables. Siebel OLE DB provider may be used as one of the data sources in the SQL 7.0 distributed query. SELECT * FROM OPENROWSET('SiebelOLEDB.Provider.1','
NOTE: For more information about Microsoft SQL Server distributed queries, please refer to Microsoft SQL Server 7.0 documentation. Database administrators (DBAs) find the OLE DB support in Siebel EAI useful for checking data integrity in Siebel applications and database-related tasks. With Siebel OLE DB Provider, table, row, and field information are displayed in the Microsoft SQL Analyzer for review and action. To view Siebel data in SQL Analyzer
|
Transports and Interfaces: Siebel Enterprise Application Integration |