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."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The most valuable feature that we use is the Knowledge Modules."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"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."
"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."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"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 is the ease of customization."
"It's easy to build an integration and make changes to it."
"In general, there were a lot of great utilities for working with files."
"The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects."
"OIC's accuracy is quite good."
"The initial setup is easy."
"The OIC is very good."
"The initial setup of Oracle Integration Cloud Service was easy."
"If you have something like Cisco on top of it, you will have endless problems."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"We used a third party to do the implementation of ODI."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The resource management aspect of the solution could be improved."
"The initial setup is a bit complex compared to other tools."
"It needs easier security."
"Dealing with the large file size has occasionally been a challenge."
"Oracle Integration Cloud Service can improve file handling. Currently, our real-time file polling limitation is 10 MB, if that size can be increased it would be helpful. For example, increasing the size from 10 MB to 1 GB."
"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."
"The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful."
"The solution's customer service could be better."
"They should provide tutorials for beginners to learn about the processes."
"The solution doesn't currently have a fully fledged workflow feature like they have in OIM."
"Make it more similar to the on-premises features. For example, if you can edit the code directly rather than just dragging and dropping, or if you can edit the examples by going into the background, and one-click migration, I'd like to see included in the next release."
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.