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 ability to connect to a lot of different sources."
"It is a very stable solution."
"The best thing about Denodo is that creating and deploying a web service can be done in about 10 minutes, compared to a whole day when it comes to other solutions (such as when deploying with Java and AWS)."
"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 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."
"It is easy to virtualize data using the solution."
"The performance and the speed to market are the most valuable features of this solution."
"Denodo makes it easy to export data as a service or data link to other services."
"It's scalable."
"The most valuable feature that we use is the Knowledge Modules."
"The initial setup is easy."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"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."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The two features that I have found most valuable are its ability to customize the dashboards when it comes to the evaluation. The second feature is its ability to handle a large amount of data, which is also something very unique about it."
"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’s stable and straightforward."
"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."
"It's scalable."
"R and automation services."
"This solution allows us to integrate data from across all client departments, for effective reporting via a single dashboard."
"The solution is an affordable one."
"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."
"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."
"User-specific security at the column and row levels needs to be improved. Instead of applying security at every individual level, it would be better if it were at the group or tier level. It will save a lot of time."
"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."
"There are a couple of areas that can be improved in Denodo. From a stability point of view, sometimes we see issues in the data management functionality. This only happens now and then, however, and usually takes place when we add in our own customization."
"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 occasionally have some integration issues that we need to work through."
"The solution should have its own acceleration technology."
"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."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The performance of the user interface is in need of improvement."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The initial setup is a bit complex compared to other tools."
"Reverse engineering is complicated and challenging to manage."
"Technical Support could be better."
"The initial setup is complex, especially if you also have to install a console."
"The number of charts available out of the box in Spotfire can be enhanced."
"Print capability and trigger-based events."
"The handling and consumption of realtime data could be improved."
"When it comes to data manipulation, there are features which are good, but one of the features which has really been missing in Spotfire is an offline ability for data manipulation."
"Compared to competitors, the UI is quite dated."
"Personalising Spotfire, as a whole, is painful and is something that could be made easier."
"The way TIBCO Spotfire is designed, in my opinion, is the reason why it lags a bit, especially compared to other BI tools like Qlik."
"One aspect where Spotfire could improve is its global recognition, especially in terms of support."