The most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user.
Linux Platform System Administrator at a healthcare company with 10,001+ employees
Useful for large data, scalable, and high availability
Pros and Cons
- "The most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user."
- "There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics."
What is most valuable?
What needs improvement?
There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics.
For how long have I used the solution?
I have been using Microsoft Azure Synapse Analytics for approximately one year.
What do I think about the stability of the solution?
The stability of Microsoft Azure Synapse Analytics is great. It offers a high level of performance.
Buyer's Guide
Microsoft Azure Synapse Analytics
May 2025

Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
What do I think about the scalability of the solution?
The scalability of Microsoft Azure Synapse Analytics is good.
How are customer service and support?
The support from Microsoft Azure Synapse Analytics is excellent.
How was the initial setup?
There is a steep learning curve to do the implementation.
I rate the initial setup of Microsoft Azure Synapse Analytics a seven out of ten.
What other advice do I have?
The entire Microsoft Azure ecosystem is well connected and Microsoft has done well with the features.
My advice to others is to try out the solution, do your homework and research, and set up a POC environment.
I rate Microsoft Azure Synapse Analytics an eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Senior Software Engineer at a computer software company with 501-1,000 employees
Straightforward solution with great notebooks and monitoring
Pros and Cons
- "Synapse Analytics' best features are notebooks, pipelines, and monitoring."
- "Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets."
What is our primary use case?
I mainly use Synapse Analytics to gather data, do aggregations, and generate reports.
What is most valuable?
Synapse Analytics' best features are notebooks, pipelines, and monitoring.
What needs improvement?
An improvement to Azure Synapse would be more templates for specific domains.
For how long have I used the solution?
I've been using Synapse Analytics for four months.
What do I think about the stability of the solution?
Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets.
What do I think about the scalability of the solution?
Synapse Analytics is definitely scalable.
How are customer service and support?
Microsoft's technical support is fast and responsive.
Which solution did I use previously and why did I switch?
Previously, we used Databricks.
How was the initial setup?
The initial setup was straightforward, and I would rate the experience as 4.5 out of 5.
What was our ROI?
We're getting a good ROI from Synapse Analytics.
What's my experience with pricing, setup cost, and licensing?
I understand that Synapse Analytics' pricing is lower than Informatica's.
Which other solutions did I evaluate?
I also evaluated Informatica Cloud Integrations but felt that Synapse was more straightforward.
What other advice do I have?
I would give Synapse Analytics a rating of nine out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Microsoft Azure Synapse Analytics
May 2025

Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
Senior Consultant at Dynamic Elements AS
Captures a company's transactional data and provides great reporting
Pros and Cons
- "Can capture all the transactional data throughout a company."
- "Non-structured data is unavailable with this product."
What is our primary use case?
I'm a senior consultant.
What is most valuable?
For those working in the retail sector, this product can capture all the transactional data throughout a company's stores, process them, and put them into the Azure Synapses. Once you have the data, you can clean and aggregate it. On top of that, it has a reporting tool so you can connect to those Data Warehouse Synapses and pull up your reports which can then be used to prepare the dashboards and enable more insight.
What needs improvement?
Non-structured data is unavailable with this product.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
Azure Synapse is serverless architecture, so you can scale as and when required. It makes no difference if there are 100 users or 1,000 users. We have around 50,000 end users.
How are customer service and support?
The customer support is generally quite good. They follow up relatively quickly although it can sometimes take more time if it requires an SOP to follow up.
How was the initial setup?
The initial setup is straightforward. It's a matter of connecting to your visual studio or management studio.
What other advice do I have?
It's important to understand your business needs and choose an appropriate solution based on the industry you work in and what needs to be achieved. There are a lot of tools available on the market, it's important to get the right one.
I rate this solution eight out of 10.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Director of Systems of the TCESP at a government with 501-1,000 employees
Simple analytics, good interface, and multiple database comparability
Pros and Cons
- "The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment."
- "Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
What is our primary use case?
We are using Microsoft Azure Synapse Analytics to find some evidence or outlier in our analysis about the application of the public health service and public money in the sector in Brazil. We are a public institution that is responsible for auditing other public institutions. We use these kinds of tools to find some evidence and outliers to audit with a little bit more documents or evidence.
What is most valuable?
The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment.
The interface of the solution is good.
What needs improvement?
Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great.
For how long have I used the solution?
I have been using Microsoft Azure Synapse Analytics for approximately six years.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Senior Manager, Global Network Development at a comms service provider with 10,001+ employees
Scales well, has a wide range of features, and is easy to set up
Pros and Cons
- "It's feature-rich. It has a wide range of features."
- "It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes."
What is our primary use case?
It's used for business case analysis and bandwidth utilization, etc.
We are using its latest version.
What is most valuable?
It's feature-rich. It has a wide range of features.
What needs improvement?
It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes.
For how long have I used the solution?
I've been using this solution for more than four years.
What do I think about the stability of the solution?
It's quite stable. I'd rate it an eight out of ten in terms of stability. There are very few outages or errors during the configuration.
What do I think about the scalability of the solution?
It's scalable. I'd rate it an eight out of ten in terms of scalability. Our clients are enterprises.
How are customer service and support?
I haven't contacted them, but it should be fairly good. I haven't had many issues with it.
How was the initial setup?
I'd rate it a nine out of ten in terms of the setup. It has a GUI, which is awesome. Its deployment duration varies based on the case to case. We have quite a few SMEs for deployment.
It doesn't require many people for maintenance.
What other advice do I have?
It has been good so far. I'd recommend it to others. I'd rate it an eight out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Data engineer at Inicon S.r.l.
Analytics solution used to assess big data from different sources and integrates well with other Azure features
Pros and Cons
- "One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure."
- "Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
What is our primary use case?
We use this solution to analyze big data. We collect data from different sources then we analyze that data with Synapse.
What is most valuable?
One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure.
What needs improvement?
Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved.
For how long have I used the solution?
We have used this solution for two years.
What do I think about the stability of the solution?
This is a stable solution but we have experienced some unavailability issues. These were not critical issues.
What do I think about the scalability of the solution?
This solution is quite easy to scale depending on your workload. Overall it is a little bit expensive. You have to know exactly what you are doing as you scale up, otherwise the cost goes up quite quickly.
How was the initial setup?
This solution is relatively easy to set up and use. The time it takes to setup depends on the complexity of your environment. If you want to complete a basic setup, it only involves a few clicks. In a production environment for a complex setup, it's it takes some time to complete the configuration.
What about the implementation team?
We completed the setup in-house.
What other advice do I have?
Synapse is useful for very big loads of data.
I would rate this solution a seven out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Associate Director at a tech services company with 10,001+ employees
Scalable product that needs more user-friendly ready-to-use products
Pros and Cons
- "The solution offers strong scalability opportunities."
- "I would like to see more ready-to-use products from Synapse. Right now, everything seems a bit futuristic without much modern use."
What is our primary use case?
I am the Associate Director of a company that is a partner of Synapse.
What is most valuable?
The solution offers strong scalability opportunities.
What needs improvement?
I would like to see more ready-to-use products from Synapse. Right now, everything seems a bit futuristic without much modern use.
What do I think about the scalability of the solution?
The solution is scalable.
What's my experience with pricing, setup cost, and licensing?
Price is dependent of the use case of the customer. Customers are not likely to only use this as an individual platform/database, they are likely to bundle it with the Azure stack.
Which other solutions did I evaluate?
Snowflake is a solution that is much more ahead of the game. There are many gaps in Synapse that Snowflake has fulfilled (i.e. usage, and storage).
What other advice do I have?
Be sure to be clear about the ideal pipeline for Synapse, differentiate your needs, and validate based on use-case.
I would rate this solution a six out of ten overall.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Advisory Software Engineer at a tech services company with 1,001-5,000 employees
User-friendly, good performance for large volumes of data, but it is more expensive than some competitors
Pros and Cons
- "The most valuable feature is the level of processing power, and being able to complete tasks in parallel."
- "Integration with other products is an area that can be improved."
What is our primary use case?
We have a huge amount of data, and we need a platform where we can process the data using Spark clusters. We wanted an environment that included databases that are capable of parallel processing, and Azure Synapse was one of the best for that.
How has it helped my organization?
This product has given us a lot of processing power with the database, and at the backend as well.
What is most valuable?
The most valuable feature is the level of processing power, and being able to complete tasks in parallel. This is the feature that attracts us the most because we have a lot of data that we need to process in a short time.
This is a user-friendly environment.
What needs improvement?
Integration with other products is an area that can be improved.
For how long have I used the solution?
I have been working with Microsoft Azure Synapse Analytics for between five and six months.
What do I think about the stability of the solution?
Synapse definitely seems like a stable product.
What do I think about the scalability of the solution?
Synapse Analytics is deployed in a cloud environment and one of the best advantages of this is that it provides scalability.
How are customer service and support?
I have not had any experience with Microsoft technical support.
Which solution did I use previously and why did I switch?
I also have experience with the services available on AWS.
How was the initial setup?
Configuring this solution was easy.
What about the implementation team?
We implemented it with our in-house team. I was part of the team, one of my colleagues was the solution architect, and we have some engineers that assisted us. It was a team effort.
What's my experience with pricing, setup cost, and licensing?
The costs are billed such that we pay for what we use, which is a good thing. For example, we have an environment where we don't need access to certain services, so we don't have to pay for them.
Compared to the services available on AWS, this solution is a little bit pricey.
What other advice do I have?
At this point, Synapse Analytics is fulfilling all of our requirements for the use cases that we have.
I would rate this solution a seven out of ten.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: partner

Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Updated: May 2025
Product Categories
Cloud Data WarehousePopular Comparisons
Azure Data Factory
Amazon Redshift
Oracle Autonomous Data Warehouse
AWS Lake Formation
SAP Business Warehouse
IBM Db2 Warehouse on Cloud
Silk Platform
Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
- Which solution do you prefer: KNIME, Azure Synapse Analytics, or Azure Data Factory?
- Which is better - Azure Synapse Analytics or Snowflake?
- How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
- Which ETL or Data Integration tool goes the best with Amazon Redshift?
- What are the main differences between Data Lake and Data Warehouse?
- What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
- What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?
- Are there any general guidelines to allocate table space quota to different layers in ETL?
- What cloud data warehouse solution do you recommend?