"The most valuable features are data lineage and the concept of a semantic layer."
"It allows a lot of traceability and you can decide what data you want to collect"
"The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."
"The performance and the speed to market are the most valuable features of this solution."
"Access to numerous forums and internet information."
"The most valuable feature is Data Catalogs."
"Overall, the product works quite well and has a good set of features."
"Denodo makes it easy to export data as a service or data link to other services."
"I like the automated scheduling feature."
"Once you have learned Informatica, it is very easy to use."
"It's a complete package, which is why we use this solution."
"The technical support is excellent."
"Good interface, reasonable documentation."
"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."
"Can manage a huge quantity of data and provide reliability."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"The support is not the best and should be improved."
"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 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."
"We occasionally have some integration issues that we need to work through."
"Lacks integrations with AWS, GCP and the like."
"Documentation needs to be improved"
"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."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"I would like to see it be able to import data from NoSQL."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"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."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
Denodo is ranked 12th in Data Integration Tools with 8 reviews while Informatica PowerCenter is ranked 1st in Data Integration Tools with 22 reviews. Denodo is rated 7.6, while Informatica PowerCenter is rated 8.6. The top reviewer of Denodo writes "Good performance and integration, but needs more training documentation". On the other hand, the top reviewer of Informatica PowerCenter writes "A stable, scalable, and mature solution for complex transformations and data integration". Denodo is most compared with Azure Data Factory, Delphix, Informatica Enterprise Data Catalog, Mule Anypoint Platform and AWS Glue, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, SSIS, Azure Data Factory, Informatica PowerExchange and Oracle Data Integrator (ODI). See our Denodo vs. Informatica PowerCenter report.
See our list of best Data Integration Tools vendors.
We monitor all Data Integration Tools 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.
