Microsoft Azure Synapse Analytics Reviews

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.

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.

We are using the solution to process a large volume of data. We are taking advantage of the MTPP functionality feature in Azure Synapse Analytics and connecting our reporting dashboard to its dedicated support tool. These are the two primary use cases we are currently leveraging.

Generally, people have differing opinions on whether to use Azure Synapse Analytics or Azure Databricks. These are two different services from Microsoft, and customers often struggle to decide which is best suited for their particular use case. Both services have some features in common and some that are exclusive to one or the other. It is a trade-off and ultimately depends on the use case that best serves the organization. Incorporating the features of both Azure Synapse Analytics and Azure Databricks would meet most use-case scenarios.

The cost of the solution has room for improvement.

Azure Database has a very good Unity Catalog functionality, which is a form of governance within Azure Databricks. Similarly, for Azure Analytics, having a governance product would be great. However, Microsoft already has Azure Purview, which is meant for governance, but it would be nice to have that functionality built into Azure Synapse Analytics.

I have been using the solution for seven years.

The solution is stable.

The solution is scalable. Generally, the development team of around 20 people uses Azure Synapse Analytics directly. Otherwise, a Power BI dashboard accesses the Azure Synapse Analytics database, and the end user uses the Power BI reports, not being directly exposed to Azure Synapse Analytics. Only the development and software development teams use Azure Synapse Analytics.

We are always in contact with the Microsoft team. We keep up to date with our Microsoft reference architecture and other related matters through our communication with the Microsoft team members.

Positive

The initial setup is straightforward. We can have the dedicated SQL up and running within 15 minutes.

The implementation is completed in-house.

The cost of the solution depends on the type of license we choose, such as pay-as-you-go, one-year reserve, or three-year reserve. The cost varies depending on the options selected and can be very expensive.

I give the solution a nine out of ten.

Depending on the organization's use case, there are multiple options available. For example, if the workload is medium, there are different products available such as Azure SQL Database for small or medium-sized data, and Azure Synapse Analytics for extremely large volumes of data. Ultimately, it is the use case of the organization that will determine the need for these particular services.

We primarily use it for data transformation purposes, as well as for storing data. Additionally, we use it to connect to Power BI for reporting purposes.

We find the serverless tool the most valuable feature we're currently exploring.

One area for improvement could be better integration with Power BI, as well as data integration with BW. If we could find a connector or process to export data from BW into Azure, that would be helpful.

I have been using the solution for two years. I'm currently using the latest version.

We are just building the solutions, it's like the solution is very much immature. We are setting up those things. So as of now, it's not stable.

I would rate the stability a five out of ten.

The solution is very scalable. We are a medium-sized enterprise, and there are almost 4000 end-users.

We are getting good support from Microsoft.

Positive

I would rate the initial setup a seven out of ten. The initial setup was good.

We are currently working with around five or six people for the deployment. Moreover, about four or five people are needed for maintenance.

I would rate it a four out of ten, where ten is for most expensive.

I would recommend using Microsoft Azure Synapse Analytics because it includes everything from integration to transformation and storage.

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

We use Microsoft Azure Synapse Analytics in several scenarios, we require access to high-performance computing capabilities. This is where the solution proves to be a valuable asset as it offers a node-based solution for computing needs. In numerous cases, we have to undertake intricate data processing operations using the Python programming language, and that's where the solution comes in as an advantageous tool. These are my primary use cases for Synapse. Whenever we need to handle complex data engineering tasks or require significant computing power to accelerate processes, the solution provides the necessary functionality.

The most valuable features of Microsoft Azure Synapse Analytics are its serverless flexibility and complete power have allowed me to explore various different use cases. While I am not an expert in the product, my experience in programming in Databricks has shown me that Microsoft's investments in Synapse could potentially lead to it becoming a complete replacement for Databricks in the future.

In the future, Microsoft Azure Synapse Analytics has the potential to enhance its capabilities by expanding its connectors, specifically with regard to Oracle solutions, such as operating systems. This would involve a comprehensive approach to adding more connectors for both data input and consumption purposes. By doing so, Microsoft Azure Synapse Analytics would be better equipped to meet the diverse needs of its users and achieve greater efficiency in its performance. The provision of more connectors is definitely a crucial area that needs improvement.

I have been using Microsoft Azure Synapse Analytics for approximately two years.

I have not had any stability or performance issues.

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

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

Before adopting Microsoft Azure Synapse Analytics as my solution of choice, I delved into several other options. One of these alternatives is Snowflake, which I must admit, is a superior choice compared to Microsoft Azure Synapse Analytics. However, it is essential to take into consideration the consumption side when evaluating these solutions. If the consumption side involves Oracle solutions, then an autonomous warehouse would perform better than this solution. On the other hand, if the consumption is within the Azure platform, this solution presents itself as a commendable solution.

I rate the initial setup of Microsoft Azure Synapse Analytics a seven out of ten. 

We have a team that does the implementation.

The solution is worth the cost for our use case, it is worth the money. Despite the fact that there may be room for further optimization of its complete power, the cost-to-flexibility ratio of Synapse is quite favorable. I do not have any specific metrics to support my statement, however, I can assure you that Synapse is not inadequate or disappointing in any manner.

Microsoft Azure Synapse Analytics can be costly, however, a cost-effective approach would be to purchase it in advance through reservation for either one or three years. This will significantly reduce the overall expenses incurred.

After thoroughly evaluating various data management platforms, such as Oracle Autonomous Warehouse, Databricks, Microsoft Azure Synapse Analytics, and Snowflake over the course of the past year and a half, I have come to the conclusion that flexibility is crucial when it comes to choosing the right tool. Microsoft Azure Synapse Analytics stands out as a strong contender, as it offers a unique combination of both traditional warehouse capabilities and modern technological advancements. This combination of features makes Microsoft Azure Synapse Analytics a valuable option and is impressive.

My advice to others is to start with a reserved instance in order to test the waters and make sure it fits their needs before fully committing to using the solution. If, after experimentation, they decide to proceed with using Microsoft Azure Synapse Analytic over its competitors, then I would highly recommend going for a reserved instance to make the most cost-effective and efficient choice.

I rate Microsoft Azure Synapse Analytics an 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 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.