Forum Stats

  • 3,839,129 Users
  • 2,262,454 Discussions
  • 7,900,865 Comments

Discussions

How to call an ODI Scenario from APEX?

Subrahmanyam Vempati
Subrahmanyam Vempati Member Posts: 13
edited Jan 10, 2020 7:13AM in APEX Discussions

Hi Team,

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

Thanks,

Vempati

Tagged:

Answers

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,834 Red Diamond
    edited Jan 10, 2020 1:00AM

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

  • Subrahmanyam Vempati
    Subrahmanyam Vempati Member Posts: 13
    edited Jan 10, 2020 6:08AM

    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
    Billy Verreynne Software Engineer Member Posts: 28,834 Red Diamond
    edited Jan 10, 2020 7:13AM

    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
    User_KQMQH Member Posts: 1 Red Ribbon

    Hi Vempati,

    Did you find a solution to that?