Cloud Data Integration Forum

Anonymous avatar x80
Sr. Director Corporate Systems (Finance, HR, Legal & Global Communications) at a media company with 501-1,000 employees
Nov 23 2017
What is your recommendation in choosing an integration product for implementing fusion applications? ICS or ODI?I have heavy duty file processing in interfacing Cloud ERP with many 3rd party systems, but not they are not voluminous. Which would you recommend?
A4b1aab0 dd70 497a 913b 0adab722121f avatar
Jurijs (Yury) Fjodorovs ICS and ODI are not mutually exclusive, and can be used in a tandem, ICS is good for publish and subscribe patterns, also has lots of adapters such as file, ftp and various SaaS adapters. ODI is for heavy transformations, but has almost no concept of publish and subscribe (there is pub/sub pattern within ODI but is not the same as messaging pub/sub). So, I would use ODI for heavy transformations on large files if required, ICS for integration via out of the box provided adapters.
Anonymous avatar x80
Author at a tech services company with 1,001-5,000 employees
Which ETL tool is be better to use on Azure Cloud? Informatica or SSIS? Can you lists the pros and cons for both ETL tools?

Sign Up with Email