Try our new research platform with insights from 80,000+ expert users
Enterprise Solutions Architect at a consultancy with 1-10 employees
Reseller
Top 20
Integrates well with other solutions, but the interface is not as user-friendly or intuitive
Pros and Cons
  • "I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
  • "Real-time integration is hard to do in Microsoft Azure Synapse Analytics."

What is our primary use case?

We use it for reporting purposes and for building data warehouses, pipelines, and data lakes for IoT projects.

What is most valuable?

I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions. 

What needs improvement?

Real-time integration is hard to do in Microsoft Azure Synapse Analytics.

For how long have I used the solution?

I've been using Microsoft Azure Synapse Analytics for two years.

Buyer's Guide
Microsoft Azure Synapse Analytics
April 2025
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
849,686 professionals have used our research since 2012.

What do I think about the stability of the solution?

I would rate the solution's stability at nine out of ten.

What do I think about the scalability of the solution?

For the amount of data that we have, Microsoft Azure Synapse Analytics has worked perfectly fine in terms of scalability. Thus, for us the scalability is a ten out of ten.

How was the initial setup?

The documentation is good, but if you cannot find the right documentation and the right steps, then the initial setup can be hard. I would rate the initial deployment at seven out of ten.

This solution is deployed on the cloud, and it took half a day to deploy it. I configured the data lake storage, created the workspace, and added users and user rights. Building pipelines is a straightforward process.

What's my experience with pricing, setup cost, and licensing?

I think Microsoft Azure Synapse Analytics is priced well, and I would rate the price at eight out of ten.

What other advice do I have?

On a scale from one to ten, I would rate Microsoft Azure Synapse Analytics at seven. Other solutions have more user-friendly and intuitive interfaces.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner and reseller
PeerSpot user
reviewer1466190 - PeerSpot reviewer
Manager: Data Analytics at a consultancy with 1,001-5,000 employees
Real User
User-friendly, has a good dashboard, and meets the needs of our clients
Pros and Cons
  • "It's user-friendly and has a good dashboard."
  • "I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head."

What is our primary use case?

We are using this product data warehousing and analytics.

What is most valuable?

Pretty much all of the features are valuable, including storage and compute. All of the features are essential to what you do.

It's very reliable and cost-effective. It meets the needs of our clients.

It's user-friendly and has a good dashboard.

What needs improvement?

I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head.

For how long have I used the solution?

I have been using Microsoft Azure Synapse Analytics for a couple of years.

What do I think about the stability of the solution?

It's a stable product and we're satisfied and comfortable with it. Our clients and partners have found it to be very stable and scalable, as well.

What do I think about the scalability of the solution?

Synapse Analytics is a scalable product.

How are customer service and technical support?

Generally, support from Microsoft is always good. I can't recall the specific instance where we had to contact them, but it was good.

How was the initial setup?

The initial setup is very straightforward. It only took five minutes to set up.

What about the implementation team?

We deployed the solution in-house, and we also deploy it for our clients.

What's my experience with pricing, setup cost, and licensing?

This is a cost-effective product.

What other advice do I have?

I highly recommend this solution to others, and we recommend it to our clients.

Overall, it's exceptionally good.

I would rate this solution a nine out of ten.

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 has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Microsoft Azure Synapse Analytics
April 2025
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
849,686 professionals have used our research since 2012.
it_user1459005 - PeerSpot reviewer
Data Architect at a tech services company with 51-200 employees
Real User
Good support, offers advanced threat protection, and it integrates well with Polybase
Pros and Cons
  • "The most important feature for me is the integration with PolyBase."
  • "The need to improve a little bit in terms of user-friendliness."

What is our primary use case?

We are mainly using this solution as an interface between the Data Lake and the users.

We are consultants and this product assists with the services that we offer for our clients. Our company has a large number of consultants who are working in this space.

What is most valuable?

The most important feature for me is the integration with PolyBase.

Other valuable features for me are advanced threat protection and data privacy.

What needs improvement?

I would like there to be more focus on the Software as a Service (SaaS) product. For example, Snowflake, one of their competitors, is more focused on SaaS.

They need to improve a little bit in terms of user-friendliness. I would rate them a three out of five, in terms of how user-friendly the interface is.

The auto-scaling capabilities are quite poor, especially compared to Snowflake or Firebolt.

For how long have I used the solution?

In total, I have been using Microsoft Azure Synapse Analytics for one year.

What do I think about the stability of the solution?

This is a stable solution.

What do I think about the scalability of the solution?

You can scale it, although you need to put in more effort. We have approximately 800 users.

How are customer service and technical support?

In general, Microsoft support is pretty good.

Which solution did I use previously and why did I switch?

I have experience with similar products such as Snowflake and Firebolt.

How was the initial setup?

The initial setup is very complex compared to other products. It takes weeks to deploy.

What about the implementation team?

