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 most valuable feature is Data movement."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"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."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"The scalability is great. It's one of the reasons we chose the solution."
"The out-of-box integration between Oracle and SAP is really beneficial"
"It's easy to build an integration and make changes to it."
"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."
"The most valuable features of Oracle Integration Cloud Service are the seeded integrations with many communication platforms, such as Slack and emails. It works best for the historical communication methods. Those are still prevalent with all the other clients. When we are doing the integrations, it makes it a little bit easier for us to communicate the same output over Slack, rather than sending out an email and downloading the report. The number of seeded functionalities within the Oracle Integration Cloud Service platform is better."
"The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive."
"The OIC is very good."
"The most valuable feature is the ease of customization."
"The most valuable feature of Oracle Integration Cloud Service is its performance."
"The initial setup is complex, especially if you also have to install a console."
"Stability could be improved because some operators have issues."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"We used a third party to do the implementation of ODI."
"If you have something like Cisco on top of it, you will have endless problems."
"Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release."
"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"Dealing with the large file size has occasionally been a challenge."
"The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful."
"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."
"The solution is expensive."
"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."
"They need to make tools framework available for implementation partners"
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.