Microsoft Azure Synapse Analytics Reviews

Name: Microsoft Azure Synapse Analytics
Brand: Microsoft
Rating: 4 (45 reviews)

Vendor: Microsoft

3.9 out of 5

45 reviews

1,528 followers

Post review

What is Microsoft Azure Synapse Analytics?UNIXBusinessApplication
Price:

Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data.

Get the Microsoft Azure Synapse Analytics Buyer's Guide and find out what your peers are saying about Microsoft Azure Synapse Analytics, Azure Data Factory, Amazon Redshift and more!

Buyer's Guide

Microsoft Azure Synapse Analytics

September 2023

Get the report

Helped 735,226 peers since 2012

Featured reviews

Mukund Mishra

Sr. Technology Architect at Infosys

Aug 19, 2022

An area for improvement in Microsoft Azure Synapse Analytics is its user interface. You can use it for analytical purposes, but its platform should be a little bit more user-friendly. Another small point for improvement in Microsoft Azure Synapse Analytics is its stability. It's good currently, but it could still be improved. Microsoft is combining different tools and technologies into one solution, so in the future, I'm expecting to see even more improvement in Microsoft Azure Synapse Analytics. An additional feature I'd like to see in the next version of Microsoft Azure Synapse Analytics is the drag-and-drop feature. If you're doing some integrations where you can write Scala or you have SPARK programming or SQL, or you're combining different programming, the process should be seamless, and you should be able to drag and drop in Microsoft Azure Synapse Analytics. When doing reporting in the solution, you should also be able to drag and drop. There should be connectors available and a drag-and-drop feature available in the user interface of Microsoft Azure Synapse Analytics, so you won't have to worry about how all processes would work together. You need to be able to drag and drop even from the backend, and having this feature will make the solution more user-friendly.

Read full review

MandarGarge

V.P. Digital Transformation at e-Zest Solutions

Jun 29, 2022

The initial setup is very straight forward. Azure Synapse offers you one workspace where you can do everything, creation of your data warehouse, ETL pipelines using Azure Data Factory, Create storage and data marts. Also use Power BI for visualization. Before Synapse was available, all of these was offered as separate services and this is how a data warehouse was constructed. Synapse is one layer on top of this where we make use of one single workspace to initiate and manage the entire set of services that you need for creating and managing your data platform - Data Warehouses and marts using SQL Warehouse, ETL pipelines using Azure Data Factory, Data Lake using Azure Blob Storage, and it offers server-less SQL - meaning you can run queries without having to initiate an SQL database or SQL data warehouse instance. It also offers Spark compute to process non-structured data.

Read full review

Dhruv Singh

Senior Architect (Data and AI) at a tech services company with 1,001-5,000 employees

Aug 4, 2022

The product needs a tool that allows for work from a laptop instead of a browser. When working in on-premises environments, it is important to have all tools installed on a laptop rather than relying on internet connectivity which is a big inconvenience. For example, it would be brilliant to add an integration on Visual Studio to create all pipelines in an offline mode. The solution cannot store much data and might require purchasing additional storage. For example if you have 1 TB of data, processing it in the solution will cost ten times more than processing it in Databricks.

Read full review

Pricing

"The price of this solution could be improved."
"The pricing is okay. You can pay as you go."
"This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version."

Valuable Features

"Scaling this solution is easy and the uptime is okay."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"The initial setup was really easy and straightforward."

Room For Improvement

"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."

Pricing

"The price of this solution could be improved."
"The pricing is okay. You can pay as you go."
"This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version."

Valuable Features

"Scaling this solution is easy and the uptime is okay."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"The initial setup was really easy and straightforward."

Room For Improvement

"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our Microsoft Azure Synapse Analytics Buyer's Guide for additional reliable information.

Learn more about Microsoft Azure Synapse Analytics

Microsoft Azure Synapse Analytics is built with these 4 components:

Synapse SQL
Spark
Synapse Pipeline
Studio

Microsoft Azure Synapse Analytics Features

Microsoft Azure Synapse Analytics has many valuable key features, including:

Cloud Data Service: WIth Microsoft Azure Synapse Analytics you can operate services (data analytics, machine learning, data warehousing, dashboarding, etc.) in a single workspace via the cloud.
Structured and unstructured data: Microsoft Azure Synapse Analytics supports both structured and unstructured data and allows you to manage relational and non-relational data - unlike data warehouses and lakes that tend to store them respectively.
Effective data storage: Microsoft Azure Synapse Analytics offers next-level data storage with high availability and different tiers.
Responsive data engine: Microsoft Azure Synapse Analytics uses Massive Parallel Processing (MPP) and is designed to handle large volumes of data and analytical workloads efficiently without any problems.
Several scripting languages: The solution provides language compatibility and supports different programming languages, such as Python, Java, Spark SQL, and Scala.
Query optimization: Microsoft Azure Synapse Analytics works well to facilitate limitless concurrency and performance optimization. It also simplifies workload management.

Microsoft Azure Synapse Analytics Benefits

Some of the benefits of using Microsoft Azure Synapse Analytics include:

Database templates: Microsoft Azure Synapse Analytics offers industry-specific database templates that make it easy to combine and shape data.
Better business insights: With Microsoft Azure Synapse Analytics you can expand discovery of insights from all your data and apply machine learning models to all your intelligent apps.
Reduce project development time: Microsoft Azure Synapse Analytics makes it possible to have a unified experience for developing end-to-end analytics, which reduces project development time significantly.
Eliminate data barriers: By using Microsoft Azure Synapse Analytics, you can perform analytics on operational and business apps data without data movement.
Advanced security: Microsoft Azure Synapse Analytics provides both advanced security and privacy features to ensure data protection.
Machine Learning: Microsoft Azure Synapse Analytics integrates Azure Machine Learning, Azure Cognitive Services, and Power BI.

Reviews from Real Users

Below are some reviews and helpful feedback written by Microsoft Azure Synapse Analytics users who are currently using the solution.

PeerSpot user Jael S., who is an Information Architect at Systems Analysis & Design Engineering, comments on her experience using the product, saying that it is “Scalable, intuitive, facilitates compliance and keeps your data secure”. She also says "We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud."

Michel T., CHTO at Timp-iT, mentions that "the features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."

A Senior Teradata Consultant at a tech services company says, "Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."

Microsoft Azure Synapse Analytics was previously known as Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics.

Microsoft Azure Synapse Analytics is the #2 ranked solution in top Cloud Data Warehouse tools. PeerSpot users give Microsoft Azure Synapse Analytics an average rating of 7.8 out of 10. Microsoft Azure Synapse Analytics is most commonly compared to Azure Data Factory: Microsoft Azure Synapse Analytics vs Azure Data Factory. Microsoft Azure Synapse Analytics is popular among the large enterprise segment, accounting for 50% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a educational organization, accounting for 27% of all views.