Microsoft Azure Synapse Analytics Reviews

Our primary use case for Azure Synapse is as a data warehouse, for creation of data pipelines. It allows login into to one central workspace, manage our databases, and the entire warehouse. We can embed business intelligence (BI), using Power BI. This allows us to show visualizations all in one central place.

I think potential areas to improve on could be performance and if they offered a decoupled compute from storage kind of service that would be nice. But I don't think that is possible as it's a fundamental change in the underlying architecture and Microsoft won't make that decision easily. 

We have been using Microsoft Azure technology for the last 4-5 years, including Synapse.

As Synapse is hosted on the Azure cloud, it's very stable. 

The Azure Synapse service is highly scalable. 

The initial setup is very straight forward. Azure Synapse offers you one workspace where you can do everything, creation of your data warehouse, ETL pipelines using Azure Data Factory, Create storage and data marts. Also use Power BI for visualization. 

Before Synapse was available, all of these was offered as separate services and this is how a data warehouse was constructed. Synapse is one layer on top of this where we make use of one single workspace to initiate and manage the entire set of services that you need for creating and managing your data platform - Data Warehouses and marts using SQL Warehouse, ETL pipelines using Azure Data Factory, Data Lake using Azure Blob Storage, and it offers server-less SQL - meaning you can run queries without having to initiate an SQL database or SQL data warehouse instance. It also offers Spark compute to process non-structured data.

We are a Microsoft partner and have setup and built Azure Synapse based solutions for our manufacturing, energy and healthcare clients. We are very customer centric and build and manage solutions based on our clients needs. We recommend what the best technology stack is for them. 

If I hosted a Microsoft setup on premise, I would need to invest in licensing for different tools and services, SQL server, SSIS, SSRS, Power BI or SSAS. Compared to this if you use Azure Synapse, the return on investment is very high. You get rid of your hardware, licensing and you move to a subscription based pay as you use model. Your operational costs reduce and your optimization increases. Capital expenditure absolutely diminishes and you move to an OpEx model. 

Finally, the overall management of it is simplified as compared to on premise. This of course leads to high RoI. 

Azure Synapse is best for people who are already invested in Microsoft technologies, in particular those who already use Microsoft data warehousing services, including MS SQL-Server based data warehouse technology. For them, migrating to Azure is very straight forward and Synapse adoption stays easy. 

With Azure Synapse, there is no database installation, no licensing cost, no hardware setup, everything is available as a cloud service, you then pay for the service, pay only for what you use. 

With regards to pricing, as I said you pay for what you use. The amount of data you store and compute power contributes to your pricing. If I use Azure's blob storage, the pricing depends on how much I use. If I utilize Azure Data Factory, pricing depends on how much data I process through the ETL pipelines and so on.

For some customers we recommend Snowflake, for others Azure Synapse or Google BigQuery. In one of our cases we are building a solution with both Azure Synapse and Snowflake. 

We have approximately 20-25 team members with knowledge of Azure Synapse service capabilities. 

With regards to deployment and maintenance, an Azure Synapse based solution may need anywhere between 3-15 people. This depends on what type of warehouse and analytics you want to create, the number of reports and visualization. Typically a small team size would be of 3-4 people and a large team size would be of around 12-14 members.

I primarily use Microsoft Azure Synapse Analytics for data pipelining.

I like the openness and flexibility of Synapse Analytics, which allows for integration of various data sources. It supports using Azure functions to connect data sources and can utilize Python and Jupyter Notebooks. 

The integration within Azure allows for efficient data handling, using data lakes, and storage accounts. 

Overall, the product provides a seamless and adaptable approach to data processing and analytics.

One area that could use improvement is the possibility for offline capabilities. If Microsoft Azure Synapse Analytics could run on a laptop as a Docker image, it would allow for work without needing an online connection.

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

The stability of Microsoft Azure Synapse Analytics is very high. I rate it a ten out of ten.

In terms of scalability, I rate Microsoft Azure Synapse Analytics an eight out of ten. However, this rating is only a feeling as I have no experience with scaling this product.

The product is so good that I haven't had a need for technical support. Given my extensive experience in software development, I find the similarities between Azure and other Microsoft products beneficial.

Positive

Currently, I only work with Microsoft Azure as that's what my customer selected.

I learned everything myself and did the deployment without any external help.

The financial aspect, including pricing and cost reduction, is not something I focus on.

Overall, I would recommend Microsoft Azure Synapse Analytics to others. I'd rate the solution eight out of ten.

I use Synapse Analytics to process data for transformation, create external tables, restrict user access, and for reporting.

Synapse Analytics' best feature is its ability to process large files.

Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node. In addition, the integration with other solutions like Power BI and Azure SQL Database is very slow and leaves a lot to be desired. In the next release, I would like to see a feature to offload Synapse files directly into Gen2.

I've been working with Synapse Analytics for about a year.

Synapse Analytics is fairly stable.

I haven't seen any issues with scalability. 

Microsoft's technical support fails to give us solutions and leaves us to figure out the issue for ourselves.

Negative

The initial setup was straightforward.

I also evaluated Redshift from Amazon, which is much more stable than Synapse Analytics but takes a lot of effort to convert into ORC and load.

I'd give Synapse Analytics a rating of seven out of ten.

We use the solution for integration to enable the data to reuse it in the power gap.

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.

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.

I'm pretty new in the company. I started in January. However, they have been using this tool for two years.

The stability is great. There aren’t bugs or glitches and it doesn’t crash or freeze. It’s reliable.

