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."Denodo makes it easy to export data as a service or data link to other services."
"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"The ability to transfer data is very valuable."
"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."
"Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"Denodo is very stable."
"Denodo's best features are its performance, easy data transformation, and the job scheduler."
"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 the most is that we have to deal with less while writing the queries."
"The technical support for Informatica PowerCenter is good."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"It has good standard features for ETL development."
"The product's initial setup phase is very easy."
"In the end, you have structured, proper data for use in an integrated BI solution."
"It's very easy to use it to develop mappings and workflows."
"Performance management could be improved."
"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."
"The support is not the best and should be improved."
"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 dropdown menus feel antiquated to me, and the administrative portals need improvement."
"The solution is slow when there are many virtualization layers."
"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 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."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"They should release new versions for the solution's on-premises setup."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"The reputation of Informatica is that it is expensive."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"The documentation could be improved."
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, Mule Anypoint Platform, Delphix 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.