No more typing reviews! Try our Samantha, our new voice AI agent.

Denodo vs Fivetran vs Informatica PowerCenter comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.5
Denodo boosts ROI by enabling rapid reporting, improving decision-making, and streamlining data integration for enhanced efficiency and customer satisfaction.
Sentiment score
6.6
Fivetran offers significant time and cost-saving benefits, simplifying data integration and maintenance while reducing reliance on data engineers.
Sentiment score
8.3
Informatica PowerCenter is cost-effective, enhances decision-making, supports crucial operations, reduces costs, and manages complex data efficiently.
It provides a positive return on investment for those who can connect multiple data sources and make data-driven decisions easily.
Information Technology Manager at Lockheed Martin
If you don't need to write a whole ETL to make the data virtualization, you need way fewer people to write a query instead of writing an ETL pipeline.
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
I have seen a return on investment, which showed up in improved customer satisfaction scores.
Vice President at a financial services firm with 10,001+ employees
Fivetran provides time savings, cost reductions, and improvements in data quality.
Team Lead Data Engineer at Data Pilot
It saves us the effort of having one to two data engineers managing the tasks that Fivetran handles.
Lead Data Engineer at Sensilab
It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.
Associate Principal Engineer at Nagarro
The investment we have made is tremendous; it has saved a lot of time and effort, and fewer people are needed.
Operations Engineer at a computer software company with 501-1,000 employees
 

Customer Service

Sentiment score
6.9
Denodo support is responsive and helpful, but some users face delays in bug resolution and unfriendliness in the portal.
Sentiment score
6.0
Fivetran customer support is efficient yet sometimes slow, rated 7-9, with calls for improved critical issue communication.
Sentiment score
6.9
Informatica PowerCenter's technical support is generally praised for responsiveness and expertise, though some users note occasional delays.
They have a good methodology for learning how to use the tool.
Data Architecture and Engineering Specialist at coprocenva
Denodo's customer support team is very competent and responsive.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
Principal Architect at a manufacturing company with 10,001+ employees
If they could provide support more quickly, that would be great.
Manager at InfoCepts
The technical support provided by Fivetran has generally been good, with a response time and competence that I would rate as good.
Lead Data Engineer at Sensilab
Customer support from Fivetran is quite good; it's really nice and responsive.
Team Lead Data Engineer at Data Pilot
I like the technical support provided by Informatica.
Professor of Economics of Informatic at CMAYOR
I have occasionally needed to communicate with the technical support of Informatica PowerCenter, especially when raising cases for complex mappings and performance optimization to identify bottlenecks in transformations.
Associate Principal Engineer at Nagarro
 

Scalability Issues

Sentiment score
7.1
Denodo effectively scales across organizations, managing many users and data sources, but performance may vary with automation and configuration.
Sentiment score
7.1
Fivetran scales well for various businesses, accommodating data needs but can be costly and complex for smaller enterprises.
Sentiment score
6.8
Informatica PowerCenter offers scalable performance for large data volumes, though licensing costs and price may be a concern.
For huge data requests, it cannot scale automatically; admin action is required.
Principal Architect at a manufacturing company with 10,001+ employees
Denodo's scalability comes into play specifically when there is data transfer.
Vice President at a financial services firm with 10,001+ employees
My client has almost 100 million records, and the performance was impacted in a way that required optimization.
Data Consultant at IT-Bots
Fivetran's scalability has been tested effectively, and it has been working well for our organization's growing data needs.
Team Lead Data Engineer at Data Pilot
In the cloud, scaling up and down becomes easy when working with cloud providers.
Associate Principal Engineer at Nagarro
The scalability of Informatica PowerCenter is tremendous because we can install it on any of our employees' systems, and it handles each and every task very swiftly.
Operations Engineer at a computer software company with 501-1,000 employees
For scalability, I would rate Informatica PowerCenter between eight to nine.
Director at a computer software company with 1,001-5,000 employees
 

Stability Issues

Sentiment score
7.0
Denodo is stable and reliable in production, with minor issues, praised for robustness but needs technical expertise for optimization.
Sentiment score
8.0
Users generally express high satisfaction with Fivetran's stable reliability, despite occasional issues with API connections and custom setups.
Sentiment score
7.9
Informatica PowerCenter is praised for stability, effectiveness, and reliability, with minor issues easily resolved; highly valued by users.
I would rate it nine out of ten because it is very reliable, always performing as expected.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
Technology Leader at eTCaaS
Denodo is stable and good.
Data Engineer at a consultancy with 11-50 employees
They have 99.9% accuracy on the data load and they maintain transparency.
Manager at InfoCepts
In my experience, Fivetran is stable with very few instances of downtime or reliability issues.
Team Lead Data Engineer at Data Pilot
During the duration of the time that we used Fivetran, it was highly stable.
Founder at a marketing services firm with 1-10 employees
We are getting 100% uptime every day.
Operations Engineer at a computer software company with 501-1,000 employees
Informatica PowerCenter is stable and can scale well.
Professor of Economics of Informatic at CMAYOR
The product is very stable with very few issues encountered in production.
Associate Principal Engineer at Nagarro
 

