OIC vs Apex for PaasforSaas
Summary
OIC vs Apex for PaasforSaasContent
The Oracle ERP Cloud (SaaS) mainly uses FBDI or file based data integration pattern for batch integration and SOAP services for real time integration. There are REST services as well but mostly in the HCM area.
How stable and flexible is OIC as an integration platform for Oracle ERP Cloud? How does the message based costing model work out for file based batch integrations?
Would APEX (as part of the database cloud service) be able to serve as an alternative to OIC given that it has web service support capabilities, comes with a database with all of the PLSQL features which means we could easily create the CSV files needed for the FBDI integration mechanism supported by Oracle ERP Cloud, and is also lower in costs than OIC? Neither the standard or enterprise bundle of OIC come with a database and offer no PLSQL capability to add business logic.