Understanding the SQL Interface Process

You can use the SQL Interface feature to build dimensions and to load values from SQL and relational databases. For example, you can execute SQL statements that specify retrieval of only summary data.

You do not need SQL Interface for spreadsheet or text-file data sources that can be loaded using Oracle Essbase Administration Services, MaxL, or ESSCMD. See theOracle Essbase Database Administrator's Guide and the Oracle Essbase Technical Reference.

With SQL Interface, you can load data from a Unicode-mode relational database to a Unicode-mode Oracle Essbase application. For information on the Essbase implementation of Unicode, see the Oracle Essbase Database Administrator's Guide.

SQL Interface works with Administration Services to retrieve data:

  1. Using Administration Services, you write a SELECT statement in SQL.

  2. SQL Interface passes the statement to a SQL or relational database server.

    Note:

    As needed, SQL Interface converts SQL statements to requests appropriate to non-SQL databases.

  3. Using the rules defined in the data-load rules file, SQL Interface interprets the records received from the database server. (For  information on data-load rules files, see Loading SQL Data.)

  4. SQL Interface loads the interpreted summary-level data into the database.