Oracle Data Integrator with OBIA 11.1.1.7.1 --Migration Issues.

Dt:19 March 2014


The honeymoon is over literally.Just when you were close to giving ODI the best ETL tool for OBIA award.They have goofed up.And Big time.

ODI-23040 -->this is the error which I get when I am trying to import my code from one environment to another.
No Rhyme no Reason. Guess it feels good to be a developer at Oracle when they are told never let the end user know what the error is.Let them come to us and beg for support.

But seriously for something as simple as migrating code from one environment to another which Informatica does so efficiently .I had to go through 100s of documents advising me how to use Internal Ids .What these internal Ids mean.How ODI stores this .......& so on....so forth..... .

I mean common which developer would share this information to his customer that this is how we store our objects and you have to change your backend Ids for our migration to work.

I understand that ODI was designed with another view of code migration .But Oracle being the business leader should have known for sure that the three tier architecture of DEV, QA & PROD is how projects are executed in the real world & this is how they should have built the migration module.

For now hope for those guys at Oracle Support to come out with a meaningful answer.It sucks.But yes its business !!!

How to add Custom PLP ,SDE & SIL interfaces to ODI load Plans in OBIA 11.1.1.7.1

Dt: 15 March 2014

Well its easy.

Of the many things you would like to do to get this done.Here are a few.

Make  the flex fields on the custom tables in Models to  point to fact group --> X_CUSTOM_FG. This lets ODI know all your custom fact tables.
Create foreign keys in ODI to the dimensions attributed in your custom facts.
This helps in understanding dependencies.

Just like you would add Informatica sessions to the DAC task lists.
Add the ODI scenarios into the BI Apps Load Plan provided Out of The Box.
You need to add your scenarios to the X_CUSTOM Facts, X_CUSTOM Dims in the LOAD PLAN DEV components.
There are seperate classifications for SDE,SIL & PLP.

Unfortunately once you go to the PLP section here you will not find the custom groups available.
No worries just create your own custom Load plans here within the parallel steps.

Once you have added your scenarios those will reflect in the new load plan done using custom fact group(X_CUSTOM_FG).

For PLP you have to add your newly created load plans into the  LOAD PLAN SYSTEM components.
This is a small piece of wiring which has to  be done.This was left unanswered in the documentation.

For that matter ODI with OBIA is like a new game on the blocks.Steps & rules provided for most of the things but then some hidden secrets left for you to explore.


Seems like a blockbuster so far.