How to call an ODI Scenario from APEX?

Subrahmanyam Vempati

Hi Team,

Could please suggest on the better approaches to call an ODI scenario from APEX.

Thanks,

Vempati

Billy Verreynne

That depends on the interfaces supported by ODI. Are there PL/SQL interfaces, web service (SOAP/JSON) interfaces, etc?

Subrahmanyam Vempati

Hi ,

Would it impact the underlying interfaces in a scenario? My requirement is just to call a odi scenario from apex. Here the ODI scenario can be of any technology be it soap/ plsql. I am looking for better approaches to integrate odi interfaces with APEX.

Appreciate your prompt response!

Thanks,

Vempati

Billy Verreynne

Never used ODI, nor know much about it.

As a product, it likely supports one or more call interfaces, for use by 3rd party applications. E.g. SOAP Web Services for Financials. This allows a 3rd party (such as an APEX application), to communicate, and integrate, with the Oracle Financials product.

So you need to look at your ODI product documentation, and determine what interface(s) ODI supports for an external 3rd party, to communicate with it.

The typical interfaces exposed for 3rd party/external usage, by an Oracle product, are web services (SOAP/JSON), Java classes, and PL/SQL packages.

Tell us what interface is supported by ODI, and we will be able to suggest how to use that interface from APEX, and interact or integrate with ODI.

User_KQMQH

Hi Vempati,

Did you find a solution to that?