Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Analytics Web Administration Guide > Siebel Analytics Third-Party SQL Tool Integration Example >
Example of a Siebel Analytics Third-Party SQL Tool Integration
This section uses Microsoft Access to give an example of how Siebel Analytics can integrate with a third-party SQL tool.
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 query 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
- Drag and drop the keys from the Business Model and Mapping layer to the Presentation layer.
- Save the repository.
- Open Microsoft Access and select the option Blank Access Database.
- Type the name siebel-analytics.mdb, and press the Create button.
- After creating the new Microsoft Access database, right-click in the white section of the screen and select Link Tables.
- From the Files of Type drop-down list box, select ODBC Databases.
The Select a Source Dialog appears, and prompts you for a Data Source Name.
- Click the Machine Data Source tab, locate the Analytics_Web DNS, and click OK.
- Type your user ID and password.
- Click the Select All button, or highlight the desired logical tables from Siebel Analytics.
- When the import completes, right-click in the white section of the screen and select Relationships.
- Select Create query in Design view from the Queries button. Select Markets, Products and Sales Facts and add Region, Brand, Units and Dollars, respectively, and click the Run button.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Analytics Web Administration Guide Published: 11 March 2004 |