Microsoft Azure Synapse Analytics Reviews

We are ingesting data from different sources and using Power BI for reporting and decision-making for analytics.

It helps centralize our data and create one source of truth, helping us become a data-driven organization.

The fact that we can ingest from different types of sources, whether they are internal systems or external sources. It also offers insights and proposes what we can use with that data.

I wish the data governance feature could be incorporated without requiring an additional license.

We have been working with it for two to three years.

The stability of Synapse Analytics is rated as ten. It is very stable.

The scalability of Synapse Analytics is also rated as ten. It is meant for big data and is scalable based on how much we want to use.

If they have allocated a resource, like a task team to assist, then they do a good job. However, if you log a general call, it will take longer. Dealing directly with the account manager is quicker.

Neutral

We used products from other vendors before, but now we primarily use Microsoft.

It took about twelve months because of the complexities related to ingesting data from different sources.

Microsoft offered us a FastTrack team that guided us. From our side, six engineers took part in the deployment.

At this point, I cannot put the financial benefit.

It is not a cheap solution. That said, it is reasonable compared to its peers.

Overall, Microsoft Azure Synapse Analytics offers good integration, is user-friendly for data analysts, and helps in centralizing data.

I'd rate the solution ten out of ten.

We use the solution for data storage.

The product is easy to use, and anybody can easily migrate to advanced DB.

Adding more transformations and plugins to the solution is very important.

I have been using Microsoft Azure Synapse Analytics for 10 years.

I rate the solution’s stability a seven to eight out of ten.

Around 20 to 30 users, including developers and architecture engineers, regularly use the solution for migration purposes. For a small organization, fewer people would be required for the migration.

I rate the solution a seven to eight out of ten for scalability.

The solution provides good technical support. The support team's response time depends on the issue's criticality. They will call you back in two or three hours if the severity is high. If the severity is low, they will take more than 24 hours.

Microsoft Azure Synapse Analytics is a moderately priced solution. We pay a yearly licensing fee for the solution. If you get help from partners, it will be expensive for you.

Microsoft Azure Synapse Analytics is a cloud-based solution. Since we are migrating, the cost is high. We assume the cost will be reduced post-migration, increasing the company's profitability. Microsoft Azure Synapse Analytics will be more profitable for any company in the long run. I would recommend the solution to other users.

Overall, I rate the solution an eight out of ten.

When this application is in use, it's utilized to extract data and observe its performance and behavior. It also helps to make adjustments to fine-tune the application.

Azure Synapse combines the strengths of SQL technologies for effective enterprise data management. So, essentially, it excels in managing enterprise data.

I'm not very certain about suggesting specific improvements, but Microsoft consistently introduces enhancements, approximately on a quarterly basis, which is commendable. It could be beneficial to focus on integration with various data sources and similar enhancements. I noticed they have already integrated Power BI, which is advantageous. These developments are gaining prominence, and perhaps incorporating generative AI and leveraging it could be part of their future plans. 

It also provides both serverless and dedicated resource models. Azure Synapse already incorporates SQL machine learning models to some extent, but I anticipate that it will offer even more comprehensive AI capabilities in the future.

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

Azure products are highly scalable, so I would rate it nine out of ten. 

It is good most of the time, but it can be improved.

Positive

Before Microsoft Azure Synapse Analytics, we used different technology but shifted mainly because of the scalability.

If the person has a general understanding and some basic knowledge of the subject, setting it up shouldn't pose a significant problem or challenge. I would rate the setup an eight out of ten.

There are multiple teams, each with their individual setups, while the overall backend configuration and maintenance tasks are handled by a dedicated team. This team might be a global team consisting of more than twenty members who manage these responsibilities.

Microsoft's pricing is relatively high, and it varies according to the extent of our usage. The pricing is directly tied to our consumption. This decision is ultimately a business choice.

There were tests conducted alongside Microsoft Azure, although Azure was the preferred partner for our organization. It's important to note that the choice isn't solely based on price or the best product; sometimes, it's driven by the existing setup running on a particular platform, leading to the selection of the best available option.

There is a need to analyze the business objectives and technical needs before making a decision. If Synapse aligns with your business goals and meets your data warehousing requirements, you can proceed. Additionally, it's advisable to conduct price and scalability assessments and perhaps carry out a small proof of concept (POC) using production data before making a final decision.

I would rate the solution an eight out of ten.

