We performed a comparison between Denodo, Oracle Data Integrator (ODI), and TIBCO Spotfire based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."The logical data warehouse functionality is fantastic. It truly stands out. The ClearOptimizer and Virtual Cache are great features. They work together seamlessly to optimize performance."
"The ability to connect to a lot of different sources."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"It can support a number of data sources, and it can pull flat files, from cloud-based databases or from those on-premises. Denodo can pull from any data source and interface with the view. Then, we can publish the view."
"It allows a lot of traceability and you can decide what data you want to collect"
"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."
"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."
"It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo."
"The product has an ELT approach."
"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."
"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 most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"The initial setup is easy."
"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."
"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."
"The most valuable feature is the map visuals that help us connect to the geo-specialized data which is more advanced than other solutions."
"The out-of-the-box features are simple and easy to use across the board."
"We used it pretty heavily in gathering data, which goes to our VPs. They are able to base their next revenue planning based on this metric. So, it has been invaluable."
"It allows users to quickly analyze data from a variety of sources and visualize it with powerful, interactive graphs, and charts."
"Live Query data on demand, R and Python integration, and the ability to write HTML and JavaScript text areas are all valuable features."
"One of the main features is integrated statistical analysis."
"The product's initial setup phase was simple."
"We particularly like the data angling feature of this solution. This gives us the ability to work on data transformations, join files, and carry out other data preparation tasks all in a single tool."
"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 integration could use improvement, it's a lot of non-speed line processes that we have discovered, in the country. The configurations could use a lot more improvement."
"Denodo has some difficulty supporting large numbers of records."
"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."
"The feature that you have to connect on LDAP needs improvement."
"It would be beneficial to make sure that the team that will be using Denodo has some kind of training on how to use the product at least a month beforehand, and there could even be some kind of feedback or Q&A sessions to go along with the training. If Denodo were able to provide this kind of training, it would be very helpful to users in insurance and banking companies because the staff are typically older and not always technically-minded."
"The git configuration really should be improved."
"I would like to see a proper way to avoid killing the sourcing systems."
"The price needs to be lowered. It's too expensive."
"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 initial setup is a bit complex compared to other tools."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"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."
"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."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"The initial setup can be difficult."
"We would like to see some improvement in the default properties of the solution, so that there is less need for us to spend our time coding."
"Print capability and trigger-based events."
"The design of the UI could be improved."
"We would like an easier way to get the product to the cloud. Right now, we have the on-premise version, and we would like to find a way to make it easier to migrate it over to the cloud."
"We would like to see some development in the visualization aspect of this solution, as they can currently only be configured in the cloud, which limits us to one endpoint. It would be helpful if this could be integrated with other tools."
"I would like more easy-to-implement analytical algorithms. At the moment they include things like forecasts and regressions. They need to add a lot more of these types of things to the product because not everyone is a data scientist."
"The handling and consumption of realtime data could be improved."