We performed a comparison between Amazon Redshift and Azure Data Factory based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The ability to reload data multiple times at different times."
"The initial setup of this solution is straightforward."
"The valuable features are performance, data compression, and scalability."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"We haven't had any issues connecting it to other products."
"The feature I found most helpful in Azure Data Factory is the pipeline feature, including being able to connect to different sources. Azure Data Factory also has built-in security, which is another valuable feature."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"The trigger scheduling options are decently robust."
"An excellent tool for pipeline orchestration."
"When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit."
"The function of the solution is great."
"Running parallel queries results in poor performance and this needs to be improved."
"Amazon Redshift could improve the user interface support."
"It takes a lot of time to ingest and update the data."
"The OLAP slide and dice features need to be improved."
"The customer support could be more responsive."
"The initial deployment was complex."
"Should be made available across zones, like other Multi-AZ solutions."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"Some of the optimization techniques are not scalable."
"The pricing scheme is very complex and difficult to understand."
"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."
"It does not appear to be as rich as other ETL tools. It has very limited capabilities."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."
"The solution needs to be more connectable to its own services."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews. Amazon Redshift is rated 7.8, while Azure Data Factory is rated 8.0. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and Amazon EMR, whereas Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics. See our Amazon Redshift vs. Azure Data Factory report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse 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.