Oracle Business Intelligence Application (OBIA) pre-built solutions has two configuration methods. First one is with Informatica/DAC which is in place since 2001 while the other one is with Oracle Data Integrator (ODI) which seems Oracle’s strategic offerings.
This blog is an attempt to list down significant differences between these two configurations offerings. In addition introduce the new product sets which is been used for configuration and functional setup in later version i.e. OBIA 220.127.116.11.1
There are number of significant differences between how OBIA 18.104.22.168 & OBIA 22.214.171.124.1 works.
In the 7.9.6 release, the ETL workflows, mappings, configuration etc are done using Informatica Powercenter, the Data Admin Console and manually editing configuration files. In the 126.96.36.199.1 release, the ETL workflows, mappings, configuration etc are done using ODI, Configuration Manager and Functional Setup Manager.
Some of the highlights of differences are as follows
- ODI Load Plans now replace the Informatica execution plans.
- ETL tool is now embedded with ODI and load plans are generated and run using a JEE agent via the ODI studio and therefore there is no further need for a Informatica or DAC server.
- Informatica mappings, mapplets and workflows have also now been replaced by pre-built ODI content which includes repository objects such as packaged ETL mappings, Interfaces and scenarios
- The BI Configuration Manager(BIACM), Functional Setup Manager(FSM) and the Oracle Data Integrator all work together to replace a lot of the functional configuration that was previously done using the DAC
- Domain mappings now done within the Configuration Manager, lookup files are no longer needed and a lot of the domain mappings that were previously done in CSV files are also no longer required. ( There are some exceptions where CSV files are required)
The web applications introduced as part of OBIA 188.8.131.52.1 is a significant change from the OBIA 7.9.6.X versions; it offers homogeneity and better way of managing configurations.
BIACM is a Web application for setting up and maintaining an Oracle Business Intelligence Applications environment and provides the following features:
- Contains the setup objects for Oracle BI Applications.
- Provides administrative GUIs for setup and configuration.
- Recommended for ongoing administration and maintenance of functional setups.
- Quick review of the setup values and for troubleshooting.
A screen snapshot for BIACM for financial Analytics is as follows
FSM enables you to manage and perform functional configuration tasks for configuring Offerings and provides the following features:
- Oracle BI Applications Configuration Manager leverages FSM to provide Task based implementation, with guided set of sequenced tasks and dependency management
- Provides phased implementations capability.
- FSM for Oracle BI Applications is different from the Oracle Fusion Functional
− FSM for Oracle BI Applications includes only the features applicable for Oracle BI Applications functional setup.
− FSM for Oracle BI Applications has lighter Tech stack dependencies.
- FSM is launched from Oracle BI Applications Configuration Manager to perform functional configurations.
- FSM is recommended for initial implementation.
- FSM invokes Oracle BI Applications Configuration Manager UI for setup tasks.
A screen snapshot for FSM for financial Analytics is as follows
Roles for System Configuration and Management
To access Oracle BI Applications Configuration Manager or Functional Setup Manager, following roles are supported
BI Applications Administrator
Users with the BI Applications Administrator Duty Role have access to all Oracle BI Applications Configuration Manager UIs and all FSM UIs. For Oracle BI Applications Configuration Manager, only users with this duty role can perform System Setups.
BI Applications Developer
Users with the BI Applications Functional Developer Duty Role have access to Oracle BI Applications Configuration Manager UIs except for the System Setup screens. In FSM, these users have access to the list of functional setup tasks assigned to them, and can execute setup tasks (that is, using the Go to Task option in FSM).
BI Applications Implementation Manager
Users with the BI Applications Implementation Manager Duty Role have access to the Oracle BI Applications Configuration Manager Overview page and dialogs for the Export and Import of Setup Data. In FSM, these users have access to Configure Offerings and Manage Implementation Projects UIs, but they cannot execute setup tasks (that is, they do not have access to the Go to Task option in FSM).
I believe this is just a beginning of new chapter in OBIA Analytical Application world, many more to come in very near future.