2021-10-20T07:21:00Z

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?

NC
  • 1
  • 131
PeerSpot user
1

1 Answer

2021-11-01T19:24:07Z
Nov 1, 2021

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 databases. It scales very easily and has a good cost-benefit ratio. It is very powerful and performs well. The data processing is very fast and can do analytics on the fly.


Amazon Redshift should have more cloud-native tools that integrate with it as Microsoft does with the Azure ecosystem. There is some missing functionality that can make Redshift difficult to work in. If you are analyzing a lot of data, the load performance-wise can be very low.


Microsoft Azure Synapse Analytics can handle large amounts of data - in the petabyte range. You can scale up and down as much as you want. It has a pay-as-you-go protocol, so you only pay for what you use. The speed is very good and the architecture is excellent. You are in control of what you need, which is a huge advantage.


Microsoft Azure Synapse Analytics can be a very complicated product to use. The setup can be very complex. We had some issues with dashboard reporting - we found there were bugs in the platform when dealing with specific types of queries. This solution did not meet the necessary security protocols for some of our clients.


Conclusion


Both of these solutions are very stable, scalable, and flexible. Each of these products has their own unique ecosystems that are very competitive with each other, making them both great solutions to use. Although they are very similar, there are some features and functionalities that make them unique and attractive depending on the type of enterprise you operate. We are a smaller enterprise and overall our team felt based on ease of use, support, and where we are headed, we have started to migrate everything over to an AWS ecosystem and chose Amazon Redshift. It is the solution our clients liked best as well.

Find out what your peers are saying about Amazon Redshift vs. Microsoft Azure Synapse Analytics and other solutions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Product comparison that may be of interest to you
Amazon Redshift vs. Microsoft Azure Synapse Analytics comparison
We performed a comparison between Amazon Redshift and Microsoft Azure Synapse Analytics based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below. Ease of Deployment: Amazon Redshift reviewers agree that its installation is a straightforward process. Some Microsoft Azure Synapse Analytics users say that its initial setup is straightforward, while others say it is complex. Features: Users of both products are happy with their...
Download Amazon Redshift vs. Microsoft Azure Synapse Analytics comparison ReportRead more

Related Q&As