Oracle MFT – OIC Integration

Even in a day and age where event-based and real-time data exchange is prevalent and growing, the truth is there are still massive amounts of data exchanged using file transfer mechanisms.  Oracle has always played in this realm, but with limited success.  The Oracle Managed File Transfer (MFT) application is pretty good, but nothing to write home about… or write a blog about! 😀

One reason is because moving files around and using FTP servers is not very glamorous.  Another reason is because the Oracle MFT management dashboard is pretty limited.  It is able to monitor various aspects of a file transfer, report success or failure and allow you to resend files.  But it has no business context or the ability to understand how a file might be part of a larger business process.

Selection_341

Continue reading “Oracle MFT – OIC Integration”

Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud Service

In this blog, we will use Oracle Managed File Transfer (MFT) and Integration Cloud Service (ICS) to automate batch uploads into Oracle ERP Cloud. We will perform this upload with invoices, a typical use-case for organisations that work with numerous vendors and would like their vendors to bulk invoice them through say an SFTP file drop.

Steps are as follows:

  1. Drop the file into an SFTP folder that is managed by MFT
  2. MFT picks it up and uploads it into ERP Cloud’s WebCenter Content file repository
  3. MFT calls ICS to trigger a multi-step orchestration to load ERP Cloud
  4. Using the ICS ERP Cloud adapter, the ICS orchestration first loads the file into staging tables and import the invoice into final tables

Folks who have read my previous blog, Using MFT Cloud Service to Automate HCM Batch Uploads – Part 1 will notice how similar this is to HCM Data Loading, except that we use ICS to orchestrate a few post-load steps.

That is because HCM and ERP Cloud (also SCM and SalesCloud) are all Oracle Fusion Applications, modules built on the same platform. Some of you may even be on “Global Shared Instances”, essentially running both your HCM and ERP SaaSes in the same instance.

Continue reading “Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud Service”

Using MFT Cloud Service to Automate HCM Batch Uploads – Part 2

In Part 1 of MFT to HCM integration, we configured MFT to perform a batch upload of employees from an SFTP folder to HCM and informed HCM to import the data.

Once the file is placed in the source folder, its picked automatically by Oracle MFT and then transferred to the Target. After the target has successfully received the file, MFT again takes care of invoking any dependent actions. These post-processing actions include items such as decompressing, decrypting, renaming, calling a downstream action, and notifications.

MFT provides default activities, as well as a flexible callout extension framework built in Java that can utilised to call any action you wish.

Here in Part 2, we will talk about design and deployment of the Post-Processing Java Callout that is utilised to trigger the HCM Cloud ImportAndLoadData service.

Continue reading “Using MFT Cloud Service to Automate HCM Batch Uploads – Part 2”

Using MFT Cloud Service to Automate HCM Batch Uploads – Part 1

In this blog, we will use Oracle Managed File Transfer Cloud Service to perform batch loads into Oracle HCM Cloud.

Use cases for this include updating Employee data from external systems e.g. recruitment, uploading employee pictures from a badge creation system or syncing data while running hybrid with PeopleSoft.

Continue reading “Using MFT Cloud Service to Automate HCM Batch Uploads – Part 1”

Teaching How to build Oracle Managed File Transfer (MFT) Transfers

Oracle MFT Provides the connectivity to end applications among FTP, sFTP, File and web services. It helps remove the need to maintain FTP and sFTP servers, as it comes with these embedded servers out-of-the-box. It allows to secure, SSH, SSL and PGP Encryption. One of the best features is that it provides high visibility and auditability. It is able to deal with many use cases, i.e. trickle feeds, scheduled loads, on demand, etc.

In order to illustrate a sensible scenario, in this blog I am going to simulate a hypothetical integration from Red Cross Blood Services moving invoices. My goal is to show how simple it is to build a Managed File Transfer using Oracle MFT technology. For this case, we are going to use the Oracle MFT embedded FTP Server as the source and File System as the target. Also we are going to illustrate how to use the pre-processing and post-processing actions either at the source or target endpoints. For any question or comment please contact the creators of this document.

Continue reading “Teaching How to build Oracle Managed File Transfer (MFT) Transfers”

%d bloggers like this: