Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 159 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
How to call an ODI Scenario from APEX?

Hi Team,
Could please suggest on the better approaches to call an ODI scenario from APEX.
Thanks,
Vempati
Answers
-
That depends on the interfaces supported by ODI. Are there PL/SQL interfaces, web service (SOAP/JSON) interfaces, etc?
-
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
-
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.
-
Hi Vempati,
Did you find a solution to that?