Enterprise architect at a computer software company with 201-500 employees
Real User
Very cost effective with virtualization to Power BI; overall deployment and integration is quick
Pros and Cons
  • "Overall deployment and integration is pretty fast."
  • "Could have more connectors and better integration for Hadoop."

What is our primary use case?

We're using this solution for analytics and its modeling capabilities. It allows you to have your visualization on top of your synapse analytics. We are partners with Microsoft. 

What is most valuable?

I like that the overall deployment and integration is pretty fast and then you also have virtualization to Power BI so it's also quite cost-effective.

What needs improvement?

For improvement, I would like to see more connectors and better integration for Hadoop. There are currently limitations for Hadoop on-prem. I'd like to see better integration and more flexibility. 

For how long have I used the solution?

I've been using this product for almost a year. 

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

What do I think about the stability of the solution?

This is a stable solution. We have four companies who are customers of this solution and we have a team that deals with any problems. 

What do I think about the scalability of the solution?

The product is scalable. 

How are customer service and support?

The technical support is very good. 

How was the initial setup?

The initial setup is straightforward and takes around two hours. 

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

There is a license for Azure, and whether it's a monthly or annual payment depends on the agreement you have with Microsoft. A long-term plan is more cost effective. 

What other advice do I have?

I rate this solution a nine out of 10. 

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
Enterprise Solutions at Celebal Technologies
Real User
Scalable, easy to use and set up with an intuitive platform that integrates well with Power BI
Pros and Cons
  • "They are available on the Cloud, and the platform is very intuitive."
  • "It needs strong support for social media, internet data, and native support for NoSQL."

What is our primary use case?

We are service providers for our clients.

My clients primarily come from the enterprise segments, such as manufacturing, retail, pharmaceutical, and industrial. Most are supported by a large ERP solution like SAP.

Some of our clients are mid-size and others are large enterprise companies, some of the largest in India.

What is most valuable?

Some of the most valuable features would include Familiarity for practitioners like us and also familiarity for the businesses. SQL servers have been around for several decades and there are many who are familiar with SQL servers, such as SSIS and SSRS.

They are available on the Cloud, and the platform is very intuitive.

It integrates very well with Power BI, which I would rate as the best self-service BI. All the data warehouses eventually end up in BI or Machine Learning. 

Instant Apps that are more integrated rather than desperate components. You need to get different components engineered together, and with SQL everything comes together.

Instant Apps is a combination of your Spark compute platform, your SQL data platform, and your object storage. It's a platform that is integrated all together. 

It's easy to work with a faster turnaround time on my project deliveries.

Also, the integration with Power BI self-service is much, much easier and familiar.

You can have several SQL servers, they have large .NET artifacts that combine various components together very well.

What needs improvement?

What I would like to see more and more of in Azure is its support for IoT and streaming media information.

It needs strong support for social media, internet data, and native support for NoSQL. At this time, it works very well with the structured data

Stability could be improved.

Technical support is very good, but could also be improved.

For how long have I used the solution?

My company has been working with SQL Data Warehouse for approximately three and a half years, and I have been working with this solution for one and a half years.

What do I think about the stability of the solution?

In the last six months, there have been a couple of incidents. We have experienced som outages. One of our clients was in a blackout for a couple of hours. Most of the clients in India have experienced outages also. They were restored, so I refer to them as glitches.

What do I think about the scalability of the solution?

In principle, it's a limitless, serverless solution. As long as your region has resources, you can go on expanding. We have not had any problems with scalability.

Microsoft Azure comes integrated with Databricks as a Machine Learning platform, it's highly scalable.

How are customer service and technical support?

Technicals support engages very well. We have account managers in place who correspond with technical support. 

The technical support team has a good relationship with our Account managers.

If we have an issue, we advise our account managers and present the ticket, they contact Technical support and resolve the issue very quickly.

If however, I have to contact Microsoft technical support at the backend, they are not very knowledgable. They have a good understanding of their products, but most of the time they struggle with that.

How was the initial setup?

The initial setup is easy. The learning curve for Microsoft platforms is very low. An engineer with very little experience would be able to complete the initial set up with ease.

It has a quick turnaround time. We have completed the deployment in weeks.

For a BI project scheduled for six months, within the first month we would have completed the data warehouse installation, and the remaining five months would be for building the content, the data pipelines from the sources, the semantic models, and the BI.

When you compare it with other solutions that take months to get your sandbox running or to get your development running.

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

They are cost aggressive, and it integrates well with other Microsoft tools. For example Downstream and Teams.

What other advice do I have?

We use the serverless platform as a service, that is only available with Microsoft Azure.

