We have released a 2 minute tech tip through the Oracle Technology Network (OTN) which talks through the creation of a simple end to end integration using Oracle’s Integration Cloud Service (ICS).
The techniques for integrating Oracle Human Capital Management (HCM) and several other Oracle SaaS solutions can require the use of Oracle Transactional Business Analysis (OTBI). The need for OTBI comes down to the fact that to access to the relevant data an API is not available. OTBI can be configured to generate a report and then transfer the report using FTP. When the report needs to be consumed by ICS then an obvious FTP location is needed. One such option to hold a file for ICS to retrieve is the FTP server provided with the SaaS services (details here).
However, it has come to light that the original intent for this FTP service was for holding bulk data intended to be used for ‘priming’ your HCM instance. As a place for staging data for ICS is in the mid to long term it isn’t recommended. The roadmap for the SaaS product team may result in removing the FTP server.
So the question begs, where should we put the data coming out of OTBI to be consumed elsewhere? Well the next option would be to use Oracle’s Managed File Transfer (MFT). Although historically listed with SOA Cloud Service (SOA CS), it is independently priced and has become a 1st class citizen of the PaaS family more recently. For MFT to be an option it needs to include an FTP server which it does. But MFT also has the abilities for doing a number of orchestration processes, such as calling web services when files are ready. Meaning no need for downstream processes to have to pole for available files.
2 Minute Tech Tip
June 22, 2017
ICS Pricing – ICS Definitive Tip #9
June 12, 2017
Interfacing with HCM (or other file source) via FTP – ICS Definitive Tip #8
June 5, 2017
Custom functions to extend ICS transformations – ICS Definitive Guide #4
May 22, 2017
Connecting directly to DBaaS – ICS Definitive Tip #7
May 16, 2017
The website is dedicated to the book Implementing Oracle Integration Cloud Service written by Robert van Mölken and Phil Wilkins.
On this site you find supporting resources for the book as blog posts extending the book scenarios and useful resources for ICS.