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.
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The scalability is great. It's one of the reasons we chose the solution."
"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."
"The initial setup is easy."
"It is an ETL tool, which does the extract, transform, and load."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"It's completely user-friendly."
"OIC's accuracy is quite good."
"Provides various ways to secure services as well as providing extensive support."
"The OIC is very good."
"The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us"
"The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive."
"Technical support responds quickly."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"The initial setup of Oracle Integration Cloud Service was easy."
"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."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"Reverse engineering is complicated and challenging to manage."
"The initial setup is complex, especially if you also have to install a console."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"The resource management aspect of the solution could be improved."
"The price needs to be lowered. It's too expensive."
"Technical Support could be better."
"We would love to have more and more ready-to-use interfaces from Oracle."
"The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful."
"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."
"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."
"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."
"It would be helpful if there were more tutorials or documentation to learn about Oracle Integration Cloud Service."
"The solution's customer service could be better."
"Dealing with the large file size has occasionally been a challenge."
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.