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."The most valuable features are data lineage and the concept of a semantic layer."
"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."
"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"While we may not be using all the features of Denodo at this time, we have found the data virtualization features to be very useful in helping us connect our data sources together, bringing all our data into one platform."
"The ability to transfer data is very valuable."
"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 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 a very stable solution."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It's a complete package, which is why we use this solution."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"In the end, you have structured, proper data for use in an integrated BI solution."
"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."
"The setup is very simple."
"Spotfire is excellent for scientific applications, especially because of its integration with RNG."
"I appreciate Spotfire's range of visualization options, advanced analytics features, and seamless integration with other TIBCO products."
"One of the main features is integrated statistical analysis."
"R and automation services."
"From a scalability standpoint, I would say it's pretty fantastic."
"The most valuable features of TIBCO Spotfire are visualization. It's very nice, clear, and, flexible. You can analyze many data types and the user interface is very good."
"Data discovery is very simple."
"It’s stable and straightforward."
"I would like to see a proper way to avoid killing the sourcing systems."
"Lacks integrations with AWS, GCP and the like."
"Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement."
"It would be good if the solution provided a much-needed cellular platform."
"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."
"I would like it if we could pull the data model or export the data model because Denodo has, based on how you build, something called associations. The data model gets very confusing when you go look at it. It depends on how you define it, but it's really huge. I wish there was a way to export it into Visio. It could be that they already have a way to do it, and I don't know, but it would be much easier for the architects and even for the developers to look at it than scrunching it into the screen and expanding every small portion of it. If there was an easy way to export the Denodo model into another modeling tool and view it, it would be great."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"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."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"They should release new versions for the solution's on-premises setup."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Integration with Artificial Intelligence would benefit this solution."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"I would like to see the visualization library in this solution expanded, so that I can increase what I can offer to our clients."
"The design of the UI could be improved."
"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."
"We encountered difficulties connecting the special data sets, as the post data set did not contain any shared columns, making it difficult to establish a connection between the data sets."
"The initial setup can be difficult."
"The data compression has room for improvement."
"When you do the data loading, it is slow."
"Print capability and trigger-based events."