Oracle^® Business Intelligence Disconnected Analytics Administration and Configuration Guide > Preparing Applications for Oracle BI Disconnected Analytics >

Step 2: Creating and Testing Tables and Indexes in the SQL Anywhere Database

Before you can download data to the disconnected machine, you must set up a SQL Anywhere database with the appropriate tables.

NOTE:  Use SQL Anywhere to test creation of the disconnected tables (your DDL scripts).

You will add pointers to these scripts when you create the application configuration file. When the Oracle BI 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 Scripts
• Scenario for Using SQL Scripts to Create Disconnected Tables and Indexes
• Testing SQL Scripts That Create Disconnected Tables and Indexes
• Storing SQL Scripts in the Disconnected Directory