Try our new research platform with insights from 80,000+ expert users
Microsoft Azure Synapse Analytics Logo

Microsoft Azure Synapse Analytics pros and cons

Vendor: Microsoft
3.9 out of 5
Badge Leader

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Microsoft Azure Synapse Analytics is highly scalable, allowing users to handle very large amounts of data efficiently.
It offers seamless integration with other Azure services, enhancing data processing capabilities.
The flexible, pay-as-you-go model provides cost management and scalability as needed.
Massively Parallel Processing (MPP) architecture boosts performance and efficiency in data handling.
Its capability to manage structured and unstructured data makes it versatile for various use cases.

CONS

Microsoft Azure Synapse Analytics could enhance its Active Directory integration to resolve existing problems.
The initial setup and configuration process needs to be more user-friendly and time-efficient, especially for cloud transitions.
The billing model is unpredictable and can lead to unexpectedly high costs, especially for pay-as-you-go users.
Integration with data sources could be broader, especially with Hadoop and Oracle solutions.
Scalability and performance need improvement, including better handling of large datasets and concurrent queries.
 

Microsoft Azure Synapse Analytics Pros review quotes

it_user937602 - PeerSpot reviewer
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
Jul 28, 2019
Scaling this solution is easy and the uptime is okay.
it_user891138 - PeerSpot reviewer
Consultant at a non-profit with 11-50 employees
Sep 23, 2019
The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS.
reviewer1061157 - PeerSpot reviewer
Executive Board Member / General Manager at a comms service provider with 51-200 employees
Oct 15, 2019
The initial setup was really easy and straightforward.
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,443 professionals have used our research since 2012.
reviewer1052472 - PeerSpot reviewer
Data Architect at a tech services company with 10,001+ employees
Nov 13, 2019
The MPP (Massively Parallel Processing) architecture helps to make things a lot faster.
reviewer1003956 - PeerSpot reviewer
Managing Partner at a tech services company with 11-50 employees
Nov 13, 2019
The most valuable feature is the scalability.
Jaya Prakasha Sarma - PeerSpot reviewer
Practice Head BI at Nous Infosystems
Dec 11, 2019
The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.
BT
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees
Dec 12, 2019
The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.
PP
Vice President Technologies at Excelencia
Dec 16, 2019
Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to.
AD
Analytics Engineer at a tech services company with 51-200 employees
Dec 17, 2019
The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis.
reviewer1041249 - PeerSpot reviewer
Project Manager at a tech services company with 5,001-10,000 employees
Dec 18, 2019
The most valuable feature of the solution is the analytics and that it can connect with Power BI.
 

Microsoft Azure Synapse Analytics Cons review quotes

it_user937602 - PeerSpot reviewer
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
Jul 28, 2019
I would like to see better integration with Active Directory, because we have had problems, and we still do.
it_user891138 - PeerSpot reviewer
Consultant at a non-profit with 11-50 employees
Sep 23, 2019
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.
reviewer1061157 - PeerSpot reviewer
Executive Board Member / General Manager at a comms service provider with 51-200 employees
Oct 15, 2019
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.
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,443 professionals have used our research since 2012.
reviewer1052472 - PeerSpot reviewer
Data Architect at a tech services company with 10,001+ employees
Nov 13, 2019
This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market.
reviewer1003956 - PeerSpot reviewer
Managing Partner at a tech services company with 11-50 employees
Nov 13, 2019
It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a loop that is running all night, you could receive a very expensive bill.
Jaya Prakasha Sarma - PeerSpot reviewer
Practice Head BI at Nous Infosystems
Dec 11, 2019
With respect to what needs to be improved, concurrent connectivity has some limitations.
BT
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees
Dec 12, 2019
I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it.
PP
Vice President Technologies at Excelencia
Dec 16, 2019
The configuration for things like high-availability could be more user-friendly for non-technical users.
AD
Analytics Engineer at a tech services company with 51-200 employees
Dec 17, 2019
I would like to see version control implemented into the data warehouse.
reviewer1041249 - PeerSpot reviewer
Project Manager at a tech services company with 5,001-10,000 employees
Dec 18, 2019
I would like my team to be able to build pipelines that integrate with the Azure Data Factory.