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."This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"Overall, the product works quite well and has a good set of features."
"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."
"In general, it's good for us to make tests so we can scout the data."
"The most valuable feature is Data Catalogs."
"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)."
"It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo."
"Has a good visual tool for data mapping."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"In the end, you have structured, proper data for use in an integrated BI solution."
"Informatica PowerCenter is a very good ETL tool."
"Deployment was simple and straightforward."
"The ability to scale through partitions helped us to improve the performance."
"It reduces a lot of legacy coding."
"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."
"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."
"Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement."
"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."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"It would be good if the solution provided a much-needed cellular platform."
"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."
"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 licensing is difficult."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"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."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
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.