Room For Improvement

Denodo should expand markets, improve UI and integration, address performance issues, and enhance support and documentation.
Fivetran needs improvements in connectors, real-time processing, user interface, pricing, support, documentation, and integration capabilities.
Informatica PowerCenter is costly, complex, and outdated, needing better performance, integration, and user support for modern needs.
Ensuring data caching is up to date is critical.
Director Software Engineer at a computer software company with 10,001+ employees
Denodo needs better communication on how the product can be deployed for specific solutions.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
The system has dependencies on other environments, like JVM, which can affect its performance.
Technology Leader at eTCaaS
From a cost perspective, if the number of connectors is lesser, then Fivetran is not the most cost-efficient option.
Founder at a marketing services firm with 1-10 employees
I want more flexibility during ingestion, specifically for transformations needed beforehand.
Team Lead Data Engineer at Data Pilot
Fivetran could improve by adapting more for technical users and by providing more options for such users.
Lead Data Engineer at Sensilab
With Informatica PowerCenter, I am looking for an AI interface that looks at the underlying data model of the databases and the metadata of the tables, allowing the developer to provide instructions on what data sources to connect to and how to apply or create Transformations.
Director at a computer software company with 1,001-5,000 employees
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
Professor of Economics of Informatic at CMAYOR
Informatica Cloud and its support becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing.
Associate Principal Engineer at Nagarro
 

Setup Cost

Denodo pricing is high, suitable for larger enterprises, with variable costs and value-enhancing features, seen as fair by many.
Fivetran's pricing is high, favoring larger enterprises with discounts available; smaller companies may find it prohibitive.
Informatica PowerCenter is costly compared to alternatives, justified for large enterprises due to robust features and flexible licensing.
For small companies, it's not a solution that most small companies can afford.
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
Technology Leader at eTCaaS
Our current yearly contract for Fivetran is approximately $70,000.
Lead Data Engineer at Sensilab
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
Professor of Economics of Informatic at CMAYOR
The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.
Director at a computer software company with 1,001-5,000 employees
We haven't paid for it; our client had paid for this tool.
Operations Engineer at a computer software company with 501-1,000 employees
 

Valuable Features

Denodo excels in data integration, virtualization, governance, and scalability, enhancing user experience with API and query optimizations.
Fivetran is valued for seamless data replication, user-friendly interface, scalability, and minimal coding, enabling efficient data handling.
Informatica PowerCenter excels in data integration with a user-friendly interface, robust ETL features, and strong technical support.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
Director Software Engineer at a computer software company with 10,001+ employees
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
Denodo supports SQL base, so if you want to join two tables or two views, you can use SQL, which is an advantage as most developers or business people know SQL.
Principal Architect at a manufacturing company with 10,001+ employees
The most valuable feature of Fivetran is its built-in connectors for a wide range of data sources.
Lead Data Engineer at Sensilab
The real-time data replication is what I see best in the market where it reduces the overhead of customers needing to maintain the pipeline.
Manager at InfoCepts
The ability to seamlessly integrate with a large variety of data sources is valuable.
Founder at a marketing services firm with 1-10 employees
The system supports real-time integration, which is essential for many of my tasks.
Professor of Economics of Informatic at CMAYOR
Informatica monitors can be used to monitor the jobs that we run, and if there is any kind of failure, we can diagnose it right away.
Operations Engineer at a computer software company with 501-1,000 employees
The functions in Informatica PowerCenter that I have found most valuable are the way it manages the volume of data, the push down optimization, and the performance aspects of it, mostly related to parallelism techniques.
Director at a computer software company with 1,001-5,000 employees
 

Mindshare comparison

As of April 2026, in the Data Integration category, the mindshare of Denodo is 1.3%, down from 1.7% compared to the previous year. The mindshare of Fivetran is 1.9%, down from 2.1% compared to the previous year. The mindshare of Informatica PowerCenter is 3.2%, down from 9.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica PowerCenter3.2%
Denodo1.3%
Fivetran1.9%
Other93.6%
Data Integration
 

Featured Reviews

