We performed a comparison between Denodo, Informatica PowerCenter, 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."It allows a lot of traceability and you can decide what data you want to collect"
"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."
"In general, it's good for us to make tests so we can scout the data."
"The most valuable features of Denodo are the extraction option for adapters, and there are many things for the views, that are cached. Denodo is not storing the data, it looks first to tune the query, and these things are for the agents."
"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."
"Denodo is very stable."
"The ability to connect to a lot of different sources."
"The most valuable feature is Data Catalogs."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"The solution is stable."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"PowerCenter performs well during data transformation and optimization."
"It is an excellent ETL tool."
"It's very easy to use it to develop mappings and workflows."
"Deployment was simple and straightforward."
"This solution allows us to integrate data from across all client departments, for effective reporting via a single dashboard."
"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."
"R and automation services."
"The ability to connect to many different data sources is one of the key features. The other would then be the different ways in which that data can be visualized."
"It’s stable and straightforward."
"Spotfire is excellent for scientific applications, especially because of its integration with RNG."
"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."
"One of the main features is integrated statistical analysis."
"Denodo's training documentation could be improved by providing more material. From an administrative standpoint, I've found that only Denodo websites provide the usual tutorials. It may be because it's a bit of a restricted tool, but it results in trouble with learning. Normally, I can find help and solutions from other sources, but I haven't been able to find any for Denodo. Other that, it's fine and it performs well. I only have six months of experience, so I can't accurately suggest improvements."
"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."
"The solution is slow when there are many virtualization layers."
"Performance management could be improved."
"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."
"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."
"The git configuration really should be improved."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"There is some room for improvement in terms of pricing."
"Requires an established data center because there is no option for software as a service."
"The solution must improve the integration with new services."
"The data compression has room for improvement."
"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."
"One aspect where Spotfire could improve is its global recognition, especially in terms of support."
"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."
"The number of charts available out of the box in Spotfire can be enhanced."
"When you do the data loading, it is slow."
"The handling and consumption of realtime data could be improved."