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 >

Creating SQL Scripts

You must perform the following tasks so that the Oracle BI Disconnected Analytics Application Manager can create tables and indexes in the SQL Anywhere database on the disconnected machine:

• Determine the tables and indexes that an Oracle BI Disconnected Analytics application needs.
• Create corresponding scripts, creating one script for each table. Optionally, you can also create one for all indexes of a given table.

For more 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.