We performed a comparison between Denodo and Informatica PowerCenter based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is easy to virtualize data using the solution."
"It is a very stable solution."
"This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"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."
"Denodo is very stable."
"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 performance and the speed to market are the most valuable features of this solution."
"It allows a lot of traceability and you can decide what data you want to collect"
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"Has a good visual tool for data mapping."
"In the end, you have structured, proper data for use in an integrated BI solution."
"The most valuable features are the monitoring tools and the reporting manager."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"The technical support for Informatica PowerCenter is good."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Lacks integrations with AWS, GCP and the like."
"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."
"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."
"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."
"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."
"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."
"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."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"There is some room for improvement in terms of pricing."
"Integration with Artificial Intelligence would benefit this solution."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"The solution must improve the integration with new services."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
Denodo is ranked 12th in Data Integration with 29 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. Denodo is rated 7.8, while Informatica PowerCenter is rated 8.0. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, the top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Palantir Foundry, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue. See our Denodo vs. Informatica PowerCenter report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.