The solution is scalable.

We have about 20 people using the solution in our company.

I haven't had any contact with technical yet, so I cannot evaluate their level of service.

The solution is easy to set up initially.

I’m not sure how much the solution costs.

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.

We use this solution as a data warehouse. Power BI allows us to visualize the data while analyzing data from the data lake through Serverless. We have not used too much of the pipelines within the Data Factory because we have an isolated Data Factory for that.

This is a stable solution with many functionalities.

The only issue that we have run into with the solution's performance is with regard to concurrency.

We would also like to see faster response times from support.

I have used this solution for three years.

The stability of this solution is good.

The solution is scalable. We currently have fifty to sixty people working within it and, now that we are using Serverless more often, we are planning to have more people working with it.

Support is good but they could be a bit faster replying to our tickets.

The initial setup was straightforward.

We had one admin complete the initial setup in ten to twenty minutes.

Price varies by use-case. You pay for the database itself in addition to any consumed data within Serverless plus other fees if you use the Data Factory that is inside.

I would recommend others to use this product but urge them to understand that it is more of a technical database used to prepare data as opposed to serving it.

I would rate this solution a seven out of ten.

We have implemented it for two solutions - data warehousing and BI Synapse (Business Intelligence). We also use it for merchandising, where based on our booking patterns, Synapse is used to analyze and target customers with more products. We use it for virtualizing, and BI is for analyzing business strategies.

The best thing about it is that it has integration at multiple places. It can talk to more than 90 types of data sources, which is one good thing about it.

There are some limitations based on the fact that it is a new platform. Some of our users have recommended switching to a different platform they are more familiar with. However, from an infrastructure standpoint, I believe it can be more secure in terms of availability.

Currently, even though we have locked down public access, the Synapse can still be viewed with the URL without VPN access. It only allows viewing the configuration and not any sensitive data or pipelines. We are working with Microsoft to address this issue, but it seems like they have recommended that it be open, and there is currently no solution. Perhaps there will be improvements in other aspects in the future.

We have been implementing and working with it for about a year now.

It's quite stable. So far, we haven't experienced any failures. If any failures occur, it will be due to the type of data or changes in it. But apart from that, the pipeline runs fine. We are getting our data reports that the team runs from Power BI. So everything seems to be stable so far.

We are premium customers. So, we have access to their top-tier team. I can say it's pretty good.

Positive

It was very complex, but we have grown out of it now. We have at least six environments only on Synapse.

This is the first solution that we are trying out. But if we plan to compare it with another solution called Snowflake, it will open up more dimensions for our thoughts to work. 

However, based on what we have achieved so far, I can rate it as an eight out of ten overall.

We are using Microsoft Azure Synapse Analytics with multiple customers for data integration, data migration, and data analytics. I offer these services to my customers as part of my service organization called Edge Technologies.

Customers use the solution for analytics, such as forecasting reports. There are a lot of business cases, we customized them based on the customer.

The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud.

Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial.

I have been using Microsoft Azure Synapse Analytics for approximately nine months in production.

The stability of Microsoft Azure Synapse Analytics is good. However, there is a global transformation and consolidation happening.

Microsoft Azure Synapse Analytics is able to scale to the needs of our requirements.

The initial setup of Microsoft Azure Synapse Analytics is easy.

We only have to pay for what we use in the solution. It's easy for the customers. It's not more than some companies, not more than 300 to 400 users. They do not need to buy other license products, such as SAP B1, or analytics tools in the market, such as Tableau.

There is going to be competition in the market with the release of SAP Cloud Analytics.

The solution does not require maintenance because it is sized-based.

I would recommend this solution to others. I have evaluated the fact sheet on the solution.

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

I use the solution in my company for graphs. We need graphs for some resources on Office 365. We also do a lot of stuff with other applications, specifically third-party applications. In Microsoft Azure Synapse Analytics, we use pipelines to manage the data from third-party applications.

I love the way Microsoft Azure Synapse Analytics works, and I can also manage Microsoft Fabric. I can gather all the information using Microsoft Azure Synapse Analytics on Microsoft Fabric, including areas revolving around reporting using Microsoft Power BI. I love the way all the application resources from Microsoft can synchronize, help me with a lot of stuff, and reduce the time or hour of having maybe a resource for an hour a day while also being able to use artificial intelligence.

In our company, we always want to improve our data management, including how to manage structured and unstructured data. Every day, we need to do a lot of stuff because we are a bank. We have reports from user accounts and client accounts. Eventually, I want to use machine learning bots, maybe since they can help our company.

I have experience with Microsoft Azure Synapse Analytics.

I am good with the tool's stability part. For stability, I would prefer Microsoft Azure Synapse Analytics over other tools. Stability-wise, I rate the solution an eight out of ten.

It is a scalable solution. Scalability-wise, I rate the solution a seven to eight out of ten.

I rate the technical support an eight out of ten.

Positive

To be able to manage the product's initial setup phase, I believe that you have to know a little bit of networking. On a scale of one to ten, if ten is the easiest, I rate the setup phase as a five or six.

Three people can deploy the solution. A developer, an administrator, and I, the vice president of technology, can deploy the tool.

The tool's on-demand query capabilities help enhance our analytical tasks. I like the way the tool works, as I have people doing queries and an analyst doing a lot of stuff in the product. I love the way that we can manage Microsoft Azure Synapse Analytics.

One person can maintain the tool.

I rate the tool a seven out of ten.