What I found most valuable in Microsoft Azure Synapse Analytics is that it's native only for Azure, so you get better performance and there's no issue. To explain further, many different types of data come, in particular, structured and unstructured data. For audit purposes, there's also unstructured data, so the most important aspect is that with Microsoft Azure Synapse Analytics, you have the capability of using both technologies, meaning that you can use or mix structured and unstructured data which is important. This can also be done in Hadoop, and on other platforms, so you have everything in one place. You don't have to worry about how to manage both structured and unstructured data and where to store information. With Microsoft Azure Synapse Analytics, you can take care of everything, particularly in Azure.

The solution also provides you with many features apart from analytics, for example, storage which makes it better.

An area for improvement in Microsoft Azure Synapse Analytics is its user interface. You can use it for analytical purposes, but its platform should be a little bit more user-friendly.

Another small point for improvement in Microsoft Azure Synapse Analytics is its stability. It's good currently, but it could still be improved.

Microsoft is combining different tools and technologies into one solution, so in the future, I'm expecting to see even more improvement in Microsoft Azure Synapse Analytics.

An additional feature I'd like to see in the next version of Microsoft Azure Synapse Analytics is the drag-and-drop feature. If you're doing some integrations where you can write Scala or you have SPARK programming or SQL, or you're combining different programming, the process should be seamless, and you should be able to drag and drop in Microsoft Azure Synapse Analytics. When doing reporting in the solution, you should also be able to drag and drop. There should be connectors available and a drag-and-drop feature available in the user interface of Microsoft Azure Synapse Analytics, so you won't have to worry about how all processes would work together. You need to be able to drag and drop even from the backend, and having this feature will make the solution more user-friendly.

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

In my opinion, Microsoft Azure Synapse Analytics is stable. I would rate its stability seven out of ten.

As Microsoft Azure Synapse Analytics is on the cloud, it's scalable, and you won't have that many issues with scalability. If a solution is cloud-based, you won't have to worry about whether it's scalable or whether it supports other features, because you'd have all features in the cloud itself. You can scale up or scale down Microsoft Azure Synapse Analytics based on your requirement, so it all depends on what exactly you want. In the cloud, you won't have to schedule, wait, think, or plan. You can scale up or scale down automatically anytime.

I'm working on behalf of a vendor for the client, so my team is supporting not just users of Microsoft Azure Synapse Analytics within my company, but several other companies as well. Apart from supporting the infrastructure, data-related services, and other services, my team provides a combined type of effort for clients. My team is a big team with people working together from three different companies providing support for Microsoft Azure Synapse Analytics. My team provides technical support for the solution.

The initial setup for Microsoft Azure Synapse Analytics is straightforward because Azure makes it very easy. Any Azure solution is very user-friendly, but you just have to know how to use the solution, and that's it. Setting up Microsoft Azure Synapse Analytics is not that complex if you're knowledgeable.

I evaluated AWS, and if you compare Microsoft Azure Synapse Analytics with AWS, Azure excels more than AWS.

Amazon or AWS is established, and there's no doubt about it. It's also less costly in comparison with Microsoft Azure Synapse Analytics, but since I worked on both platforms, if you want everything where you have to pay a little bit, and you don't want to pay or invest in some other development areas, and you want certain features to be automatically available for you, apart from a lot of features to be available on any platform you use, then your choice should be Microsoft Azure Synapse Analytics. Amazon is a cloud provider only and relies mostly on open-source, but Azure has support from Microsoft which is an innovative company. Whatever product is offered by Azure, Microsoft support is there, and as a company, Microsoft is always very innovative, so a product such as Microsoft Azure Synapse Analytics is very useful and very user-friendly, which you won't get that much, at least for now, from Amazon. If Amazon wants to be comparable to Azure and have the same capabilities, then it will need to depend on some other companies. Whereas for Microsoft products, for example, GEO, it's native to the Microsoft platform, so it's comfortable to use, even though it's open-source and you're never sure of what type of problems could arise. Microsoft Azure Synapse Analytics, because it's an Azure or Microsoft solution, is more advantageous than AWS.

I'm an architect and I'm using Microsoft Azure Synapse Analytics, and apart from that solution, I'm also using other types such as Big Data, AIML, SPARK, and Scala. I'm also into other languages and reporting services.

I'm using the solution for my clients. Currently, I'm using it for clients, particularly Netherland-based banking institutions that have a cloud setup on Azure, but the deployment is now hybrid because of an ongoing migration. It's not completely migrated yet, so there's still something left in the data center. The clients have an ongoing migration from Hadoop and SD inSITE as well, which would be moved completely to Azure Cloud, so as of now, the deployment of Microsoft Azure Synapse Analytics is still hybrid.

