Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invoke ODI Scenario (11g) in BPEL (11g)

790397Oct 13 2010 — edited Jan 31 2013

Hello -

I'm developing a BPEL process to load data from SQL Server to Oracle database using ODI . And after that I'm doing more orchestration in the BPEL process. I'm using
1) Oracle Data Integrator 11g (11.1.1.3)
2) Oracle SOA Suite 11g (Web Logic Server)

Have created a scenario in ODI 11.1.1.3 to read data from SQL Server and load into Oracle Database. I would like call this ODI scenario in BPEL 11g as a FIRST Activity.

Please help me the STEPS I need to
1) To expose the ODI scenario as a web service?
2) And to invoke ODI scenario in BPEL
3) Do I need configure/install public web services or anyother checks I need to do on ODI_server domain(WLS) to ensure it has all the components it need ?

Detailed steps are greatly appreciated

Thanks
Babu

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2013

Added on Oct 13 2010

#11g, #bpel, #business-intelligence-applications, #data-integrator, #integration, #odi, #system-management-and-integration, #webservice

4 comments

3,656 views