Skip to main content
TrustRadius
Azure Synapse Analytics

Azure Synapse Analytics
Formerly Azure SQL Data Warehouse

Overview

What is Azure Synapse Analytics?

Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless…

Read more
Recent Reviews

Modern Database

8 out of 10
August 25, 2021
Incentivized
We use Azure Synapse Analytics (Azure SQL Data Warehouse) to hold all our daily sales data to serve reports. Without any storage …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing

Tier 1

$4,700

Cloud
per month 5,000 Synapse Commit Units (SCUs)

Tier 2

$9,200

Cloud
per month 10,000 Synapse Commit Units (SCUs)

Tier 3

$21,360

Cloud
per month 24,000 Synapse Commit Units (SCUs)

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://azure.microsoft.com/en…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $4,700 per month 5000 Synapse Commit Units (SCUs)
Return to navigation

Product Details

What is Azure Synapse Analytics?

Azure Synapse Analytics Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

Azure Synapse Analytics starts at $4700.

The most common users of Azure Synapse Analytics are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(51)

Attribute Ratings

Reviews

(1-6 of 6)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Incentivized
They're all part of the Microsoft Azure family, so they are not exactly competitors. They overlap in functionality, but they're targeted at different levels of customers.
Azure Data Factory is an excellent stand-alone PaaS (included in Synapse Analytics) for writing, scheduling, and monitoring pipelines.
Azure SQL Database (and all the Azure SQL family) is excellent for traditional, SQL-based data warehouses, especially if you're migrating from on-premises. Combined with Azure Data Factory (that can run SSIS packages), it's a perfect solution for a simple path to the cloud.
Azure Databricks is effectively the only internal "competitor" to Synapse Analytics but targeted more to a "platform-agnostic" audience. On the other hand, Synapse is more of a proprietary mix of products that are more tightly related to Microsoft technologies.
Scott Kennedy | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Azure Synapse Analytics stacks up well against the competitors I mentioned above. Technically, Azure SQL Datawarehouse is an upgraded version of the Azure SQL Database. So, the choice to move from one to the other depends on the processing needs of your company. If you need more power, go with the data warehouse.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
When client is already having or using Azure then it’s wise to go with Synapse rather than using Snowflake. We got a lot of help from Microsoft consultants and Microsoft partners while implementing our EDW via Synapse and support is easily available via Microsoft resources and blogs. I don’t see that with Snowflake
Score 10 out of 10
Vetted Review
Verified User
Incentivized
In comparing Azure Synapse to the Google BigQuery - the biggest highlight that I'd like to bring forward is Azure Synapse SQL leverages a scale-out architecture in order to distribute computational processing of data across multiple nodes whereas Google BigQuery only takes into account computation and storage.
Samir Patel, PMP | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We also looked at Oracle Data Warehouse as part of our short list of products to implement as a solution. Oracle's product turned out to have less support by way of easily accessible internet blogs. Oracle was also considerably more expensive and we would have needed to hire the skillset needed to implement.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data.
Return to navigation