Orace ERP Cloud Integration
An ERP System usually acts as an integral part in the middle of a heterogenous system landscape. In many cases
-
It receives orders or customer invoices from third party CRM or Billing Systems
-
Bank Statements and Statements from Payment Service Providers (PSP’s)have to be imported, processed and reconciled
-
Purchase Orders and / or Supplier Invoices have to be loaded
-
External Logistical Service Providers (LSP’s) have to be connected
-
General Ledger Data have to be provided to external systems and / or Data-Warehouses for analysis, planning and consolidation purposes
​​
For all of these third party interactions integration components are required.
There are several different approaches for System Integrations but at the end of day
-
data Objects have to be transferred between (at least) two systems - in many cases event driven in a
(near) realtime mode -
the status of the data exchange (success or failure) has to be tracked
-
all errors have to be flagged and corrected
-
a periodic reconciliation of the exchanged data is required
​​
In an ideal scenario, there are instant out-of-the-box integrations (‘Standard Adapters’) available, covering all those requirements.
​
For all ERP Cloud integration scenarios where Standard Adapters are not available, we do provide custom integration packages, covering the following components:
-
Joined Data Object Definition
-
leveraging the Oracle Standard Data Object definition wherever possible
-
-
Complete Design and Development of the entire Transformation & Load Process
-
including data aggregation and/or the calculation of values based on the payload content
-
-
Provision of a Rest End-Point for each Data Object
-
To be called (http-post) from the Source System to transmit the event & payload
-
-
Acknowledgment messaging back to the source system
-
Error Management Framework
-
error queue containing all failed imports along with an error code and an error message
-
notification back to the source system
-
a User Interface to manage the error queue
-
-
End-to End Test & Production Deployment
-
Component Test, System Integration Test
-
Sample Test Scripts User Acceptance Test (UAT)
-
UAT Support​
-
Oracle Integration Cloud Services
As a foundation for our integration services we rely on Oracle Integration Cloud Services .
Why ? Oracle Integration Cloud
-
offers options to create functional extensions, e.g. automations of processes in Oracle ERP Cloud.​
-
includes a wide variety of out-of-the-box adapters for state-of-the-art systems​.
-
can be configured based on the business needs via flexible message pack approach.​
-
provides event based realtime integration.
-
allows scalable integrations covering the entire ETL process​.
-
offers functionalities to transform source file formats to comply specific target formats.​
-
can be used to automate end2end integration path​.
-
provides low-code as well as sophisticated integration development features.​
-
includes continuous monitoring capabilities for interface statistics as well as error handling.
​​
Third Party Integrations with Oracle ERP
We have successfully integrated a large variety of third parties wit Oracle ERP solutions:
-
Salesforce
-
ServiceNow
-
Hubspot
-
Coupa
-
Amazon Redshift
-
all major PSPs (Paypal, Stripe, Adyen and many others)
-
Many 3PLs
-
Numerous company specific backend systems
​​