We performed a comparison between Actian Pervasive Data Integrator [EOL], Denodo, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"One thing that we have noticed is that when you have a BI tool, you end up building a lot of the logic in the BI tool, but as a company, every company wants to be tool agnostic because today, you could be in the Qlik Sense, and tomorrow, you may decide to go with Tableau or something else that is there. If you have put a lot of logic within the tool, transitioning or moving away from one BI tool to another tool becomes a very intensive process. By keeping the logic in Denodo, you can move to any tool."
"Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot."
"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"It allows a lot of traceability and you can decide what data you want to collect"
"It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo."
"The ability to transfer data is very valuable."
"Overall, the product works quite well and has a good set of features."
"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"The most valuable feature that we use is the Knowledge Modules."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"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."
"The CAEM is very useful in its modularity and portability."
"It has the ability to easily load slowly changing dimensions."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI."
"Lacks integrations with AWS, GCP and the like."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"Tasks such as conversion of a date format or conversion of a number format that can be done in a very easy way in different languages, like SQL or Oracle, are not so easy to do in Denodo. For example, if you want to convert a date from one format to another, in Oracle it's pretty easy; in Denodo, however, it requires so many lines of code. Simple things that can be done very quickly in other database languages require more lines of code in Denodo."
"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."
"The support is not the best and should be improved."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"Documentation needs to be improved"
"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."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"Reverse engineering is complicated and challenging to manage."
"The initial setup is complex, especially if you also have to install a console."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"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."
"The solution lacks some functions and features."
Earn 20 points
