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."
"This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"The most valuable features are data lineage and the concept of a semantic layer."
"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."
"It allows a lot of traceability and you can decide what data you want to collect"
"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."
"Overall, the product works quite well and has a good set of features."
"In general, it's good for us to make tests so we can scout the data."
"Has a good visual tool for data mapping."
"It is an excellent ETL tool."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"The interface is very clean and clear."
"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."
"We occasionally have some integration issues that we need to work through."
"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."
"The solution should have its own acceleration technology."
"The feature that you have to connect on LDAP needs improvement."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"Performance management could be improved."
"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 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."
"The solution must improve the integration with new services."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"The performance of Informatica PowerCenter could improve."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"I would like to see an improvement in the digital adoption."
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.