Bookshelf Home | Contents | Index | PDF |
Siebel Analytics Server Administration Guide > Setting Up Disconnected Analytics > Creating and Testing Tables and Indexes in the SQL Anywhere DatabaseBefore you can download data to the disconnected machine, you need to set up a SQL Anywhere database with the appropriate tables. NOTE: It is recommended that you use SQL Anywhere to test creation of the disconnected tables (your DDL scripts). You will add pointers to these scripts when you create your application configuration file. When the Disconnected Analytics Application Manager initiates synchronization, the database tables are created or overwritten. To create and test disconnected tables and indexes, use the guidelines in the following topics:
Creating SQL ScriptsA Siebel Analytics Administrator needs to perform the following tasks so that the Disconnected Analytics Application Manager can create tables and indexes in the SQL Anywhere database on the disconnected machine:
For information about SQL syntax for SQL Anywhere, you can download the documentation (Adaptive Server Anywhere, SQL Reference) from the Sybase Web site, or you can contact Sybase for copies of the documentation. Scenario for Using SQL Scripts to Create Disconnected Tables and IndexesA simple retail business application might keep track only of products sold and the stores where sales occur. A disconnected version of this application might consist of two dimension tables (Product and Store) and a central fact table called SalesFact. Each of these three tables would need a corresponding SQL Script file for the disconnected application. This section describes the SQL Script files for these three tables. Product.sqlStore.sqlSalesFact.sqlOptionally, disconnected applications may have SQL script files for creating one or more indexes on a given table. Continuing to use the simple retail business example, this section describes a SQL script for creating an index on the P_Name column of the Product table. ProductIdx.sql
Testing SQL Scripts That Create Disconnected Tables and IndexesAnalytics administrators can test their scripts using the Sybase Interactive SQL Utility (dbisqlc.exe). Sybase documentation provides instructions about how to use this utility. You can download the documentation from the Sybase Web site and search for Interactive SQL utility, or you can contact Sybase for copies of the documentation. Storing SQL Scripts in the Disconnected DirectoryAfter successfully testing the scripts, Analytics administrators should store them in the disconnected application metadata directory for the appropriate application. For the retail business application scenario, this directory might be |
Siebel Analytics Server Administration Guide |