1. Database Administrator's Guide for Oracle Essbase
  2. Design Rules for Data Load or Dimension Build
  3. Define Rules that Query External Sources
  4. Overview of SQL Properties in Rules

Overview of SQL Properties in Rules

Design Essbase load rules with SQL Properties to extract data from a relational database using a SQL query, when your source of data requires connectivity to an external system such as an RDBMS.

SQL-based loads extract data from a relational database using a SQL query, and load it into Essbase using your defined rule.

Before you start, identify whether your access to the external source is based on:

Once you know the above information, log in to the Essbase web interface and start here to define SQL-based connectivity for your load rule.

  1. Open an existing rule or create a new one (see Access and Edit Rules, Create New Dimension Build Rule, or Create New Data Load Rule).

  2. Click Source Properties.


    Source properties button in rule editor of Essbase web interface

  3. Click SQL Properties.

  4. Identify which of the following Properties categories best applies to your source data.


    SQL Properties tab of the Edit Source dialog for a load rule, with options ODBC (DSN-less), Oracle Call Interface (OCI), Datasource, and SQL Data Sources (DSN)

    If your connectivity has been predefined using a connection and Datasource established in Essbase, choose Datasource, and see Access External Data Using a Connection and Datasource.

    If your connectivity depends on ODBC drivers configured on the Essbase server, choose ODBC (DSN-less) or SQL Data Sources (DSN), and see Access Data Using ODBC Connectivity.

    If your connectivity depends on a connection string that includes OCI, choose Oracle Call Interface (OCI), and see Access Oracle Database Using Oracle Call Interface.