You have Oracle ERP Cloud, or Oracle Supply Chain Cloud…or CX…you also have several on-premise applications, and integrations are your current worry.
Oracle offers you a “platform”, for doing development and integration in the Oracle Cloud. But should I subscribe Oracle PaaS? Which tools are available? Which are the ones I need for integrating my different applications?
There is not a straight answer, but I will try to explain as simple as I can what could you do with Oracle PaaS, and which your options are.
The first and honest consideration is that the right tools for you will always depend on your integration needs. Scenarios are different, from simple to complex ones.
Simple scenario: having Oracle ERP Cloud only.
If this is your scenario, you need to know there are embedded integration tools in your ERP, more manual maybe, but not in all cases your will need PaaS.
Let´s review ERP Cloud integration alternatives:
- FBDI means File-based data imports.
For very simple, cheap (and a bit manual) integrations, there is FBDI.
These are like Excel spreadsheets available in ERP Cloud in many transactions and setup tables. You can use them for extracting or uploading data from the ERP. FBDI is embedded in ERP Cloud, and a difference from the on-premise ERP, where extracting data from a table meant an sql. In Cloud we cannot do sqls, so you can use FBDIs, users can do that after they are trained.
There are clients that have applied this tool a lot, because of a terribly limited budget.
It means Oracle Transactional Business Intelligence (OTBI). It was designed for users who want to create their own custom queries, reports, dashboards, charts and graphs to aid daily decision making. So this is a bit more than extracting data from a table, they have more logic, colors, graphs, and they can also be done by users.
- For more automation or real time integrations there is ERP Cloud WEBSERVICES.
Web services are typically based on multiple business objects and allow the caller to perform operations on these business objects. Oracle publishes the web services available for all ERP Cloud modules, and this is the ONLY “door” for extracting or updating a piece of data automatically.
- But how do you invoke webservices? An application should. It can be any external application, or you can user the ORACLE PAAS platform for building your own integrations and software. We are then talking about a more complex integration scenario.
Complex scenario: having many Cloud and on-premise applications to integrate and automate.
Oracle Platform as a Service, or PaaS, is a comprehensive, standards-based, fully integrated combination of Oracle and open source technologies that enable you to build, deploy, migrate and manage a variety of different application workloads.
PaaS offers many services:
- IntegrationCloud Service
- Analytics Cloud
- Database Cloud Service
These ones and many other Oracle PaaS services are part of an environment in which you can deploy and secure custom applications and data.
The Oracle service that was born to build integrations is Oracle Integration Cloud, that includes an extensive library of adapters to Oracle and 3rd party SaaS and on-premises applications to enable you to deliver new business services faster.
Oracle Integration Cloud (OIC) contains pre-built integration flows between many Oracle Cloud applications, process automation capabilities, and visual design features, all powered by Machine Learning recommendations or suggestions.
Java Cloud Service (JCS), on the other hand, is the right one when you want to build and deploy totally new applications. Those applications can also be integrations, and many clients have used JCS instead of OIC as well. The reason is because it was better for their applications scenario, that have included a mixture of new applications and new logic, not only integration.
Oracle PaaS is a complete platform, with the newest integration, development a database technologies. There is a lot to tell about this. The tools are all there, in Oracle PaaS, and being well-guided at the moment of designing your integrations and applications architecture is the key of a successful integrations project.