This section provides an introduction and the methodology to work with the Oracle OLAP Knowledge Modules in Oracle Data Integrator.
Oracle OLAP Knowledge Modules
The Oracle Data Integrator Knowledge Modules for Oracle OLAP provide integration and connectivity between Oracle Data Integrator and Oracle OLAP cubes. Oracle Data Integrator is able to handle two different types of cubes with the Oracle OLAP KMs, depending on the storage mode of these cubes:
ROLAP (Relational OnLine Analytical Processing) cubes are based on a relational storage model. ROLAP cubes can handle a large amount of data and benefit all functionalities of the relational database. MOLAP (Multidimensional OnLine Analytical Processing) data is stored in form of multidimensional cubes. The MOLAP model provides high query performance and fast data retrieval for a limited amount of data.
The Oracle Data Integrator KMs for Oracle OLAP use mature integration methods for Oracle OLAP in order to:
Reverse-Engineer Oracle OLAP data structures (all tables used by a ROLAP or a MOLAP cube). Integrate data in an Oracle Analytical Workspace target in incremental update mode.
Oracle Data Integrator provides two Knowledge Modules (KM) for handling Oracle OLAP data.
RKM Oracle OLAP (Jython)
Reverse-engineering knowledge module to retrieve the tables, views, columns, Primary Keys, Unique Keys and Foreign keys from Oracle Database, which are used by a ROLAP or a MOLAP Cube. This KM provides logging (Use Log & Log File Name) options. Set the options as follows:
MOLAP: Set to YES to reverse an Analytic Workspace AW_NAME: Indicate the name of the Analytical Workspace AW_URL: Specify the URL of the Analytical Workspace AW_OWNER: Indicate the name of the Analytical Workspace Owner AW_PASSWORD: Indicate the password of the Analytical Workspace Owner ROLAP: Set to YES to reverse tables from a ROLAP schema USE_LOG: Set to YES to write the log details of the reverse-engineering process into a log file. LOG_FILE_NAME: Specify the name of the log file
Knowledge Modules Reference Guide