We changed our name from IT Central Station: Here's why

Denodo vs Informatica PowerCenter comparison

Cancel
You must select at least 2 products to compare!
Denodo Logo
9,344 views|6,803 comparisons
Informatica PowerCenter Logo
34,380 views|29,030 comparisons
Featured Review
Find out what your peers are saying about Denodo vs. Informatica PowerCenter and other solutions. Updated: January 2022.
564,643 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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."

More Denodo Pros →

"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."

More Informatica PowerCenter Pros →

Cons
"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."

More Denodo Cons →

"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."

More Informatica PowerCenter Cons →

Pricing and Cost Advice
  • "I don't know the actual cost, but it's tens of thousands of dollars per month."
  • "The licensing should be improved, as the cost per connector is quite expensive."
  • More Denodo Pricing and Cost Advice →

  • "Its maintenance is expensive."
  • "It's much more expensive, almost three times more expensive than most other solutions."
  • "We are satisfied with the pricing."
  • "I consider this to be an expensive product."
  • "It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
  • "The price of this solution is high."
  • "Our client has purchased the license, and we are using it."
  • "The solution is in the middle price range compared to other solutions."
  • More Informatica PowerCenter Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    564,643 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    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… more »
    Top Answer: 
    The licensing should be improved, as the cost per connector is quite expensive.
    Top Answer: 
    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… more »
    Top Answer: 
    Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up and… more »
    Top Answer: 
    SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free… more »
    Top Answer: 
    Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge… more »
    Ranking
    12th
    Views
    9,344
    Comparisons
    6,803
    Reviews
    7
    Average Words per Review
    446
    Rating
    7.7
    1st
    Views
    34,380
    Comparisons
    29,030
    Reviews
    19
    Average Words per Review
    390
    Rating
    8.4
    Comparisons
    Also Known As
    PowerCenter
    Learn More
    Overview

    Denodo operates in the data virtualization field– providing high performance, unified access to the broadest range of enterprise, big data, cloud and unstructured sources, and the most agile data services provisioning and governance – at less than half the cost of traditional data integration. Denodo’s customers have gained significant business agility and ROI by creating a unified virtual data layer that serves strategic enterprise-wide information needs for agile BI, big data analytics, web and cloud integration, single-view applications, and SOA data services across every major industry

    Denodo Platform offers the broadest access to structured and unstructured data residing in enterprise, big data, and cloud sources, in both batch and real-time, exceeding the performance needs of data-intensive organizations for both analytical and operational use cases, delivered in a much shorter timeframe than traditional data integration tools.

    The Denodo Platform drives agility, faster time to market, increased customer engagement from single view of customer and operational efficiencies from real-time business intelligence and self-serviceability.
    Founded in 1999, Denodo is privately held, with main offices in Palo Alto (CA), Madrid (Spain), Munich (Germany) and London (UK).

    Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.

    Offer
    Learn more about Denodo
    Learn more about Informatica PowerCenter
    Sample Customers
    Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
    University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company25%
    Comms Service Provider13%
    Financial Services Firm11%
    Manufacturing Company7%
    REVIEWERS
    Computer Software Company26%
    Financial Services Firm18%
    Retailer9%
    Healthcare Company6%
    VISITORS READING REVIEWS
    Computer Software Company30%
    Comms Service Provider13%
    Financial Services Firm8%
    Energy/Utilities Company7%
    Company Size
    REVIEWERS
    Small Business64%
    Midsize Enterprise18%
    Large Enterprise18%
    REVIEWERS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise74%
    VISITORS READING REVIEWS
    Small Business31%
    Midsize Enterprise14%
    Large Enterprise55%
    Find out what your peers are saying about Denodo vs. Informatica PowerCenter and other solutions. Updated: January 2022.
    564,643 professionals have used our research since 2012.

    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.