We use the solution for integration to enable the data to reuse it in the power gap.
Data Engineer at a manufacturing company with 10,001+ employees
Simple to integrate, straightforward to set up and reliable
Pros and Cons
- "The solution can scale."
- "The filing can be improved."
What is our primary use case?
What is most valuable?
I like the simplicity of the integration of the data and the variety of the language you can use to integrate that.
It offers a straightforward setup.
The solution can scale.
Its stability is good.
What needs improvement?
There are some limitations. The filing can be improved. Some improvement in the filing is necessary. It needs some kind of growth in the filing development in order to reuse some activities.
For how long have I used the solution?
I'm pretty new in the company. I started in January. However, they have been using this tool for two years.
Buyer's Guide
Microsoft Azure Synapse Analytics
January 2026
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,733 professionals have used our research since 2012.
What do I think about the stability of the solution?
The stability is great. There aren’t bugs or glitches and it doesn’t crash or freeze. It’s reliable.
What do I think about the scalability of the solution?
The solution is scalable.
We have about 20 people using the solution in our company.
How are customer service and support?
I haven't had any contact with technical yet, so I cannot evaluate their level of service.
How was the initial setup?
The solution is easy to set up initially.
What's my experience with pricing, setup cost, and licensing?
I’m not sure how much the solution costs.
What other advice do I have?
We buy direct from Microsoft. Our company may be partners with them.
As Microsoft Azure Cloud, it only has one version. I don't know if there is a version number.
I would advise users to start loading the data beforehand and understand very well how the tool works and how it's useful. That way, you can evaluate the best solution. Sometimes you need to start to load data and review all the alternatives in the solution.
I’d rate the solution a nine out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
Senior manager at a tech services company with 10,001+ employees
Reliable, expandable, and easy to set up
Pros and Cons
- "It's scalable; you can scale up and scale down."
- "We'd, of course, always like to pay less for the service if we can."
What is our primary use case?
The use case depends on different things. For example, for banking, it would be risk management, fraud, and anti-money laundering. For retail, it would be an omnichannel customer experience. For sales, it could be upsell, cross-sell, retention. It's different for every industry.
What is most valuable?
The solution is like a marketplace in that it's easy to consume.
It's scalable; you can scale up and scale down.
The standard things that you see from any cloud perspective make it very attractive.
It is easy to set up.
What needs improvement?
We'd, of course, always like to pay less for the service if we can.
For how long have I used the solution?
I've been using the solution for a few years.
What do I think about the stability of the solution?
The solution is stable. There are no bugs or glitches and it doesn't crash or freeze. It's reliable.
What do I think about the scalability of the solution?
I work for Accenture, so there are hundreds and thousands of customers on Microsoft.
The solution scales very well. You can scale up or down as required. It's very easy.
How are customer service and support?
I don't really interact with technical support, so I can't really comment on their level of service.
How was the initial setup?
I don't think it's very complex to implement. We have our own expertise. We have our own IPs to set it up and therefore it's not really complex. It takes a week to ten days to have everything up and running.
Typically, a pool of six or seven people should be good enough in terms of handling deployment and maintenance. Usually, it's comprised of a mix of managers, admins, engineers, and/or developers.
What was our ROI?
Maybe it takes over a period of two or three years to see an ROI of maybe 50% to 70%.
What's my experience with pricing, setup cost, and licensing?
I don't deal with the licensing aspect of the solution.
What other advice do I have?
I'd recommend this solution to other users.
I'd rate the solution eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer.
Buyer's Guide
Microsoft Azure Synapse Analytics
January 2026
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,733 professionals have used our research since 2012.
Senior Consultant at a tech services company with 11-50 employees
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.
Database Administration at a comms service provider with 1,001-5,000 employees
Easy-to-use product with a straightforward setup process
Pros and Cons
- "The initial setup process is straightforward."
- "One potential area for improvement could be the availability of an on-premises data lake implementation, as the product is currently only implemented in a cloud environment."
What is most valuable?
The product is easy to use.
What needs improvement?
One potential area for improvement could be the availability of an on-premises data lake implementation, as the product is currently only implemented in a cloud environment.
Additionally, the possibility of integrating data from multiple sources could be beneficial.
For how long have I used the solution?
We have used Microsoft Azure Synapse Analytics for approximately three months.
What do I think about the scalability of the solution?
The platform's scalability is similar to that of SQL databases. It requires developing components, implementing services, and performing other related tasks.
How was the initial setup?
The initial setup process is straightforward.
What other advice do I have?
My advice would be to remain open to learning new things, particularly because working with Synapse Analytics requires a shift in mindset from traditional tools like SQL Management Studio to newer tools and approaches.
I rate it an eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Lead Architect at a financial services firm with 10,001+ employees
Works efficiently for data monitoring purposes, but its error messaging process needs improvement
Pros and Cons
- "It is a fantastic product; we are satisfied with its features and performance."
- "We encountered data processing and transformation issues while working with Apache Spark languages for the product."
What needs improvement?
We encountered data processing and transformation issues while working with Apache Spark languages for the product. This particular area needs improvement.
The product's error messaging could be friendlier. Additionally, the monitoring process using Azure ML SDK and Python should depend on the data for the results. Along with the documentation, they should provide essential training for proficiency in CLI. It will help in better monitoring.
For how long have I used the solution?
We have been using Microsoft Azure Synapse Analytics for two years.
What's my experience with pricing, setup cost, and licensing?
The product is expensive.
What other advice do I have?
I rate Microsoft Azure Synapse Analytics a seven out of ten. It is a fantastic product; we are satisfied with its features and performance. However, there could be more information available about the platform.
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.
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?
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.
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.
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.
Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Updated: January 2026
Product Categories
Cloud Data WarehousePopular Comparisons
Azure Data Factory
OpenText Analytics Database (Vertica)
Amazon Redshift
Oracle Autonomous Data Warehouse
AWS Lake Formation
SAP Business Warehouse
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?
















