We performed a comparison between Denodo and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Overall, the product works quite well and has a good set of features."
"This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"The most valuable feature is Data Catalogs."
"Access to numerous forums and internet information."
"It allows a lot of traceability and you can decide what data you want to collect"
"The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."
"The ability to transfer data is very valuable."
"The ability to connect to a lot of different sources."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"The initial setup is easy."
"It is an ETL tool, which does the extract, transform, and load."
"The product has an ELT approach."
"The installation of the client ODI Studio is easy."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"Monitoring event logs can be improved. In the older version, there was a monitoring schedule to get event reports and properly audit the reports. In the newer version, it is not there, and we have to manually configure data and audit events."
"Denodo has some difficulty supporting large numbers of records."
"Denodo can improve usage management-related aspects. If you deal with the mini views, it gets stuck. The performance is very slow when we go with a large number of views and high volume."
"I would like to see a connectivity option with third-party apps, for example, JDBC, and ODBC drivers. Currently, we need to install it separately from the Denodo side and then connect it."
"We occasionally have some integration issues that we need to work through."
"The solution is slow when there are many virtualization layers."
"The data catalog certainly has room for improvement. It is functional but we look forward to development. We are in constant contact with Denodo and they are fully aware of our needs."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"The performance of the user interface is in need of improvement."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"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."
"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."
"It needs easier security."
"The price needs to be lowered. It's too expensive."
"We used a third party to do the implementation of ODI."
"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."
Denodo is ranked 12th in Data Integration with 29 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Denodo is rated 7.8, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, 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". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Informatica PowerCenter, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate. See our Denodo vs. Oracle Data Integrator (ODI) report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
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.