Microsoft Azure Synapse Analytics Reviews

We use Microsoft Azure Synapse Analytics for a combination of a data warehouse with some advanced capabilities, to allow us to run some machine learning models on top of it. 

The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable.

Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions.

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

Microsoft Azure Synapse Analytics is stable.

The scalability of Microsoft Azure Synapse Analytics is very good.

We have approximately 40 people using the solution. We have plans to increase our usage in the future.

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

Neutral

I did not use another solution prior to using Microsoft Azure Synapse Analytics.

The initial setup of Microsoft Azure Synapse Analytics is straightforward. The full process took a couple of weeks when we started and finished.

We did the implementation of Microsoft Azure Synapse Analytics in-house.

We have a cloud services team with approximately three or four people and they take care of everything we need to support Microsoft Azure Synapse Analytics.

It's difficult to compute a return on investment in data analytics.

The price of Microsoft Azure Synapse Analytics can vary. Other solutions are typically fixed prices and a fixed cost regardless of usage, but this solution is based on usage or consumption.

The best comparison for Microsoft Azure Synapse Analytics would be with or against Snowflake. The only difference is that Microsoft Azure Synapse Analytics is more modular. If you want to build something very complex, you can. However, if you want to do something simple, you could stick with easy-to-use, more integrated platforms, such as Snowflake.

My advice to others is they should leverage other Azure components if they can. If they are looking for an integrated solution that's easy to use, they should look at competitors.

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.

The use case depends on different things. For example, for banking, it would be risk management, fraud, and anti-money laundering. For retail, it would be an omnichannel customer experience. For sales, it could be upsell, cross-sell, retention. It's different for every industry.

The solution is like a marketplace in that it's easy to consume. 

It's scalable; you can scale up and scale down.

The standard things that you see from any cloud perspective make it very attractive.

It is easy to set up.

We'd, of course, always like to pay less for the service if we can.

I've been using the solution for a few years. 

The solution is stable. There are no bugs or glitches and it doesn't crash or freeze. It's reliable. 

I work for Accenture, so there are hundreds and thousands of customers on Microsoft.

The solution scales very well. You can scale up or down as required. It's very easy.

I don't really interact with technical support, so I can't really comment on their level of service.

I don't think it's very complex to implement. We have our own expertise. We have our own IPs to set it up and therefore it's not really complex. It takes a week to ten days to have everything up and running. 

Typically, a pool of six or seven people should be good enough in terms of handling deployment and maintenance. Usually, it's comprised of a mix of managers, admins, engineers, and/or developers.

Maybe it takes over a period of two or three years to see an ROI of maybe 50% to 70%. 

I don't deal with the licensing aspect of the solution. 

I'd recommend this solution to other users. 

I'd rate the solution eight out of ten.

 I'm a senior consultant.

For those working in the retail sector, this product can capture all the transactional data throughout a company's stores, process them, and put them into the Azure Synapses. Once you have the data, you can clean and aggregate it. On top of that, it has a reporting tool so you can connect to those Data Warehouse Synapses and pull up your reports which can then be used to prepare the dashboards and enable more insight.

Non-structured data is unavailable with this product. 

The solution is stable. 

Azure Synapse is serverless architecture, so you can scale as and when required. It makes no difference if there are 100 users or 1,000 users. We have around 50,000 end users.

The customer support is generally quite good. They follow up relatively quickly although it can sometimes take more time if it requires an SOP to follow up. 

The initial setup is straightforward. It's a matter of connecting to your visual studio or management studio.

It's important to understand your business needs and choose an appropriate solution based on the industry you work in and what needs to be achieved. There are a lot of tools available on the market, it's important to get the right one. 

I rate this solution eight out of 10.

We are using Microsoft Azure Synapse Analytics to find some evidence or outlier in our analysis about the application of the public health service and public money in the sector in Brazil. We are a public institution that is responsible for auditing other public institutions. We use these kinds of tools to find some evidence and outliers to audit with a little bit more documents or evidence.

The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment.

The interface of the solution is good.

Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great.

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

We encountered data processing and transformation issues while working with Apache Spark languages for the product. This particular area needs improvement. 

The product's error messaging could be friendlier. Additionally, the monitoring process using Azure ML SDK and Python should depend on the data for the results. Along with the documentation, they should provide essential training for proficiency in CLI. It will help in better monitoring.

We have been using Microsoft Azure Synapse Analytics for two years.

The product is expensive.

I rate Microsoft Azure Synapse Analytics a seven out of ten. It is a fantastic product; we are satisfied with its features and performance. However, there could be more information available about the platform.

It's used for business case analysis and bandwidth utilization, etc. 

We are using its latest version.

It's feature-rich. It has a wide range of features. 

It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes.

I've been using this solution for more than four years.

It's quite stable. I'd rate it an eight out of ten in terms of stability. There are very few outages or errors during the configuration.

It's scalable. I'd rate it an eight out of ten in terms of scalability. Our clients are enterprises. 

I haven't contacted them, but it should be fairly good. I haven't had many issues with it.

I'd rate it a nine out of ten in terms of the setup. It has a GUI, which is awesome. Its deployment duration varies based on the case to case. We have quite a few SMEs for deployment. 

It doesn't require many people for maintenance.

It has been good so far. I'd recommend it to others. I'd rate it an eight out of ten.