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.
"The initial setup is easy."
"The product has an ELT approach."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The CAEM is very useful in its modularity and portability."
"Oracle provides great documentation."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The most valuable feature is Data movement."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"The most valuable feature of Oracle Integration Cloud Service is its performance."
"The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive."
"The most valuable feature of Oracle Integration Cloud Service is its ease of use. We do not depend on any tool to develop it. Everything is on the browser and is easy to integrate, even for someone who does not understand a lot about coding."
"It is a scalable solution."
"OIC's accuracy is quite good."
"The initial setup is easy."
"The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"Reverse engineering is complicated and challenging to manage."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Stability could be improved because some operators have issues."
"The resource management aspect of the solution could be improved."
"We used a third party to do the implementation of ODI."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful."
"Sometimes, the tech support is slow to get back to us. We have had to wait up to two weeks for a response."
"It has lengthy documentation, making the process of building applications more time-consuming."
"There are a few features that we noticed are not in the cloud. There are some improvements needed. One example is the graphical user interface that needs to improve, it could be easier to use."
"In designer mode, sometimes the browser closure or other unknown issues can cause strange behavior, which requires a restart."
"The logging capabilities could be enhanced. Currently, logs are only retained for a few days, which can be inconvenient for administrators. Ideally, we'd like the option to configure log retention periods, like a month or fifteen days, instead of the current one-week limit."
"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."
"Lacks features for more complex integrations."
More Oracle Integration Cloud Service Pricing and Cost Advice →
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 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 Informatica PowerCenter, SSIS, Azure Data Factory, Oracle GoldenGate and Talend Open Studio, whereas Oracle Integration Cloud Service is most compared with AWS Glue, Mule Anypoint Platform, 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.