You don't have to hire experienced engineers to set up and implement the solution, saving you money, because it is very intuitive and the turnaround time is very low compared to other data warehouses. I would put it in par with solutions such as Redshift and BigQuery.

It's very modern, easy, and intuitive.

Most of the services are cheaper than other vendors.

This definitely falls into one of the top three or top four solutions and platforms in the world. I would definitely recommend it. If someone should ask me if they should use Microsoft Azure SQL Data Warehouse, I would say yes.

Personally, I don't see one great solution that exceeds in all aspects. Every solution has some good points and I think they have very beautifully found their strength and they're building upon it.

When asked what would best suit me, I would assess their environment requirements and could easily recommend any of the top four, being AWS Redshift, Google, Big Query, and Microsoft Azure.

I would rate this solution an eight 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
PeerSpot user
Buyer's Guide
Microsoft Azure Synapse Analytics
April 2024
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.
President at a tech company with self employed
Real User
Good analytics, and has good technical support
Pros and Cons
  • "I have been working with Microsoft, and they have been very helpful."
  • "If I'm looking for something good in the cloud, I would want it to have better standard connectors."

What is our primary use case?

We use Microsoft Azure Synapse Analytics for analytics.

What needs improvement?

If I'm looking for something good in the cloud, I would want it to have better standard connectors.

For how long have I used the solution?

I have been working with Microsoft Azure Synapse Analytics for two years.

We are up-to-date with the latest version.

How are customer service and support?

I have been working with Microsoft, and they have been very helpful.

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

It's the only product I've used. I'm not sure what's wrong or what could be done better.

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

I don't know about the price, but I'm trying to get a sense of the cost. I believe having a good comparison would help.

What other advice do I have?

This is the only product I've ever used, as such, it's extremely difficult for me to say anything about it. For example, if I needed a bike, and now I have one and am riding it. If you ask me some questions, it's difficult for me to say, "Oh, I really missed this one on my first bike," unless I've ridden a few bikes. I'm not sure why everything is the way it is. I had a need, and I'm only using it now.

I'm trying to understand what else is out there and how it compares to what is out there.

I am able to use it. If I am able to use it, I would rate Microsoft Azure Synapse Analytics an eight 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
Senior Project Manager at a tech company with 501-1,000 employees
Real User
Easy to set up, good pricing, and fairly user-friendly
Pros and Cons
  • "The product is very user friendly."
  • "It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."

What is our primary use case?

Our general use case is for government purposes, and therefore, I really can't get into too much detail about it.

How has it helped my organization?

The solution is great at saving time. Overall, we spend far less time putting together static reports than we used to.

What is most valuable?

We're able to generate some dynamic reports. I find that very valuable to be able to see our data in such unique ways.

The pricing is pretty good.

The product is very user friendly.

What needs improvement?

After only using the solution for three months, we haven't yet really gotten into every corner of its capabilities. It's hard to say what might be missing in terms of features.

It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training. An organization should be able to adopt and operationalize it throughout their company with minimal training.

For how long have I used the solution?

I've been using the solution for three months at this point. It hasn't been too long.

What do I think about the stability of the solution?

The solution is quite reliable. We haven't experienced any problems with crashing or freezing and haven't really had experience with bugs or glitches. It's stable.

What do I think about the scalability of the solution?

The solution is scalable. A company shouldn't have issues expanding it out.

In our organizations, we have less than a dozen users, and those are mostly IT and IT management people.

How are customer service and technical support?

Technical support is okay. I'd rate them seven out of ten. We're satisfied with the level of support we are given.

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

We were searching for a solution. When we found it, we found something we could use, and then we just stuck with that. We didn't have a previous solution. We had nothing before.

How was the initial setup?

The initial setup is not complex at all. It's pretty straightforward. I'm not that technical, and I was able to handle it.

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

We've found the pricing to be fair. It's not too expensive.

What other advice do I have?

I'd recommend the solution to other organizations. If they have time, I would suggest a company spends more effort looking at some different offerings. That said, generally, if you don't have a whole lot of money to do something, it's a decent option.

We haven't used the solution for too long, however, it's offered us everything we need in terms of features and capabilities. On a scale from one to ten, I'd rate it at an eight.

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
Vice President Technologies at Excelencia
Real User
Easy administration, cost-effective, and scales to any requirement
Pros and Cons
  • "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."
  • "The configuration for things like high-availability could be more user-friendly for non-technical users."

What is our primary use case?

We are a software development company and this is one of the solutions that we recommend to our clients. The applications that we develop make use of this technology.

How has it helped my organization?

Using Azure SQL Data Warehouse means that you don't have to worry about big servers.

What is most valuable?

The best part is the easy and user-friendly administration and handling of the data.

What needs improvement?

The configuration for things like high-availability could be more user-friendly for non-technical users.

