We changed our name from IT Central Station: Here's why

Amazon Redshift vs Microsoft Azure Synapse Analytics comparison

Cancel
You must select at least 2 products to compare!
Comparison Summary
Question: How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Answer: 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.
Featured Review
Find out what your peers are saying about Amazon Redshift vs. Microsoft Azure Synapse Analytics and other solutions. Updated: January 2022.
563,148 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes.""The most valuable feature is the scalability, as it grows according to our needs.""Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers.""I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing.""The initial setup is easy.""It is quite simple to use and there are no issues with creating the tables.""Has a very user-friendly SQL editor and it's very easy to use the connectors.""The feature that we find most useful is the ability to do analytics on the fly."

More Amazon Redshift Pros →

"The pricing seems to be quite fair.""They are available on the Cloud, and the platform is very intuitive.""The solution has been working well overall.""I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics.""The most valuable feature is performance gains.""The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs.""We have found that it is easy to develop and to do the analytics in the modules of data.""The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."

More Microsoft Azure Synapse Analytics Pros →

Cons
"In our experiments, the handling of unstructured data was not very smooth.""It would be useful to have an option where all of the data can be queried at once and then have the result shown.""Planting is the primary key enforcement that should be improved.""It takes a lot of time to ingest and update the data.""We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues.""Pricing is one of the things that it could improve. It should be more competitive.""There are too many limitations with respect to concurrency.""The OLAP slide and dice features need to be improved."

More Amazon Redshift Cons →

"More integration is needed to improve the product for the future.""They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed.""Microsoft should develop an interface to make it easier to shift from on-premise to the cloud.""The major challenge that we're seeing with Azure Synapse is around security concerns. The way it is working right now, it has Managed VNet by Microsoft option, similar to the implementation of Azure Databricks, which may pose a concern for financial institutions. For managed environments, the banks have very strict policies around data being onboarded to those environments. For some confidential applications, the banks have the policy to encrypt it with their own key, so it is sort of like Bring Your Own Key, but it is not possible to manage the resources with Microsoft or Databricks, which is probably the major challenge with Azure Synapse. There should be more compatibility with SQL Server. It should be easier to migrate solutions between different environments because right now, it is not really competitive. It is not like you can go and install SQL Database in some other environment. You will have to go through some migration projects, which probably is one of the major showstoppers for any bank. When they consider Synapse, they not only consider the investment in the actual service; they also consider the cost of the migration process. When you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration.""It needs strong support for social media, internet data, and native support for NoSQL.""The initial setup is complex.""I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good.""Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."

More Microsoft Azure Synapse Analytics Cons →

Pricing and Cost Advice
  • "The part that I like best is that you only pay for what you are using."
  • "My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
  • "At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
  • "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."
  • More Amazon Redshift Pricing and Cost Advice →

  • "All of the prices are available online."
  • "Our license is very expensive"
  • "They are cost aggressive, and it integrates well with other Microsoft tools."
  • "There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be."
  • "Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle."
  • "The price of the package not expensive and depends on how much it is used."
  • "The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
  • "This is a cost-effective product."
  • More Microsoft Azure Synapse Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    563,148 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    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… more »
    Top Answer: 
    Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features.
    Top Answer: 
    Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
    Top Answer: 
    Fills the gap between big data and classic data warehouses.
    Top Answer: 
    Synapse is a very costly solution, and other products are available for less.
    Ranking
    4th
    Views
    12,282
    Comparisons
    9,547
    Reviews
    12
    Average Words per Review
    509
    Rating
    7.7
    2nd
    Views
    26,962
    Comparisons
    19,760
    Reviews
    31
    Average Words per Review
    530
    Rating
    8.0
    Comparisons
    Also Known As
    Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
    Learn More
    Overview

    Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.

    Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.

    Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.

    As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.

    Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

    Offer
    Learn more about Amazon Redshift
    Learn more about Microsoft Azure Synapse Analytics
    Sample Customers
    Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
    Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
    Top Industries
    REVIEWERS
    Comms Service Provider29%
    Retailer21%
    Logistics Company14%
    Computer Software Company14%
    VISITORS READING REVIEWS
    Computer Software Company29%
    Comms Service Provider13%
    Media Company11%
    Financial Services Firm8%
    REVIEWERS
    Computer Software Company21%
    Comms Service Provider16%
    Manufacturing Company11%
    Insurance Company11%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider18%
    Financial Services Firm6%
    Energy/Utilities Company6%
    Company Size
    REVIEWERS
    Small Business31%
    Midsize Enterprise36%
    Large Enterprise33%
    REVIEWERS
    Small Business33%
    Midsize Enterprise21%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    Find out what your peers are saying about Amazon Redshift vs. Microsoft Azure Synapse Analytics and other solutions. Updated: January 2022.
    563,148 professionals have used our research since 2012.

    Amazon Redshift is ranked 4th in Cloud Data Warehouse with 13 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 33 reviews. Amazon Redshift is rated 7.6, while Microsoft Azure Synapse Analytics is rated 8.0. The top reviewer of Amazon Redshift writes "Scales according to our needs, which saves a lot in terms of upfront costs". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". Amazon Redshift is most compared with Snowflake, Oracle Exadata, Vertica, Teradata and Oracle Autonomous Data Warehouse, whereas Microsoft Azure Synapse Analytics is most compared with Snowflake, SAP BW4HANA, Apache Hadoop, Oracle Autonomous Data Warehouse and AWS Lake Formation. See our Amazon Redshift vs. Microsoft Azure Synapse Analytics report.

    See our list of best Cloud Data Warehouse vendors and best 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.