How to insert the data from SuccessFactors Employee Central to Oracle 10G, ERP database through SAP CPI middleware.
Scenario: Outbound Integration from SuccessFactors Employee Central to Oracle System.
Data will be fetched as per requirement either delta or full volume from the SAP SuccessFactors Employee Central in the SAP Cloud Platform Integration (CPI) using SuccessFactors adapter through Compound Employee API (a SOAP-based web service inside EC, is commonly used to synchronize employee master data between Employee Central and other on-demand or on-premise applications) and need to Insert/Update employee data to Oracle database staging tables.
Since SAP CPI doesn’t provide any kind of JDBC adapter that can connect On-premise Oracle database so far. Below is the approach used to integrate Oracle system via SAP CPI:
Fetch data from SuccessFactors Employee Central using SuccessFactors Adapter in SAP Cloud Platform Integration (CPI) and use file mechanism to get the data consumed in Oracle system.
Above System Diagram explains each block:
Data would fetch from SuccessFactors Employee Central into SAP CPI. Put all Validation and Updation as per requirement in message mapping, xslt mapping or groovy scripting on the data. Generated XML from SAP CPI would be sent to SFTP server