Using Load Plan for managing your ETL task in BI Apps 11.1.1.7.1 (1)

One of the major change introduced in BI Apps 11.1.1.7.1 is the way how we manage the ETL task sequence and trim the unnecessary tasks.

This functionality was accomplished earlier using DAC.  The problem we frequently faced was that the DAC repository and the INFA repository are maintained as two separate repositories.  We have to sync up the name of tasks exactly in order to use DAC to manage the task execution of the Informatica workflow tasks.

Load Plan and Load Plan Generator was designed for addressing this requirement.

Here is a good article that describes the story.

Load Plan Generator – An Inside Look

BI Applications and Embedded BI, Part 3

I would like to go over some of the embedded BI related technologies you can use to make the data from BI Apps embedded in the OLTP systems.

In this post I will describe the Micro ETL feature from DAC.

What does Forrester say about Oracle Data Integrator (Sunopsis)?

“Sunopsis’ ability to connect a wide variety of data sources and targets will allow Oracle to address the heterogeneous data management environments its enterprise architect customers must contend with.

This acquisition could be a big win for the Siebel, PeopleSoft, and JD Edwards customers who, following the acquisitions by Oracle, find themselves smack in the middle of a perhaps unwanted Oracle-dominated ecosystem.”

Please read the entire paper here:

Why do I need to use DAC from Oracle BI?

Data Warehouse Application Console (DAC) works together with Informatica to acomplish the ETL for pre-packaged BI applications.

Here are what happen behind the scene: