This content has been marked as final. Show 3 replies
As recommend by Oracle's statement of direction (http://www.oracle.com/us/products/middleware/data-integration/odi-statement-of-direction-1922235.pdf), I would wait for ODI 12c to come. Then you will be able to execute and monitor in ODI studio.
Afterwards (but not in the first release of ODI 12c), there will be a tool helping the migration from OWB objects to ODI objects.
If you really want to execute it from ODI right now, you can see several methods to launch an OWB Process Flow from PL/SQL or sqlplus : http://docs.oracle.com/cd/E11882_01/owb.112/e10935/scheduling_etl.htm#CIHGJAHH
I would go for the PL/SQL method : create a procedure in ODI that call RUN_TASK.WB_RT_API_EXEC and handle the return value (i.e. raising an error if return code is 3).
Hope it helps.
Thanks for your reply.
Still i need some more concept,how to align owb process flow and ODI procs to kick the business need.
Thanks and Regards,
Could you be more specific in your question ?
I explained you how to launch OWB process flows through ODI, so you can use the ODI Scheduler to run both (so it's aligned).
Do you need something else?
If you already have an external scheduler for your OWB jobs, you can do the opposite and run ODI scenario through it. You can start an ODI scenario using the OdiStartScen http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/appendix_a.htm#BGBDEDCG. Read the section A.1.3 if you want to know how to run this command from command line.