Microsoft Azure Synapse Analytics Reviews

My primary use case of this solution is as a data warehouse.

The most valuable feature of this solution is its filling of the gap between big data and classic data warehouses. As a solution, Synapse allows you to do almost everything. 

An area for improvement would be advanced analytics. The product also comes with a pretty steep learning curve, which could be improved. In the next release, I would like an improvement in internal security, which currently doesn't work at all.

I've been working with this solution for about two years.

Initially, the product had some issues with stability, but these seem to have improved with time.

Scalability is one of the main advantages of this solution.

Tech support is ok but more difficult tickets can take a long time to solve.

The setup was complicated because the data must be organized differently from the classic SQL database. There are also different techniques for query performance and managing caches, which makes the process more complicated.

Synapse is a very costly solution, and other products are available for less.

One of the main pros of Synapse is the ability to work with the classic data warehouse and the big data. Another is the ability to use the Spark engine for preparation. Before implementing this product, consider whether it will provide the results you want. If you are already using Microsoft products, Synapse is easy to integrate. I would score this solution as eight out of ten.

It is for business intelligence. We are gathering all the data from legacy systems and transforming the data. We are then pushing the data back towards Power BI.

The whole solution is interesting for us.

They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed.

I have been using this solution for a year.

It is quite stable.

We don't scale up because the current level is enough for our customers. Our customers are small and medium companies in Europe.

I don't use their support.

It is complex. There are too many products that we need to involve in its setup, such as data factory and machine learning, and they're integrated so intricately. You need to have quite good skills to work with this. You would need a partner. You cannot do it yourself. The deployment usually takes a month.

It requires a less expensive version because currently, not every customer is able to buy it. If it could have a smaller setup that doesn't require so many resources, it would be helpful, and we would be able to use it in more cases. We are a small country, and most of our customers are quite small businesses.

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

The most valuable feature of this solution is the ease of administration.

It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database.

The solution is quite stable and there are no problems in the database.

We haven't grown a lot so I am not able to say if the solution is scalable or not.

The initial setup was really easy and straightforward.

I will rate this solution an eight out of ten. Not a ten due to the lack of integration.

We use the private deployment model of this solution. 

The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS.

The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster. It takes a bit of time but once you're done, you're done. 

The simplicity is good, but it should be that anyone can use it. You shouldn't have to be technical because, with the way it is now, only a technical person who has had training can set it up. If you have a dashboard that anyone can use, it would be easier.

Scalability is great. It can go from zero to infinity. 

Their technical support is great. We have local support from distributors.

The pricing is okay. You can pay as you go. 

I would rate it a seven out of ten.