The client that we were working with had a set of middleware systems – most prominently Microsoft BizTalk. They had several integrations running on these platforms and were looking to migrate these integrations to a single middleware platform that offers better compatibility with the existing source and target systems. Also, the client wanted to leverage the flexibility of a Cloud-based solution. Most of the target systems here being Oracle applications, we decided upon Oracle Integration Cloud. It allowed us to leverage some additional features available for Oracle Applications and easily integrate other Oracle Cloud solutions for Audit Logging. Here in this blog, we are describing a couple of use cases that we implemented during this migration.
Although we worked on a number of integrations during this migration, here in this blog, we are focusing on the following two use cases. They are fairly simple and follow almost the same flow in the integration. This will give an overall idea about file-based data integrations for Fusion adapters in OIC.
- Integrating the currency conversion rates from FTP to Fusion ERP Cloud.
- Integrating bank statements (in MT940 format) from FTP to Fusion ERP Cloud.
The files will be placed in the SFTP server, and the integration will fetch the files, do the data transformation if required and import it to ERP Cloud using the Import Bulk Data process. Take a look at the architecture diagram given below.
Diagram: FTP to ERP Cloud Integration Architecture
As explained above, the integration will fetch the files periodically and import them to ERP, and for auditing purposes, we included the Oracle ATP database and Oracle Object Storage. A table in Oracle ATP DB will keep track of the files processed and their status, including error details, if any. The object storage is used to store the log files of failed jobs received from the callback event, and for data transformations and some dynamic mappings, we have used some custom JS functions.
Firstly we need to create the connections required for the integration. Here the main adapter that we are using is the Oracle ERP adapter which allows us to create both inbound and outbound integrations. The adapter simplifies the Oracle Enterprise Resource Planning (ERP) communication with other SaaS and on-premise applications. The connection configuration of ERP connectors in OICS is very simple and requires only the Cloud base URL and security parameters. Also, it supports the ErpImportBulkData event subscription and enables the Oracle WebCenter Content (Universal Content Manager) to upload files in encrypted or unencrypted format. Finally, we need to create the FTP connection.
Once the connections are created, we can start creating the integration using the schedule orchestration style.
After creating the integration, the integration flow is created by the following steps.
- Configure the FTP adapter and use the read operation to read the files from the server.
- Now invoke the ERP Cloud adapter by dragging and dropping the adapter just after the FTP.
- Select ‘Import Bulk Data into Oracle ERP Cloud.’
- Now select the appropriate bulk data process.
- Enable the callback and on the summary page, click done.
- Now open the mapper and edit and map the necessary fields.
Implementing the Oracle Callback Integration
We can implement the callback by choosing the integration style as ‘App Driven Orchestration.’
After creating the integration, follow the below steps.
- Configure the ERP adapter as trigger.
- Select ‘Receive Callback Message upon completion of FBDI bulk import job submitted via another integration’ option and select ‘Always’ from the dropdown.
- Create the integration.
- Now open the notification action and give an email address, email body, and add the file attachment.
Once the import job is completed, the ‘ERPImportBulkData’ raises an event. The callback integration is subscribed to this event by default. The event will be consumed by the callback integration. While configuring the callback integration, just select the option ‘Receive Callback Message upon completion of FBDI bulk import job submitted via another integration’ and select the program for which callback is received. Automatically, this callback integration will subscribe to the ‘ERPImportBulkData’ event.
Capabilities of Oracle Integration Cloud
- Easy connectivity with Cloud and on-premises.
- Connects your applications, on-premise with Cloud (Integration Cloud Service) and helps in designing, monitoring, and managing connections between your applications.
- Pre-built integrations with common scenarios.
- ICS provides a high number of adapters to integrate with Cloud and on-premises. Around 50 adapters are available for connectivity.
- ICS is a lightweight service used to achieve simple integrations without much complexity.
- Less admin work since it is autonomous and avoids all installations.
In conclusion, by replacing Oracle Integration Cloud as middleware instead of Microsoft Biztalk, we were able to make use of some additional features. Since the target systems were mostly Oracle applications, we could use the prebuilt adapters and their features which provide callback events to track the job completion and File-Based Data Integration features, which in turn made the integrations much easier to build. Oracle’s Cloud platform makes it easier to manage and maintain integrations with ease without much administration responsibilities from our end. Also, the wide varieties of pre-built technology adapters and system-oriented adapters, along with prebuilt templates make the development phase shorter. Other features like agents provide seamless integration to the on-premise tools.
Senior Software Engineer, RapidValue