We implement this product for our clients.

What's my experience with pricing, setup cost, and licensing?

The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte. The charge might be several thousand dollars or more each month.

There are multiple options that are available at an extra cost. For example, the advanced threat protection costs an extra $25 USD.

Which other solutions did I evaluate?

We evaluated several options before choosing Synaps Analytics.

What other advice do I have?

The suitability of this product really depends on the use case. It is good if your company is using only Microsoft products and you don't want to use another stack. If you want to use other platforms then you should consider Snowflake, which is also deployed on Azure. It really depends on what it is that you need.

I would rate this solution an eight 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
PeerSpot user
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees
Real User
The architectural design is very scalable but the services are expensive
Pros and Cons
  • "The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs."
  • "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."

How has it helped my organization?

We haven't really implemented any SSIS. I haven't been in a project where it was implemented as part of the data we have been building.

What is most valuable?

The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.

What needs improvement?

So far, with the current SQL that I'm using compared to what we've previously used, I'm happy with it. I wouldn't necessarily point out anything that needs improvement.

From my point of view from what we have implemented recently, I'm happy with the solution, I'm happy with the performance. 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.

For how long have I used the solution?

I have been using this solution for around 18 months.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

I think the architectural design is very scalable.

How are customer service and technical support?

I never contacted Microsoft customer support. 

We do have access to it, but we haven't needed to.

Which solution did I use previously and why did I switch?

I've used Tableau, I've used SQL DB, I've used SAP DB.

How was the initial setup?

The initial setup wasn't complex. It was okay. It wasn't complex at all.

To set it up within full compliance with our cloud infrastructure team, I'd say maybe two weeks after beginning our testing. I'd say the team wasn't a hundred percent devoted to setting it up as they had other things to do. So I'd say I'll give it two weeks to be realistic for a large organization.

What about the implementation team?

It depends on whether you have those resources internally or not. If you have internal resources you wouldn't need to outsource, if you don't have, you would. So it's not a matter of how good that application is but a question of whether you have the capability in house.

What's my experience with pricing, setup cost, and licensing?

The enterprise services are pretty expensive.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1524705 - PeerSpot reviewer
Senior Systems Analyst at a non-profit with 201-500 employees
Real User
Easy to use, good performance, and useful documentation
Pros and Cons
  • "The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
  • "When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."

What is our primary use case?

We have been using Microsoft Azure Synapse Analytics as our proof of concept in our data warehouse. As for the analytics part, we have not used it because we do not have any SQL pools. We think it is a bit more than we need because our data is not implicated and the data sets are not very large. It is mostly been used for the detection functions and to link up the sources.

What is most valuable?

The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services.

What needs improvement?

When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options.

For how long have I used the solution?

I have been using Microsoft Azure Synapse Analytics for approximately six months.

What do I think about the stability of the solution?

The solution is incredibly stable. 

The only thing that has not been stable are the pipelines that we are using runtime integration on our on-premise server and something is slowing everything down, it might be a particular ODBC connection. I am not sure if that is due to the Microsoft platform or it might be some other setup or settings that are causing the issue. However, other than this issue, the solution has been brilliant. It has been very reliable and stable.

What do I think about the scalability of the solution?

The solution is scalable. I have changed the interface and most of the operations can be done from the interface by clicking a few buttons, it is quick and easy.

At the moment we only have approximately four people using the solution because it is a data warehouse creation in the back end. We have not reached the stage where our staff will use the product but we are building a single customer view using the platform and we will be increase usage in the future.

How was the initial setup?

The initial installation is straightforward. There is a lot of documentation provided by Microsoft making it very easy to get started.

What was our ROI?

Having used the serverless option for the database has saved us a lot of money.

What's my experience with pricing, setup cost, and licensing?

We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month.

What other advice do I have?

It is beneficial to always plan exactly what the main aims are and then choose the solution that can do it. If you want something quick, I set something up without any knowledge with Azure in three weeks. Once you get going, everything will be at your fingertips.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Mullai Selvan - PeerSpot reviewer
Project Manager at MAQ Software
Real User
Very scalable with good documentation and fair pricing
Pros and Cons
  • "The pricing seems to be quite fair."
  • "The initial setup has a bit of a learning curve."

What is our primary use case?

We are an IT service provider. We develop solutions for our clients and this solution is used in some aspects of that.

What is most valuable?

The dashboards are good.

We haven't had any issues when it comes to customization.

The security seems to be okay. It hasn't given us any problems and we don't feel insecure.

The pricing seems to be quite fair.

I know their roadmap, and I am looking forward to what they have already published.

We've been happy with the level of reporting and documentation on offer.

What needs improvement?

There aren't any features that are really lacking in the solution. We don't really have any issues with it in its current form.

When we used the on-premises deployment model, we had data latency issues and suffered from page performance problems. However, since we've moved to the cloud, we haven't had these problems.

