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."Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"The most valuable feature is the scalability, as it grows according to our needs."
"It allows for the storage of huge amounts of data."
"The valuable features are performance, data compression, and scalability."
"The processing of data is very fast."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"It allows you write complex queries and perform row by row processes."
"Powerful but easy-to-use and intuitive."
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"I can do everything I want with SSIS and Azure Data Factory."
"The solution is okay."
"The most valuable feature is the copy activity."
"Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."
"Data Factory's most valuable feature is Copy Activity."
"The solution is unable to work fast."
"Planting is the primary key enforcement that should be improved."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"The product could be improved by making it more flexible."
"Improvement could be made in the area of streaming data."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"The initial deployment was complex."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"There are limitations when processing more than one GD file."
"I rate Azure Data Factory six out of 10 for stability. ADF is stable now, but we had problems recently with indexing on an SQL database. It's slow when dealing with a huge volume of data. It depends on whether the database is configured as general purpose or hyperscale."
"Data Factory's cost is too high."
"The performance could be better. It would be better if Azure Data Factory could handle a higher load. I have heard that it can get overloaded, and it can't handle it."
"The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others."
"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."
"Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful."
"This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 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 Teradata, Snowflake, AWS Lake Formation, Vertica and Amazon EMR, whereas Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage. 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.