Define Rules that Query External Sources

Using SQL queries, you can pull or push data to Essbase from external sources of data. You need to configure Essbase to access the external sources.

• Pull and Push Methods of Loading External Data into Essbase

• Overview of SQL Properties in Rules

• Connection Strings for SQL-Based Connectivity

• Access External Data Using a Connection and Datasource

• Access External Data Using an OCI Connection String

• Access Data Using ODBC Connectivity

• Access Data Using JDBC Connectivity

• Stream from a Remote Database

Notes

1. The rule file must exist in the cube directory for the relevant Essbase cube.

2. The database query used to load data or build dimensions must have the same dimensionality as the columns in the rule. (In other words, the order of dimensions in the rule file must match the order of dimensions in the SQL query).

3. Only use SQL functions that are supported by JDBC. ODBC scalar functions are not supported in CLI.