We performed a comparison between Oracle Data Integrator (ODI) and Oracle Integration Cloud Service based on our users’ reviews in four categories. After reading the collected data, you can find our conclusion below.
Comparison Results: Users prefer Oracle Integration Cloud (OIC) due to its intuitive, easy-to-use dashboard, and say the vast amount of available adapters make integrations very simple.
"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."
"Oracle provides great documentation."
"The initial setup is easy."
"It is an ETL tool, which does the extract, transform, and load."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"In general, there were a lot of great utilities for working with files."
"The out-of-box integration between Oracle and SAP is really beneficial"
"Oracle Integration Cloud Service integrates well and is user-friendly. If you are not a developer or ops engineer you can still use the solution with ease. You do not need to have developers' knowledge, you can easily adapt and learn quickly to integrate the services. They have good documentation."
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value."
"The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us"
"Oracle Integration Cloud Service offers a lot of adaptors."
"I particularly like the drag-and-drop feature for designing integrations and processes."
"Stability could be improved because some operators have issues."
"The solution lacks some functions and features."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"The performance of the user interface is in need of improvement."
"The resource management aspect of the solution could be improved."
"Reverse engineering is complicated and challenging to manage."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"Now the platform is not built in a way that you can define."
"The support and resources were lacking — they weren't there."
"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"While most of the adapters are available through Oracle Integration Cloud Services, they do not have a lot of features. I would like to see some enrichment in this area and for the solution to go deeper into the applications and upgrade the adapters."
"Dealing with the large file size has occasionally been a challenge."
"In designer mode, sometimes the browser closure or other unknown issues can cause strange behavior, which requires a restart."
"The bulk processing needs improvement."
"The solution is expensive."
More Oracle Integration Cloud Service Pricing and Cost Advice →
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while Oracle Integration Cloud Service is ranked 3rd in Integration Platform as a Service (iPaaS) with 32 reviews. Oracle Data Integrator (ODI) is rated 8.2, while Oracle Integration Cloud Service is rated 8.0. The top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". On the other hand, the top reviewer of Oracle Integration Cloud Service writes "An integration tool that is highly compatible and easy to maintain". Oracle Data Integrator (ODI) is most compared with SSIS, Informatica PowerCenter, Azure Data Factory, Oracle GoldenGate and Talend Open Studio, whereas Oracle Integration Cloud Service is most compared with Mule Anypoint Platform, AWS Glue, Oracle GoldenGate, Azure Data Factory and Microsoft Azure Logic Apps. See our Oracle Data Integrator (ODI) vs. Oracle Integration Cloud Service report.
We monitor all Data Integration 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.
Integration Cloud is more focused on event-driven integration models. It is also an OCI native service.
ODI is primarily suited to bulk data activities such as data loads, data migration. Now ODI has two flavours: native OCI with a small feature set aimed at enabling cloud migration and then the traditional ODI.
The traditional version is the same product as used on-premise but packaged to run a VM. As a result, it is offered on the Oracle cloud marketplace.
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that come up, though, as far as integrating and maintaining the system. Organizations that choose this product will need to bring experts on board to oversee the security and system administration. Those aspects are so complex that to keep the system running smoothly and effectively, you need to employ people who know the proper IT procedures to manage them. Ultimately, an organization will have to make additional investments to get proper use out of Oracle Integration Cloud Service.
Oracle Data Integrator offers a comparable level of set up complexity to Oracle Integration Cloud Service. The program for the initial setup does offer step-by-step instructions which make deployment easier. However, additional software such as Agent Setup is required for ODI to function fully. Therefore, while an organization can follow a guide to set up ODI, additional steps beyond the initial deployment are necessary before one can use the product fully.
Oracle Integration Cloud Service offers different pricing models for their licenses. Among the easiest for businesses to deal with is a pay-as-you-go option. This provides organizations with great flexibility in choosing what they want to pay and the type of services that they want to receive. Organizations will be able to spend their resources more effectively when they control the prices that they are paying.
ODI has a price which is not exactly the most expensive solution on the market. However, it is not the cheapest either. There is no flexibility in ODI’s pricing like there is for Oracle Integration Cloud Service. Organizations really only have two options: they can pay the price or use another product. ODI does not allow for the kind of customization that Oracle Integration Cloud Service offers.
Conclusion
Oracle Integration Cloud Service and Oracle Data Integrator are comparable as far as the difficulty that an organization might have in setting them and deploying them. In both cases additional resources are needed after the initial setup stages in order to get them set up properly. The area in which they truly differ is in the ability of Oracle Integration Cloud Service to be customized, both in terms of price and in terms of services obtained. ODI lacks this flexibility.