Preparing to Use SQL or Relational Data Sources

SQL Interface is installed during Essbase Server installation. See the Oracle Enterprise Performance Management System Installation and Configuration Guide for information about initial configuration tasks.

  To prepare for using SQL or relational data sources:

  1. Configure the ODBC driver, and point it to its data source. See Configuring Data Sources.

  2. If data is contained within multiple tables, perform an action:

  3. Verify the data source connection by using Data Prep Editor, in Administration Services Console, to open the SQL source file. See Loading SQL Data.

  4. Create a rules file that tells SQL Interface how to interpret the SQL data that is to be used with the Essbase database. See Loading SQL Data.

After these steps are complete, you can load data or build dimensions; see Loading SQL Data.