Oracle Data Integrator (ODI) vs. Oracle Integration Cloud Service

Oracle Data Integrator (ODI) is ranked 1st in Data Integration Tools with 15 reviews vs Oracle Integration Cloud Service which is ranked 9th in Cloud Data Integration with 4 reviews. The top reviewer of Oracle Data Integrator (ODI) writes "It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors". The top reviewer of Oracle Integration Cloud Service writes "The biggest differentiator is that it is simple to integrate. Enriched with Best breed adapters, It covers Integration, orchistration, API Management, Data Management. It still lags on EDI (B2B) Intgr". Oracle Data Integrator (ODI) is most compared with Informatica PowerCenter, SSIS and Oracle GoldenGate. Oracle Integration Cloud Service is most compared with Dell Boomi AtomSphere, Mule Anypoint Platform and Informatica Cloud Data Integration.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Use Null Product? Share your opinion.
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
300,846 professionals have used our research since 2012.

Quotes From Members Comparing Oracle Data Integrator (ODI) vs. Oracle Integration Cloud Service

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pricing and Cost Advice
Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good.

Read more »

Information Not Available
Information Not Available
report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
300,846 professionals have used our research since 2012.
Answers from the Community
Geeta DeviKodimela
Alan YvesConsultant

Is 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.

23 November 17
Kanthi VenkiteelaUser

Hi Nick,

It should be a combination of ICS and ODI. ICS is well versed for SAAS based integrations but does not work for bulk data and its maturing enough day by day whereas ODI is purely for bulk load and with small workarounds(customizations) it fits our purposes.

For your case, I would prefer ODI. If there are huge event-driven web services and integrating third-party systems, I would prefer ICS.

23 November 17
Michael StadtfeldUser

ICS or ODI?

There are more products for integration.

Choose the one which is optimized for the backend system.

Finally, it depends on your budget.

You can try out products like Denodo, QlikView, NodeGraph

23 November 17
Adi KaushalReal User

Attunity is my recommendation.

23 November 17
Jang-Vijay SinghConsultant

If your use-case is near real time - e.g. transactions generated in ERP that need to update data in multiple other systems, then you might wish to go with ICS. If on the other hand you have large data sets (GB or TB) that is processed periodically, then you might use ODI. ICS is better suited to small, lightweight, frequent transactions while ODI would suit ETL for bulk data. Your use-case could have a combination of these as well..

23 November 17
Ranking
Views
36,759
Comparisons
11,998
Reviews
17
Followers
903
Avg. Rating
8.1
Views
4,287
Comparisons
2,373
Reviews
4
Followers
187
Avg. Rating
6.3
Views
0
Comparisons
0
Reviews
1
Followers
1
Avg. Rating
5.0
Top Comparisons
Compared 20% of the time.
See more Oracle Data Integrator (ODI) competitors »
See more Oracle Integration Cloud Service competitors »
Also Known As
ODIOracle ICS
Website/Video
Oracle
Oracle
Null Vendor
Overview

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. 

ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes.  It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.  Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

Oracle Integration Cloud Service (ICS) delivers best in class “Hybrid” Integration. ICS is a simple and powerful integration platform in the cloud to maximize the value of your investments in SaaS and on-premises applications. It includes an intuitive web based integration designer for point and click integration between applications and a rich monitoring dashboard that provides real-time insight into the transactions, all running on a mature runtime platform on Oracle Public Cloud. ICS will help accelerate integration projects and significantly shorten the time-to-market through it's intuitive and simplified designer, an intelligent data mapper, and a library of adapters to connect to various applications.

Information Not Available
OFFER
Learn more about Oracle Data Integrator (ODI)
Learn more about Oracle Integration Cloud Service
Learn more about Null Product
Sample Customers
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State UniversityCalix, Avaya, Land Lakes, Leader, PWC, Vale
Information Not Available
Top Industries
REVIEWERS
Financial Services Firm
29%
Hospitality Company
12%
University
12%
Retailer
12%
VISITORS READING REVIEWS
Financial Services Firm
19%
Comms Service Provider
10%
Healthcare Company
7%
Energy/Utilities Company
7%
No Data Available
No Data Available
Company Size
REVIEWERS
Small Business
32%
Midsize Enterprise
10%
Large Enterprise
59%
VISITORS READING REVIEWS
Small Business
15%
Midsize Enterprise
12%
Large Enterprise
72%
No Data Available
No Data Available
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
Download now
300,846 professionals have used our research since 2012.
We monitor all Data Integration Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.

Sign Up with Email