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

Oracle Data Integrator (ODI) is ranked 4th in Data Integration Tools with 10 reviews while Oracle Integration Cloud Service is ranked 5th in Integration Platform as a Service (iPaaS) with 5 reviews. Oracle Data Integrator (ODI) is rated 8.4, while Oracle Integration Cloud Service is rated 7.0. The top reviewer of Oracle Data Integrator (ODI) writes "I have used it to improve run-times of many corporations' overall integration run-times". On the other hand, the top reviewer of Oracle Integration Cloud Service writes "Good mapping, very user friendly, and easy to maintain". Oracle Data Integrator (ODI) is most compared with Informatica PowerCenter, SSIS, Oracle GoldenGate, IBM InfoSphere DataStage and Talend Open Studio, whereas Oracle Integration Cloud Service is most compared with Mule Anypoint Platform, Boomi AtomSphere Integration, Informatica Cloud Data Integration, SAP Process Orchestration and SSIS.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: July 2020.
430,376 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner.The most valuable feature that we use is the Knowledge Modules.It's completely user-friendly.​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.It has the ability to easily load slowly changing dimensions.

More Oracle Data Integrator (ODI) Pros »

The most valuable feature is the ease of customization.The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like usThe most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value.It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors.

More Oracle Integration Cloud Service Pros »

Cons
There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue.The performance of the user interface is in need of improvement.Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasonsIt lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.

More Oracle Data Integrator (ODI) Cons »

Our client was quite concerned about the cost, which is something that could be reduced.They need to make tools framework available for implementation partnersNow the platform is not built in a way that you can define.Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release.

More Oracle Integration Cloud Service Cons »

Pricing and Cost Advice
We found that the cost compared to other integration tools is a little high, but the solution works great.

More Oracle Data Integrator (ODI) Pricing and Cost Advice »

Information Not Available
report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
430,376 professionals have used our research since 2012.
Answers from the Community
Patricia Gonzalez
author avatarArshiya Chand (Infosys Technologies Ltd)
Consultant

ODI – The difference I see is it is used for data integration to load huge data from across different databases and within the same databases like PLM to BI, EBS to BI, etc.

OCI – It is for integrations between systems like SOAP services etc.

author avatarRicardo Giampaoli
Consultant

I would say the biggest difference is that ODI is a corporate class tool that can do anything no just in a matter of ETL but a process controls since you can have ODI managing your entire environment using java code to start processes, or calling web services and more. OIC would be a more focused application create as a workflow to load and extract data of your cloud apps.

If you intend just to automate your cloud env, and you will have everything on the cloud, OIC is enough for you. If you already have a big on-premises environment and want to extend that to the cloud and wand to seamlessly integrate them, I would stay with ODI.

You can take a look at this article that I wrote some time ago to give you a better idea of what I'm talking about:
https://www.oracle.com/technical-resources/articles/middleware/radtke-giampaoli-odi-cloud.html

In the end, if you want to have a very very flexible tool that can do anything, ODI it is. If you want just to integrate your cloud apps, OIC it is.

author avatarPhil Wilkins (Capgemini)
Consultant

ODI is typically used for batch/micro batched based processes. Its origins are with ETL (Extract Transform Load) or as Oracle describes it ELT (putting the work for transform into the DB rather than the transfer component). That said it does have a lot of adaptors for no DB centered sources.

OIC is event focused - although an event could be a DB trigger. Therefore the payloads are typically smaller. If you had a data extract, then you'd expect to iterate over the extract processing a row at a time rather than a bulk transaction. As a result, it is better for choreographing multiple system changes e.g. sales order --> update manufacturing, book shipping, invoice customer, etc. OIC also has increasingly more powerful integrations with Oracle SaaS, for example, can be aware of events flowing within ERP, HCM to trigger other tasks. ODI does have or need this.

OIC has a richer toolset, for the EE edition you get the use of Process Cloud which is best for very long-running processes (days and weeks not minutes and hours) and human workflow. The visual Builder is also incorporated, providing the means to build apps, and particularly good at building and integrating extensions to core Oracle SaaS.

In a Hybrid context, where ODI is located can create some connectivity challenges - host in the cloud, you could be confronted with issues of getting connected to an on-prem DB. Whereas OIC has a connection/execution engine which can gather and push data to the cloud OIC for onward processing (outbound data flows are more acceptable security-wise)

author avatarLiliana Rey
User

ODI is the tool to build ETL processes. But I don't know the Oracle Integration Cloud Service solution.

Ranking
4th
Views
20,935
Comparisons
13,549
Reviews
11
Average Words per Review
458
Avg. Rating
8.2
Views
6,142
Comparisons
4,766
Reviews
5
Average Words per Review
515
Avg. Rating
7.0
Popular Comparisons
Compared 16% of the time.
Also Known As
ODIOracle ICS
Learn
Oracle
Oracle
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.

Offer
Learn more about Oracle Data Integrator (ODI)
Learn more about Oracle Integration Cloud Service
Sample Customers
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State UniversityCalix, Avaya, Land Lakes, Leader, PWC, Vale
Top Industries
REVIEWERS
Financial Services Firm30%
Hospitality Company10%
Insurance Company10%
Retailer10%
VISITORS READING REVIEWS
Computer Software Company54%
Comms Service Provider9%
Media Company5%
Retailer4%
VISITORS READING REVIEWS
Computer Software Company64%
Comms Service Provider4%
K 12 Educational Company Or School4%
Financial Services Firm3%
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: July 2020.
430,376 professionals have used our research since 2012.

See our list of best Data Integration Tools vendors.

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.