3 Replies Latest reply: Apr 4, 2013 8:02 AM by JeromeFr RSS

    How to integrate OWB process flows and ODI?

    996003
      Hi,

      I have some process flows in OWB and now client is asking to design new task by ODI. So, i need to know that how shall i run all OWB process flows and ODI in a line to kick the business need.

      Your response is valuable to me.

      Thanks and Regards,
      Bishnu
      Mob:9916407746

      Edited by: user8782930 on Apr 4, 2013 5:28 AM
        • 1. Re: How to integrate OWB process flows and ODI?
          JeromeFr
          Hi Bishnu,

          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.


          Regards,
          JeromeFr
          • 2. Re: How to integrate OWB process flows and ODI?
            996003
            Hi JeromeFr,

            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,
            Bishnu
            • 3. Re: How to integrate OWB process flows and ODI?
              JeromeFr
              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.


              Regards,
              JeromeFr