Oracle^® Business Intelligence Disconnected Analytics Administration and Configuration Guide > Overview of Oracle BI Disconnected Analytics > About Oracle BI Disconnected Analytics >

Sourcing Queries for Disconnected Applications

Sourcing queries generate the data that is stored in the SQL Anywhere database on the disconnected machine. You create sourcing queries using Oracle Business Intelligence and store them in the full Oracle BI Presentation Catalog. Sourcing queries do not differ substantively from any other queries (requests) stored in the Oracle BI Presentation Catalog. Only their use for populating the SQL Anywhere database on the disconnected machine distinguishes them from other queries.

Each sourcing query corresponds to a specific table in the SQL Anywhere database on the disconnected machine. Therefore, the order, number, and type of columns in the sourcing query must exactly match the order, number, and type of columns in the associated table. For more information about sourcing queries, see Step 5: Defining Sourcing Queries for Oracle BI Disconnected Analytics.