Extending Oracle Without Replacing It
Oracle Integration Cloud: how to connect your ERP to your other systems
What Oracle Integration is, which integration styles it offers, how it loads bulk data into cloud ERP, and what to decide before connecting systems.
· 4 min read
No ERP lives alone. There is the online store, a logistics provider's portal, the bank, a distributor's system, the spreadsheet someone updates every Monday. Each of those connections is a point where data is entered twice, arrives late or breaks silently.
Oracle Integration, which parts of the documentation still call Oracle Integration Cloud (OIC), is Oracle's platform for connecting applications and automating those flows. This article explains what it includes, how it is used with a cloud ERP, and what decisions to make before building the first integration.
What it is and what it includes
According to Oracle, it lets you configure, automate and manage complex integrations between applications, both cloud to cloud and cloud to on-premises systems. It does this through a combination of prebuilt adapters, process automation templates and a visual builder for web and mobile applications.
Adapters are the piece that saves the most work, because they encapsulate the technical details of each application. Oracle documents, for example, a dedicated adapter for cloud ERP, which lets you query, create or update business records and subscribe to events the ERP generates, such as the approval of a journal batch, the approval of a supplier invoice or the completion of a customer invoice.
Integration styles
When you create an integration, you choose a style. The main ones, according to Oracle's documentation:
- App-driven orchestration: an event or a business object triggers the flow. It is what you use when something has to happen in the moment, for example, notifying another system when a supplier invoice is approved.
- Scheduled orchestration: a schedule triggers the flow, not an adapter. It works for batch processes, such as reading a file every night and processing it.
- File transfer: moving files across the network.
- Publish and subscribe: one system publishes messages and others subscribe, without both having to be active at the same time.
Choosing the wrong style is a common cause of fragile integrations. A process that needs an immediate response should not depend on a file read every night, and vice versa.
Bulk loads into the ERP
A very common case is loading large files from other systems into the ERP, such as journal entries, invoices or opening balances. For this, Oracle uses file-based data import (FBDI) templates and documents a solution with Oracle Integration that formats the file, splits it into manageable parts, uploads it to the application and verifies that the transfer finished. Oracle states that cloud ERP receives these files in ZIP format and that the solution is designed for files of up to 500 MB.
File-based import works for several cloud applications that offer templates: finance, procurement, projects and supply chain. It is also the usual route for loading data in a migration.
Connecting to what is still on-premises
Oracle notes that a company that has already integrated other systems with its on-premises ERP can continue those integrations with Oracle Integration when moving to the cloud. The platform can access resources on an on-premises network or private resources inside a virtual cloud network. This matters because few companies move everything at once: for years, it is normal for part of the work to remain on their own servers.
Security is also split across services. Oracle documents different roles in each service: in Oracle Integration, a service developer creates the connections and integrations and activates them; in the ERP, a user with the Integrations Specialist role. It is a good idea to decide from the start who will hold each one, so that no integration depends on someone's personal account.
When it is not the right tool
An integration platform connects systems; it does not replace a poorly defined process. If two departments disagree about what “active customer” means, an adapter will only move the discrepancy faster. And if what is missing is a screen or an approval flow that no system has, the answer may be a custom application, which is a different topic.
What to decide before building
- Which system is the source of each piece of data. If the customer is created in two places, the integration will not know which one wins.
- What must happen in real time and what can wait for a nightly run.
- What happens when an integration fails: who finds out, how it is retried and how duplicate records are avoided.
- Who owns each integration after launch.
- What data volume to expect today and in two years.
What a first project looks like
The reasonable approach is to start with a single integration that has a clear, measurable pain point, for example, the daily load of invoices from an external system. You document the source and target fields, build and test it in the test environment with real data, define how it is monitored and who handles an error, and only then move to production. Once the first one is working, the next ones reuse connections and criteria, and move faster.
Tell us which systems surround your ERP and which ones are connected by hand today. With that map, we can see which integrations are worth it and in what order. At www.ceteris.mx/oracle-fusion/ you can find more about the platform, or you can schedule a conversation with our team.
Sources
How we can help
Facing something similar?
Tell us which system you run and what it can't do for you today. The first conversation is about understanding your situation.
Request an assessment
Free guide · 24 pages · In Spanish
From Excel to ERP: how to tell if it's time
What we'd tell you in a first assessment meeting, in writing: how to know whether you need an ERP, what it costs in estimated ranges and how to migrate without disrupting operations. Currently available in Spanish; English edition coming soon.
- The 7 signs you've outgrown spreadsheets
- What an ERP costs and what drives the price
- The 5 most expensive mistakes
- A checklist to decide whether it's time