The initial setup has a bit of a learning curve.

For how long have I used the solution?

We've been using the solution for the past 18 months so far.

What do I think about the stability of the solution?

The solution seems to be scalable. We haven't had any issues with bugs or glitches. It doesn't crash or freeze. It's quite good.

What do I think about the scalability of the solution?

The scalability has been pretty good, in our experience. We have been able to scale it twice to the number of users we needed. We were also able to double the amount of data load. We haven't had issues. If a company needs to expand, it should be able to do so without problems.

How are customer service and technical support?

We've dealt with technical support and have found them to be quite responsive and knowledgeable. We're quite satisfied with the level of support we have been getting so far. They're helpful.

How was the initial setup?

It's hard to gauge the difficulty or simplicity of the setup. For our company, we were learning the processes as we were doing it. In that sense, it was challenging due to the fact that we had to learn and then do. After a period of time, we were able to get comfortable.

What about the implementation team?

We handled the implementation ourselves. We taught ourselves about the process as we went.

What's my experience with pricing, setup cost, and licensing?

We pay a licensing fee on a monthly basis. We find the pricing to be fair among the competition.

What other advice do I have?

We're just end-users and customers. We don't have a business relationship with the organization.

We're using the latest version of the solution right now.

I'd recommend the solution to other organizations.

I'd rate the solution at a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1466190 - PeerSpot reviewer
Manager: Data Analytics at a consultancy with 1,001-5,000 employees
Real User
Cost-effective, reliable data warehousing that is user-friendly, and it is easy to scale
Pros and Cons
  • "They are very reliable and cost-effective."
  • "I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."

What is our primary use case?

We are using this solution for data warehousing and analytics.

What is most valuable?

Pretty much all of the features are valuable. The storage, compute, all essentially differentiate what you do.

They are very reliable and cost-effective. It meets the client's requirements.

It's user-friendly, has a good dashboard, and my team is happy with everything.

What needs improvement?

I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head.

For how long have I used the solution?

I have been using this solution for a while, I would say approximately two years.

We are using the latest version. It's always updated on the cloud.

What do I think about the stability of the solution?

We found it to be a very stable product.

What do I think about the scalability of the solution?

It's a scalable solution and we find it to be easy to scale.

How are customer service and technical support?

Generally, support from Microsoft is always good.

I can't recall where we had an issue that we had to contact technical support, but the support is very good.

How was the initial setup?

The initial setup was very straightforward. It took only five minutes to set up.

What about the implementation team?

We completed the deployment in-house, we did it ourselves. We also implement it for our clients. 

It's pretty straightforward, we do not need help with this.

What's my experience with pricing, setup cost, and licensing?

Because it's a cloud solution, the cost is a different convention and the licensing costs are not the same.

What other advice do I have?

I would highly recommend this solution to others who are interested in using it. We recommend it to our clients.

It's exceptionally good, and our clients and other partners find it both stable and scalable.

I would rate this solution a nine 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: Partner
PeerSpot user
reviewer1041249 - PeerSpot reviewer
Project Manager at a tech services company with 5,001-10,000 employees
Real User
Good analytics and integration with Power BI, but the ETL capability is far behind other products
Pros and Cons
  • "The most valuable feature of the solution is the analytics and that it can connect with Power BI."
  • "I would like my team to be able to build pipelines that integrate with the Azure Data Factory."

What is our primary use case?

We primarily use this solution for source analytics and procurement.

What is most valuable?

The most valuable feature of the solution is the analytics and that it can connect with Power BI. I found it quite interesting and very compelling in terms of detail within a single stack.

What needs improvement?

I would like my team to be able to build pipelines that integrate with the Azure Data Factory. Some of the best-in-class ETL products that are available in the market, such as Informatica ETL, are far more mature than this solution.

For how long have I used the solution?

We started implementing projects with Microsoft Azure SQL Data Warehouse about six months ago.

What do I think about the stability of the solution?

This is a stable product.

What do I think about the scalability of the solution?

Scalability is good and we haven't had any issues.

We have approximately 150 users. We are stable at the moment but we will expand our usage as we get more data.

How are customer service and technical support?

We have contacted Microsoft support twice, but I do not have much experience with them.

Which solution did I use previously and why did I switch?

In addition to Azure SQL Data Warehouse, we work with the version that is on-premises.

We are also working with Oracle Data Warehouse and we plan to continue using both of these solutions.

How was the initial setup?

The initial setup is straightforward.

What about the implementation team?

We implement this solution for our customers.

What other advice do I have?

If you are using Microsoft products, such as Office 365, then this solution is good because it can take the data from multiple sources. 

This is a good product, but when you compare to Oracle Data Warehouse there are differences in scalability, high availability, and implementation.

I would rate this solution a seven out of ten.

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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2025
Product Categories
Cloud Data Warehouse
Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros sharing their opinions.