Cloud Data Integration Forum

Geeta DeviKodimela
Sr. Director Corporate Systems (Finance, HR, Legal & Global Communications) at a media company with 501-1,000 employees
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?
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.
Alan YvesIs your business a disconnected business? Aren't the legacy systems being synchronized? Is your cloud systems not being synchronized with on premisses-legacy systems? Does your business already have transactional systems such as ERP, CRM in the cloud? And you need to push or pull data from or to the cloud/premises? Is it going to cloud a goal for your business and there is already a strategy for that? if there is then why not going with the ICS? even though ODI can pull and push data to the cloud, depending on the cloud provider you may face issues, for example I have worked on project where the client wanted to pull data from Salesforce(cloud-based CRM) and ODI didn't have native connector, by the way, it had but it was deprecated maybe for commercial issues because Oracle also has a CRM system(Siebel) which competes with SF. To overcome that problem we had to use a custom web service, on the other hand, for example, the same client had multiple SQL server databases on Microsoft Azure which we simply treated as another server and pulled data from there to on-premise Oracle DW. Typically the dilema many business face is the lack of a single view of the main business entities, such as "Customer", "Account" etc..which can lead to whole lot of data discrepancies or wrong information causing an impact on the business and impacting the data-driven decision making. ODI is a really powerful ETL/ELT tool, which can handle virtually any kind of heavy data integration, it is a Java-based application which is super flexible and can easily be customized or extended, It handles quite well the heavy of duty of not only popular RDBMS but also flat files, XML files, JSON, web services etc... if you use SOA, for example, you can set BPEL to call ODI scenarios depending on business rules/events On the other hand as far as I can see the "Oracle Integration Cloud" is quite powerful, being able to integrate on-premises systems with Cloud applications, with many out-of-the-box connectors/adaptors to a wide range of technologies/platforms especially those in the cloud, but also can pull data from premises and synchronise in real time Enabling the business to get rid of silos of data scattered across departments/systems. Data integration is vital to business to have a single view of business events that is happening in their mini-world. To make a decision on this I would check the company's strategy/goal, bearing in mind that cloud is the future and everybody is going there, second I think there is more flexibility to integrate several data formats, structured, semi-structured and unstructured(BIG data essentially)although ODI can also handle big data with the Hive Km, Based on my experience, the government is the type of business where there is more reluctance to go to the cloud due to sensitive data/information. It would be better to have more information about the nature of the business and understand the main bottlenecks or areas where improvement is desired for a precise recommendation.

Sign Up with Email