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."Redshift Spectrum is the most valuable feature."
"Easy to build out our snowflake design and load data."
"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."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"The stability of Amazon Redshift is good."
"The solution is scalable. It handles different loads very well."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The most valuable features of the solution are its ease of use and the readily available adapters for connecting with various sources."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"It is a complete ETL Solution."
"The flexibility that Azure Data Factory offers is great."
"Azure Data Factory became more user-friendly when data-flows were introduced."
"When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit."
"The solution can scale very easily."
"The most valuable features are data transformations."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"Amazon Redshift could improve the user interface support."
"Sometimes, it's difficult to get the metadata from Redshift."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"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."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"The explain panel in the Redshift database could be better."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"It can improve from the perspective of active logging. It can provide active logging information."
"There aren't many third-party extensions or plugins available in the solution."
"My only problem is the seamless connectivity with various other databases, for example, SAP."
"There's no Oracle connector if you want to do transformation using data flow activity, so Azure Data Factory needs more connectors for data flow transformation."
"Data Factory's cost is too high."
"Some of the optimization techniques are not scalable."
"Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."
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, Vertica, Snowflake, Microsoft Azure Synapse Analytics 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.