Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Analytics Web Administration Guide > Integrating Siebel Analytics Web Into Corporate Environments Using HTTP > Example of a Siebel Analytics Third-Party SQL Tool IntegrationThis section illustrates the requirements for integrating a third-party SQL tool with Siebel Analytics by describing an example integration, using Microsoft Access. Because Siebel Analytics is designed as a middleware platform for enterprise data access and integration, common report writers and business intelligence tools can communicate natively with the Siebel Analytics Server. Most third-party SQL tools require the user to include join conditions within queries, in order to avoid cross-joins. A cross-join occurs when a request does not have a WHERE clause, which, in turn creates a Cartesian product of the tables involved in the join. The size of a Cartesian product is the number of rows in the first table multiplied by the number of rows in the second table. To integrate Microsoft Access with the Siebel Analytics Server, the Siebel Analytics Server administrator must expose the keys within the Presentation layer of the Siebel Analytics Administration Tool. Example of integrating a third-party SQL tool
|
![]() |
![]() ![]() |
Siebel Analytics Web Administration Guide |