For how long have I used the solution?

We have been using Azure SQL Data Warehouse for almost twelve years.

What do I think about the stability of the solution?

This is a stable solution with no issues.

What do I think about the scalability of the solution?

Scalability is the best part of going with a cloud-based solution. I don't have to worry about server space. 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. What we propose to the people who are implementing this solution is to start with the minimum requirements and then scale up based on demand.

How are customer service and technical support?

We have not seen any problems with technical support. We have Microsoft certification, so we very rarely contact them for any help. Normally, we handle the support for our clients.

How was the initial setup?

The initial setup is straightforward. The requirements are very clear, and there is not much of a problem when you're doing it.

One of the recent upgrades we have done that included high-availability, loading the data, and setting everything up, took about a month and a half.

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

The licensing fees for this solution are on a pay-per-use basis, and not very expensive.

What other advice do I have?

The core strength of Microsoft technologies is ease of use and administration, regardless of the type of product.

This is a good solution to go with, the cost is reasonable, and I recommend it.

I would rate this solution an eight 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?

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Associate Manager at a consultancy with 501-1,000 employees
Real User
Easy to develop, stable, and subscriptions flexible
Pros and Cons
  • "We have found that it is easy to develop and to do the analytics in the modules of data."
  • "More integration is needed to improve the product for the future."

What is our primary use case?

We use the solution on our servers for analytics.

What is most valuable?

We have found that it is easy to develop and to do the analytics in the modules of data.

What needs improvement?

More integration is needed to improve the product for the future. There needs to be more flexibility when developing applications with this product.

For how long have I used the solution?

I have been using the solution for six months.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

We have three to four people using the product.

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

The solution is subscription-based. You can also pay to use the product as you go. This is an advantage, you only get charged for the time you actually use it.

What other advice do I have?

I would recommend this solution to others.

I rate Microsoft Azure Synapse Analytics a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Practice Head BI at a tech vendor with 1,001-5,000 employees
MSP
Good reporting and analytics, and can handle very large amounts of data
Pros and Cons
  • "The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
  • "With respect to what needs to be improved, concurrent connectivity has some limitations."

What is our primary use case?

We are a solution provider and we provide different tools for our clients. Microsoft Azure SQL Data Warehouse is one of the solutions that we have implemented.

The use cases vary depending on the client. We have a couple of clients who are moving their data from on-premises to Azure databases, and they are using this solution primarily for reporting analytics. They also use visualization tools on top of the reporting.

What is most valuable?

The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.

When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.

What needs improvement?

With respect to what needs to be improved, concurrent connectivity has some limitations. 

For how long have I used the solution?

We have been using Microsoft Azure SQL Data Warehouse for about one year.

What do I think about the stability of the solution?

This solution is stable.

What do I think about the scalability of the solution?

We are satisfied with the scalability.

A lot of people use the analytics and I would estimate it to be between 50 and 100 users. Most of them are business users, although some are power users who built the system for them.

How are customer service and technical support?

It is good technical support in general, we find. We were in contact with them when we were doing a migration from on-premises to the cloud, and it was very nice.

How was the initial setup?

The initial setup is straightforward.

What other advice do I have?

This solution is being changed from day-to-day. Now it has become Synapse Analytics and a lot of things are being added to it. I'm curious to see how that turns out. They have a lot of new integrations and features, including predictive analysis and big data integration. They may have solved the issues with concurrent connectivity, so I'm curious to put my hands on it.

The product is being upgraded and updated to support a lot of analytic features, and it is a great tool to use.

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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Director at Nihil Solutions
Real User
A great cloud-based solution but shifting between environments can be tricky
Pros and Cons
  • "The speed is great and the architecture is excellent."
  • "Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."

What is our primary use case?

There are around 10 people using this solution within our organization and we have plans to increase the usage. 

What is most valuable?

Microsoft Azure uses the Massively Parallel Processing concept for data warehousing. The speed is great and the architecture is excellent. 

What needs improvement?

Microsoft should develop an interface to make it easier to shift from on-premise to the cloud.

There needs to be a lift and shift tool to move on-premise, IMS high-volume data to synopsis sequence data on the cloud.

For how long have I used the solution?

I have been using this solution for two years.

What do I think about the stability of the solution?

The stability is okay, but it could be improved. I believe Microsoft is working on fixing this at the moment.

How are customer service and technical support?

We are satisfied with the technical support.

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

We used to use an AWF product, but Microsoft Azure is a better cloud-based solution compared to AWF.

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

Our license is very expensive.

What other advice do I have?

I would recommend this solution to other enterprises.

On a scale from one to ten, I would give this solution a rating of seven.

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: Integrator
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 2024
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.