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

Amazon Redshift vs Azure Data Factory comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
4th
Average Rating
7.8
Number of Reviews
66
Ranking in other categories
No ranking in other categories
Azure Data Factory
Ranking in Cloud Data Warehouse
3rd
Average Rating
8.0
Number of Reviews
85
Ranking in other categories
Data Integration (1st)
 

Mindshare comparison

As of November 2024, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.7%, down from 11.9% compared to the previous year. The mindshare of Azure Data Factory is 12.9%, down from 13.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
Apr 10, 2024
Works as a data warehouse system and collects data from different sources
Amazon Redshift serves as our data warehouse system. We collect data from various sources, including 153 streams. We gather companies' data for rating, deployment, and stock market analysis. We then push this data onto Amazon Redshift, which Power BI, Tableau, and even Google Looker use for…
Camilo Velasco - PeerSpot reviewer
Oct 27, 2022
No deployment cost, quick implementation, pay only for the processing time and data
The primary use case of this solution is to extract ETLS, transform and load data, and organize database synchronization The most valuable feature of this solution is the data flow, which is the same SQL server in important service, integration services, which is a very robust and powerful tool…

Quotes from Members

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

Pros

"The product offers good support for the data lake."
"The processing of data is very fast."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"I am satisfied with the performance of the product."
"You can copy JSON to the column and have it analyzed using simple functions."
"We have found Machine Learning use cases are very nice."
"It allows you write complex queries and perform row by row processes."
"With the APIs that are available, it can be easily integrated with other tools."
"For developers that are very accustomed to the Microsoft development studio, it's very easy for them to complete end-to-end data integration."
"The most valuable aspect is the copy capability."
"In terms of my personal experience, it works fine."
"The most valuable features of the solution are its ease of use and the readily available adapters for connecting with various sources."
"One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect."
"The most valuable feature of this solution would be ease of use."
"Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
 

Cons

"The explain panel in the Redshift database could be better."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"In our experiments, the handling of unstructured data was not very smooth."
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations."
"The high price of the product is an area of concern where improvements are required."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"Amazon Redshift is a little more expensive than other products."
"They require more detailed error reporting, data normalization tools, easier connectivity to other services, more data services, and greater compatibility with other commonly used schemas."
"Azure Data Factory can improve the transformation features. You have to do a lot of transformation activities. This is something that is just not fully covered. Additionally, the integration could improve for other tools, such as Azure Data Catalog."
"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."
"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."
"Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail."
"While it has a range of connectors for various systems, such as ERP systems, the support for these connectors can be lacking."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
"The deployment should be easier."
 

Pricing and Cost Advice

"I have heard complaints about the solution’s pricing, and thus I rate it as a five."
"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"It is an expensive product."
"The cost will depend on how you set up your warehouse and what kind of data you store."
"The cost is comparable to Snowflake."
"BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."
"The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
"The pricing model is based on usage and is not cheap."
"This is a cost-effective solution."
"While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products."
"The pricing is pay-as-you-go or reserve instance. Of the two options, reserve instance is much cheaper."
"Azure Data Factory gives better value for the price than other solutions such as Informatica."
"In terms of licensing costs, we pay somewhere around S14,000 USD per month. There are some additional costs. For example, we would have to subscribe to some additional computing and for elasticity, but they are minimal."
"The price you pay is determined by how much you use it."
"Pricing is comparable, it's somewhere in the middle."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
60%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
4%
Financial Services Firm
13%
Computer Software Company
13%
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.
What is your experience regarding pricing and costs for Amazon Redshift?
You can start small with a basic cluster to learn and practice with it. Selecting the most basic and economical cluster type can save you enough money to move forward with the solution or go with a...
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: October 2024.
814,649 professionals have used our research since 2012.