Integration Usecase
Summary
OnPrem DB to Fusion integrationContent
Dear Experts,
We are evaluating PaaS offerings to implement the following Integration use case :
Integrate transactional data from an On-Prem MS SQL Server DB to Fusion Cloud ERP. We expect the load to be heavy ( 150K transactions daily) and are considering ODICS or OIC to implement it . Additional requirements include field level validations, orchestration before submitting payload to Fusion webservice.
There is an estimate of a 1MB payload per transaction ~ 150 GB of data prcessing : Is OIC a recommended solution?
We observe that ODICS has limitation in terms of invoking Fusion web services and need to know if we can build the above integration using OIC in an effective way.