


Find out what your peers are saying about Microsoft, Informatica, Qlik and others in Data Integration.
It provides a positive return on investment for those who can connect multiple data sources and make data-driven decisions easily.
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.
I have seen a return on investment, which showed up in improved customer satisfaction scores.
Fivetran provides time savings, cost reductions, and improvements in data quality.
It saves us the effort of having one to two data engineers managing the tasks that Fivetran handles.
It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.
The investment we have made is tremendous; it has saved a lot of time and effort, and fewer people are needed.
They have a good methodology for learning how to use the tool.
Denodo's customer support team is very competent and responsive.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
If they could provide support more quickly, that would be great.
The technical support provided by Fivetran has generally been good, with a response time and competence that I would rate as good.
Customer support from Fivetran is quite good; it's really nice and responsive.
I like the technical support provided by Informatica.
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.
For huge data requests, it cannot scale automatically; admin action is required.
Denodo's scalability comes into play specifically when there is data transfer.
My client has almost 100 million records, and the performance was impacted in a way that required optimization.
Fivetran's scalability has been tested effectively, and it has been working well for our organization's growing data needs.
In the cloud, scaling up and down becomes easy when working with cloud providers.
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.
For scalability, I would rate Informatica PowerCenter between eight to nine.
I would rate it nine out of ten because it is very reliable, always performing as expected.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
Denodo is stable and good.
They have 99.9% accuracy on the data load and they maintain transparency.
In my experience, Fivetran is stable with very few instances of downtime or reliability issues.
During the duration of the time that we used Fivetran, it was highly stable.
We are getting 100% uptime every day.
Informatica PowerCenter is stable and can scale well.
The product is very stable with very few issues encountered in production.
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
The system has dependencies on other environments, like JVM, which can affect its performance.
From a cost perspective, if the number of connectors is lesser, then Fivetran is not the most cost-efficient option.
I want more flexibility during ingestion, specifically for transformations needed beforehand.
Fivetran could improve by adapting more for technical users and by providing more options for such users.
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.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
Informatica Cloud and its support becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing.
For small companies, it's not a solution that most small companies can afford.
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
Our current yearly contract for Fivetran is approximately $70,000.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.
We haven't paid for it; our client had paid for this tool.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
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.
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.
The most valuable feature of Fivetran is its built-in connectors for a wide range of data sources.
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.
The ability to seamlessly integrate with a large variety of data sources is valuable.
The system supports real-time integration, which is essential for many of my tasks.
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.
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.
| Product | Mindshare (%) |
|---|---|
| Informatica PowerCenter | 3.2% |
| Denodo | 1.3% |
| Fivetran | 1.9% |
| Other | 93.6% |



| Company Size | Count |
|---|---|
| Small Business | 16 |
| Midsize Enterprise | 6 |
| Large Enterprise | 21 |
| Company Size | Count |
|---|---|
| Small Business | 10 |
| Midsize Enterprise | 7 |
| Large Enterprise | 16 |
| Company Size | Count |
|---|---|
| Small Business | 15 |
| Midsize Enterprise | 11 |
| Large Enterprise | 74 |
Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.
The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.
Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.
Denodo Features
At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:
Denodo Benefits
Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:
Reviews from Real Users
Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.
Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.
Fivetran, the global leader in data movement, is trusted by companies like OpenAI, LVMH, Pfizer, Verizon and Spotify to centralize data from SaaS applications, databases, files, and other sources into cloud destinations, including data lakes. With high-performance pipelines, seamless interoperability, and enterprise-grade security, Fivetran empowers organizations to modernize their data infrastructure, power analytics and AI, ensure compliance, and achieve transformative business outcomes. Learn more at Fivetran.com
Informatica PowerCenter is a data integration and data visualization tool. The solution works as an enterprise data integration platform that helps organizations access, transform, and integrate data from various systems. The product is designed to support companies in the full cycle of a project, from its initial rollout to critical deployments. Informatica PowerCenter allows developers and analysts to collaborate while accelerating the work process to deploy projects within days instead of months.
The Advanced edition of the product provides an additional real-time engine which allows companies to have always-on enterprise data integration. This ensures seamless collaboration and increment of data lineage visibility and impacts analysis.
The Premium edition of the solution offers an early warning system that detects unexpected behaviors or incorrect utilization of resources in the workflows and alerts companies in the case that these occur. This version of the product also offers automatic data validation, which ensures data accuracy and reduces testing time and expenditure of resources for by up to 90%.
Informatica PowerCenter Features
The product provides users with various features which allow them to execute data integration initiatives such as analytics, data warehousing, data governance, consolidation, and application migration. The features of the solution include:
Informatica PowerCenter Benefits
The benefits of using Informatica PowerCenter include:
Reviews from Real Users
Yahya T., a developer and architect at L'Oreal, says the product is stable, provides good support, and integrating it with other systems is very fast.
Mohamed E., a senior manager for Data management and data governance at a tech company, says PowerCenter is stable, mature, and offers flexibility in building the pipeline and has a drag-and-drop mode because it's GUI-based; technical support is brilliant.