Patel-Dhulva - PeerSpot reviewer
Information Technology Manager at Lockheed Martin
Data virtualization has unified siloed sources and now supports real-time decisions
The best features Denodo offers stand out to me as the ability to develop REST web services fast and easily, create and combine new views, integrate different sources of data, and connect with other tools seamlessly. When I mention fast and easy creation of views and integration, I love the agile data provisioning and integration, where Denodo provides a comprehensive set of capabilities for implementing logical data integration, management, and delivery, which in turn enables agile data analytics and an informed decision-making process to be smooth. I also appreciate the performance optimization with AI, which improves performance optimization through the integration of artificial intelligence capabilities. Furthermore, I appreciate the unified security and governance, where it addresses the need for an organization to effectively manage security, data privacy, and data protection easily, offering a centralized platform that allows the application of governance policies and fine-grained security controls. Another feature I would add about Denodo is that it also provides a single point of control where we can establish security controls over the entire infrastructure and gain visibility into all our data assets. Denodo has positively impacted my organization as since we started using this tool, it has been very helpful because it is a huge advantage that we can connect to many different databases to provide data rapidly and accurately and also gain insights, which helps us to make data-driven decisions easily. It has proven to be a valuable environment for deploying data virtualization solutions, and its user community is active in finding and fixing issues more accurately. Through data insights from Denodo, we have been able to improve our decision making, which helps to better communication between the stakeholders thanks to the real-time experience. It also saves a lot of time.
Hafiz Usman - PeerSpot reviewer
Team Lead Data Engineer at Data Pilot
Has accelerated data integration workflows and supports seamless development of custom connectors
I've worked extensively with Fivetran, mainly used for extraction purposes, and I've worked with the transformation element in it as well. Fivetran not only has built-in connectors but also provides SDK connectors, allowing us to develop our own connectors in an easy manner. I don't have to write raw Python scripts or dumping scripts; it offers straightforward examples and guidelines, making it much simpler to develop custom connectors inside Fivetran. We've been able to develop many custom connectors as well, which is unique and beneficial for having everything centralized instead of having those connectors located elsewhere. One of the best features by Fivetran is its clean, simple, and intuitive UI. It includes a transformation section where I can deploy my DBT queries and scripts. It also supplies good tracking capabilities for billing estimates and user permissions, allowing for customization to the desired level. The number of connectors it has remains a standout feature, and within connectors, the options available are very helpful. Although it sometimes appears static due to its built-in nature, it offers good flexibility for data transformation and caching, which I appreciate because it saves us extensive script-writing time.
Garima Goel - PeerSpot reviewer
Associate Principal Engineer at Nagarro
Has supported complex data pipeline creation but performance tuning and monitoring responsiveness need improvement
Sometimes, I see various performance issues with Informatica PowerCenter, including caching concerns, whether it's a joiner transformation or other transformations, so I believe the team can enhance the performance perspectives of these transformations. Additionally, sometimes the Informatica Monitor hangs or takes time to open the current run or logs, which the team can also look into. Informatica is transitioning to cloud solutions and discontinuing on-premise support after 2026, so when we discuss Informatica Cloud and its support, it becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing. Informatica Cloud Intelligence's pricing is notably high.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
885,444 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
12%
Government
7%
Energy/Utilities Company
7%
Computer Software Company
11%
Financial Services Firm
10%
Manufacturing Company
9%
Healthcare Company
6%
Financial Services Firm
17%
Computer Software Company
8%
Manufacturing Company
7%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise6
Large Enterprise21
By reviewers
Company SizeCount
Small Business10
Midsize Enterprise7
Large Enterprise16
By reviewers
Company SizeCount
Small Business15
Midsize Enterprise11
Large Enterprise74
 

Questions from the Community

Does Denodo provide useful data virtualization education? Is it useful to attend their training?
If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit fro...
In experience, what might Denodo be lacking or need improvement on?
I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I ...
Which industries can benefit from Denodo the most?
Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data...
What's the deal with the HVR software acquisition?
As a user of HVR Software I followed this deal closely. Fivetran is apparently trying to establish more in its sector...
Does HVR Software provide reliable insights?
I honestly can't think of another data replication software that can give you better statistics and insight than HVR...
How much traffic can HVR Software handle?
As someone who works at a company where a high volume of information is replicated and has tried several data replica...
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stabil...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called ...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a...
 

Also Known As

Denodo for AWS
No data available
PowerCenter
 

Overview

 

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
Autodesk, Condé Nast, JetBlue, Morgan Stanley, OpenAI, LVMH, Pfizer, Verizon, SpotifyNational Australia Bank, Saks, Cemex, Okta, Dropbox, Pitney Bowes, World Fuel Services,Lufthansa, AutoZone, ASICS, ASOS, Coupa, Databricks, Hermes, New Relic, Intercom,Canva, Honeywell, Square, DocuSign, Nandos, Oldcastle Infrastructure
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Find out what your peers are saying about Microsoft, Informatica, Qlik and others in Data Integration. Updated: March 2026.
885,444 professionals have used our research since 2012.