By hamsun-Oracle on Oct 30, 2014
By Laura Garza, Principal Instructor for Oracle University
Often when teaching Oracle Business Intelligence Applications (OBIA) with Oracle Data Integrator (ODI), I get many questions concerning: 1) The different OBIA repositories, 2) Selecting an OBIA offering and Functional Area and 3) ODI terminology and how it relates to OBIA.
The Different OBIA Repositories:
- The Oracle BI Application Oracle Data Integrator repository contains the OBIA specific prebuilt ETL logic.
- The Oracle BI Application Components repository contains the repository for the Configuration Manager and Functional Setup Manager. It also contains the load plan definitions, setup objects and domain mapping to name a few.
How do we select the OBIA offering and Functional Area?
The Configuration Manager is a web application that allows us to configure the offering (Oracle Financial Analytics) that we have purchased. We will also enable the functional area (Account Payables, General Ledger) that we wish to implement via the Functional Setup Manager. Granted, I am only naming a few things that can be done within the Configuration Manager and Functional Setup Manger.
Here we see a screen shot on how to enable an offering and functional area to be implemented via the Configuration Manager.
Once you have finished the OBIA installation and identified which offering and functional area to implement, you will log into ODI Studio. You will then see the following Prebuilt OBIA ETL Logic.
ODI terminology and how it relates to OBIA.
If you have used OBIA with Informatica, you will see some familiar naming conventions within the prebuilt Oracle BI Applications ETL logic. What we need to be aware of is that ODI has different terminology and concepts than Informatica.
Within the Designer navigator tab of ODI Studio is a child tab called Projects. A Project is how we organize components such as interfaces, packages or procedures. When you install OBIA, a prebuilt project will be created called BI Apps Project. When you expand the BI Apps Project, additional folder nodes will be displayed. A folder called Mappings will now be visible. The Mapping folder is where you will begin to see the Prebuilt Adaptor folders. Notice that the Adaptor folders have the same naming convention that was used within OBIA with Informatica. Oracle did this to help us in the transition between the two products.
Many times students are wondering about the location of the SDE or SIL mapping definition. When we expand the Prebuilt Adaptor folder, SDE_ORA11510_Adapter, a child folder is displayed with the naming convention of the dimension or fact table we are trying to load, SDE_ORA_APAgingBucketsDimension. Right Click to expand the child folder and 3 additional objects will be displayed: Packages, Interfaces and Procedures.
An Interface consists of a set of rules that define the loading of a target datastore.
A Package is a workflow made up of a sequence of steps organized into an execution diagram. A Package references other components from a project such as an interface.
The procedure node contains scripts that can be used to customize database objects.
Also within the Designer navigator tab is a tab called Models. A Model is a description of a set of datastores. They correspond to a group of tabular data structures that are stored in a data server. A folder called Oracle BI Application will have a Model folder named Oracle BI Applications. The Oracle BI Application model folder will have child folders which are named based on the table type, ie: Dimension, Fact, Aggregate. The table structure is known as a Datastore.
Finally, we have the Load Plans and Scenarios. Load Plans and Scenarios are found within the Designer navigator tab of ODI studio. In order for source components (interface, package, procedures) to be placed into production, a scenario must be generated. Below we will see the Prebuilt OBIA Load Plans and Scenarios. Keep in mind that we generate and execute the OBIA Load Plans within the Configuration Manager.
In this blog, we discussed the OBIA Repositories along with an introduction to the Configuration Manager and Functional Setup Manager. We also covered some of the ODI terminology and how it relates to OBIA. I hope we were able to provide you an introduction of OBIA with ODI. I look forward to having you attend one of our Oracle BI classes.
Get Started with the new Oracle BI Applications 11g: Implementation using ODI training course. View all Oracle Business Intelligence training from Oracle University.
About the Author:
Laura Garza and been teaching for Oracle for over 15 years. She teaches both the Language and BI classes. For the past 8 years her primary focus has been Oracle BI.