My rating for Microsoft Azure Synapse Analytics is seven out of ten as it combines many different features that you can use, so it's a good solution, and in the future, I'm expecting it to be better and better.

Several teams use Microsoft Azure Synapse Analytics, but then in my team, around twenty-five people use it, but that's not the complete number of users. Many people use the solution, with different features being used.

I don't see a product comparable to Microsoft Azure Synapse Analytics that's available on the cloud. Currently, there's no comparison, so you can't say whether it's good or bad, though room for improvement in any product will always be there. Based on all the features of Microsoft Azure Synapse Analytics, my rating for it is seven out of ten, at the moment, there's no competition for the solution because I've not come across any other tool that's comparable to Microsoft Azure Synapse Analytics.

Dealing with big data is the primary use case.

Its scalability and ease of use are valuable. It is fairly simple for a tool that's that powerful. If you have a background in Microsoft SQL Server, it is a very easy-to-transition path.

They should automate some of the features. There are some things, such as the creation of external tables, that you have to do manually. They should be automated.

In terms of additional features, they're adding new features all the time. They have new features faster than I can figure out what to do with them.

I have been using this solution for five years.

So far, it has been pretty good. In five years, it has had two failures, which is pretty acceptable from my standpoint. Those were more environmental failures.

It is pretty much infinitely scalable if you got the money to pay for it.

Currently, we probably have 600 or 700 users in the county. They are mostly data analysts and data scientists. As far as developers go, we probably have 15 developers working with it right now.

It is fairly simple. It is a fairly simple tool to set up. It is all just clicking buttons. There is nothing overly complex to the initial setup process.

In terms of maintenance, it is a cloud product. So, the updates happen behind the scenes.

It just depends on how big your instance is. It could be anywhere from 1,000 to 50,000 per year depending on how big your instance is. You pay based on how big you make your database. Essentially, they charge you per hour of usage.

I am generally very satisfied with it. So, I would definitely recommend it.

I would rate it a nine out of ten.

It can be used for reducing hardware expenses.

It is a highly stable solution and it's easy to use. 

The security performance and cost are the two things that needs improvement. 

I have been using Microsoft Azure Synapse Analytics for eight years. 

It is a stable solution.  

It is a scalable solution.  

The initial setup is easy. It does not take much time to deploy the solution. 

You have to go to the resources and the security SSC group and the system for deployment. It can be done in-house. 

We have a licensing cost to pay. 

Overall, I would rate the solution a nine out of ten. 

The intention is for the company to utilize Microsoft Azure Synapse Analytics for analytics purposes. The team manages numerous databases and utilizes them to handle multiple tasks.

The most advantageous aspect of Microsoft Azure Synapse Analytics is its simplified data transformation process compared to traditional databases. This makes data cleansing and transformation more manageable and straightforward, which we appreciate. It is much easier to build as well.

The support and price could improve.

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

The stability is great.

I rate the stability of Microsoft Azure Synapse Analytics a ten out of ten.

The solution is scalable.

We use the solution intermittently, approximately 50 percent of the time.

We have approximately 1,500 users using the solution.

I rate the scalability of Microsoft Azure Synapse Analytics a ten out of ten.

The level of support from Microsoft Azure Synapse Analytics is average because it takes some time to reach the appropriate person, causing delays. Although we eventually connect with the right person, the initial representative assigned to the call is often unqualified to provide the necessary assistance. They simply repeat what is already available on the website, which we are capable of accessing ourselves. Our goal is to obtain a reliable technical solution, and the turnaround time from the point of contact to receiving a response is longer than ideal. This delay applies to both L1 and L2 support.

I rate the support of Microsoft Azure Synapse Analytics a five out of ten.

Neutral

The initial setup took us two weeks at the beginning and now we can do it in less than one week.

The initial setup of Microsoft Azure Synapse Analytics is straightforward.

We accomplished the deployment of the solution by ourselves with the assistance of two architects and four DevOps professionals.

Microsoft Azure Synapse Analytics is an expensive solution and there is a license needed to use it. My company has an enterprise license.

I rate the price of Microsoft Azure Synapse Analytics

We have four DevOp engineers that do the maintenance of the solution.

If your data models are not accurate, and if you are not well-versed in data transformation and model security, the process will be extremely challenging. Thorough planning is essential for the data to be properly managed. You cannot simply execute or implement the process by reading about it. A significant amount of planning is required, including how the data flows will access the data, data security measures, data flow processes, and transformation requirements. All of these aspects must be carefully examined and planned beforehand to avoid complications later on.

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

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.