Try our new research platform with insights from 80,000+ expert users

Amazon Redshift vs Azure Data Factory comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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.2
Amazon Redshift offers mixed returns; beneficial for high data volumes, but concerns arise over rising costs and limited data effectiveness.
Sentiment score
7.1
Azure Data Factory offers significant time, effort, and infrastructure savings, enhancing data analysis and decision-making capabilities.
 

Customer Service

Sentiment score
6.8
Amazon Redshift's support is responsive but costly, with quick responses for routine issues, though advanced support can be inconsistent.
Sentiment score
6.5
Azure Data Factory support is praised for responsiveness, though some report delays; satisfaction varies with Microsoft partnerships.
It's costly when you enable support.
The technical support from Microsoft is rated an eight out of ten.
The technical support is responsive and helpful
The technical support for Azure Data Factory is generally acceptable.
 

Scalability Issues

Sentiment score
7.3
Amazon Redshift is generally praised for scalability, though experience varies with larger clusters and specific configurations.
Sentiment score
7.5
Azure Data Factory scales efficiently, managing large datasets for enterprises, though users note cost and integration limitations.
The scalability part needs improvement as the sizing requires trial and error.
Azure Data Factory is highly scalable.
 

Stability Issues

Sentiment score
7.4
Amazon Redshift is praised for stability, high availability, and performance, despite occasional challenges with complex queries and environment changes.
Sentiment score
7.8
Azure Data Factory is highly rated for stability, scalability, and performance, despite occasional minor issues with larger data volumes.
Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.
The solution has a high level of stability, roughly a nine out of ten.
 

Room For Improvement

Amazon Redshift faces challenges in performance, integration, cost, and compatibility, needing improvements in speed, security, and serverless options.
Azure Data Factory requires improvements in integration, pricing, documentation, UI, monitoring, processing, and debugging for enhanced user experience.
They should bring the entire ETL data management process into Amazon Redshift.
There is a problem with the integration with third-party solutions, particularly with SAP.
Incorporating more dedicated API sources to specific services like HubSpot CRM or Salesforce would be beneficial.
Sometimes, the compute fails to process data if there is a heavy load suddenly, and it doesn't scale up automatically.
 

Setup Cost

Amazon Redshift offers competitive pricing for large enterprises, but smaller organizations might find it more costly than alternatives.
Azure Data Factory offers competitive, flexible pay-as-you-go pricing; costs vary by data volume and use of additional services.
The cost of technical support is high.
It's a pretty good price and reasonable for the product quality.
The pricing of Amazon Redshift is expensive.
The pricing is cost-effective.
It is considered cost-effective.
 

Valuable Features

Amazon Redshift provides scalable, efficient data processing with AWS integration, offering robust analytics, security, and user-friendly features.
Azure Data Factory enables easy data integration, management, and transformation with over 100 connectors, supporting ETL and automation efficiently.
Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.
Scalability is also a strong point; I can scale it however I want without any limitations.
Security configurations are implemented across all processes, such as AWS Config and GuardDuty.
It connects to different sources out-of-the-box, making integration much easier.
The interface of Azure Data Factory is very usable with a more interactive visual experience, making it easier for people who are not as experienced in coding to work with.
I find the most valuable feature in Azure Data Factory to be its ability to handle large datasets.
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
5th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
70
Ranking in other categories
No ranking in other categories
Azure Data Factory
Ranking in Cloud Data Warehouse
3rd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
90
Ranking in other categories
Data Integration (1st)
 

Mindshare comparison

As of April 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.2%, down from 9.2% compared to the previous year. The mindshare of Azure Data Factory is 8.4%, down from 10.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
Works as a data warehouse system and collects data from different sources
In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic. We often encounter issues like someone dropping a column or changing the order of columns, which can cause synchronization problems when pushing data through our pipeline. It's a minor issue, but it can be annoying.
Joy Maitra - PeerSpot reviewer
Facilitates seamless data pipeline creation with good analytics and and thorough monitoring
Azure Data Factory is a low code, no code platform, which is helpful. It provides many prebuilt functionalities that assist in building data pipelines. Also, it facilitates easy transformation with all required functionalities for analytics. Furthermore, it connects to different sources out-of-the-box, making integration much easier. The monitoring is very thorough, though a more readable version would be appreciable.
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
845,040 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
66%
Financial Services Firm
6%
Computer Software Company
5%
Manufacturing Company
3%
Financial Services Firm
14%
Computer Software Company
12%
Manufacturing Company
9%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
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 stability and reliability I am looking for, good scalability, and is easy to set up an...
How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa
Find out what your peers are saying about Amazon Redshift vs. Azure Data Factory and other solutions. Updated: March 2025.
845,040 professionals have used our research since 2012.