The architecture for Oracle Business Intelligence Applications (OBIA) includes several components. Understanding these components is prerequisite to a successful OBIA implementation. A brief description of each component is included below the diagram.
OBIEE:
- OBIA is a set of prebuilt reports for every business module like Financial, HR, Sales, Order Management, etc.
- In order to have pre-built reports we need to have prebuilt rpd (generic business logic).
- The rpd is built on top of pre-defined tables (dimensions and facts). The tables reside in a BI database(OLAP).
Informatica:
- Prebuilt OBIA Informatica mappings are created to extract data from several data sources (OLTP) and load to BI database (OLAP) tables. These data sources include Oracle EBS, JD Edwards, Peoplesoft, and other ERP systems.
- A set of SDE, SIL and PLP together loads data into one BI fact or dimension table
- SDE Mapping or Source Dependant Loads: Are used to extract data from and Data Source to staging
- SIL Mapping or Source Independant Loads: Are used to load data from staging to the target OBI tables (dimensions and facts)
- PLP or Post Load Processes: Are sometimes used to transform data after it is in a fact table, or add to data after it is in a fact table.
- Informatica structure: An informatica workflow includes one or more sessions sessions. Each session includes one mapping.
A workflow is started that runs one or more sessions. The logic of each session is defined in a mapping.
DAC:
- DAC acts like a trigger to run the workflows in Informatica.
- DAC contains Execution Plans which can be scheduled or run any time. These Execution Plans are designed to do an incremental or a full load.
- Within each Execution Plan there are several subject areas, each subject area contains all the tasks which are associated to workflows in Informatica that loads data to the dimensions and facts to build the corresponding subject area.
Blog Author: Soumya Kancheti
Soumya is a contributing blog author on the Business Intelligence Practice team at BizTech.
