Microsoft Azure Synapse Analytics Reviews

We have a huge amount of data, and we need a platform where we can process the data using Spark clusters. We wanted an environment that included databases that are capable of parallel processing, and Azure Synapse was one of the best for that.

This product has given us a lot of processing power with the database, and at the backend as well.

The most valuable feature is the level of processing power, and being able to complete tasks in parallel. This is the feature that attracts us the most because we have a lot of data that we need to process in a short time.

This is a user-friendly environment.

Integration with other products is an area that can be improved.

I have been working with Microsoft Azure Synapse Analytics for between five and six months.

Synapse definitely seems like a stable product.

Synapse Analytics is deployed in a cloud environment and one of the best advantages of this is that it provides scalability.

I have not had any experience with Microsoft technical support.

I also have experience with the services available on AWS.

Configuring this solution was easy.

We implemented it with our in-house team. I was part of the team, one of my colleagues was the solution architect, and we have some engineers that assisted us. It was a team effort.

The costs are billed such that we pay for what we use, which is a good thing. For example, we have an environment where we don't need access to certain services, so we don't have to pay for them.

Compared to the services available on AWS, this solution is a little bit pricey.

At this point, Synapse Analytics is fulfilling all of our requirements for the use cases that we have.

I would rate this solution a seven out of ten.

We use Microsoft Azure Synapse Analytics for analytics.

If I'm looking for something good in the cloud, I would want it to have better standard connectors.

I have been working with Microsoft Azure Synapse Analytics for two years.

We are up-to-date with the latest version.

I have been working with Microsoft, and they have been very helpful.

It's the only product I've used. I'm not sure what's wrong or what could be done better.

I don't know about the price, but I'm trying to get a sense of the cost. I believe having a good comparison would help.

This is the only product I've ever used, as such, it's extremely difficult for me to say anything about it. For example, if I needed a bike, and now I have one and am riding it. If you ask me some questions, it's difficult for me to say, "Oh, I really missed this one on my first bike," unless I've ridden a few bikes. I'm not sure why everything is the way it is. I had a need, and I'm only using it now.

I'm trying to understand what else is out there and how it compares to what is out there.

I am able to use it. If I am able to use it, I would rate Microsoft Azure Synapse Analytics an eight out of ten.

It is useful for Azure services. I am using its latest version.

Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution.

The ability to integrate with different Azure services from within the Synapse Analytics workspace is also valuable.

Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better.

I would like to see support for cross-DB queries.

I have been working with this solution for three years.

Its stability is an issue because they're still upgrading the Synapse Analytics workspace.

It is scalable to a certain limit. It is not as scalable as Snowflake, but it is scalable.

There are many available versions of Azure Synapse, such as Azure Synapse SQL Datawarehouse, Azure Synapse Analytics, and Azure Synapse Analytics workspace. You need to be aware of the features that you are looking for and accordingly choose the offering.

I would rate it a five out of 10.

I am using Microsoft Azure Synapse Analytics with Snowflake.

The solution has been working well overall.

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

Microsoft Azure Synapse Analytics is stable.

I have not needed to contact the support, everything seems to work.

The solution could improve by having better costing information.

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

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.

Microsoft Azure Synapse Analytics can be used for analytics and brings together data integration.

The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit.

Microsoft Azure Synapse Analytics can improve querying. I have recently used Microsoft Azure Synapse Analytics to connect to the Delta Lake file and I have noticed some issues. It has not been able to read the latest version of the Delta Lake file and I have found this to be a disadvantage that they can improve.

In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks.

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

On the client's side, there are approximately 100 users of this solution.

Have I reached out to Microsoft technical support in a few instances and we have raised a couple of tickets. A couple of agents have been knowledgeable, but not everyone is.

The installation of Microsoft Azure Synapse Analytics was easy. It was not complicated, but I have not explored the VNet Injection or the Private Endpoint though I think it would be straightforward.

We are on a monthly payment plan for the use of Microsoft Azure Synapse Analytics.

We have done some comparisons between Microsoft Azure Synapse Analytics in many areas, such as processing queries, versus Databricks. We have found Databricks to be better in performance.

I would recommend this solution to others. The client that I am working for, their preferred database is Synapse.

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

The solution is generally used as more of an Analytical Data Warehouse. It's more of an offline enterprise scale. Sometimes I've used it from a marketing perspective, as a marketing data platform. I've not really used it from a risk and the enterprise center as it tends to be more back office, and therefore less around the customer, and more around the finance procurement of HR risk and that type of thing.

The solution is scalable.

It's better than a similar solution offered by Amazon.

Technical support is okay in terms of the help they provide.

The product could be easier to use. For example, I find Snowflake more user-friendly. They should offer simpler operations.

The initial setup could be faster.

Technical support can get expensive as they charge per use. The product could do more around crowdsourcing to help users find answers or answer questions without having to resort to contacting technical support directly.

The product could be more feature-rich.

They should look at some of what AWS and Snowflake are doing. They've both got a feature stack and also push the integration of things. This is a little bit lacking with Azure.

The analytics side of the solution is pretty weak right now. 

I have used this solution for a while. I used it before it was even called Synapse - when it was just Azure SQL Data Warehouse. It's been three or four years.

Technical support is okay, however, it can get expensive. The more you use it, the more it costs. I do not like this particular model.

I also have experience using Snowflake. I use both products. I originally started using Snowflake in 2017.

The solution takes longer to set up than I would like. There are a lot of questions that need to be addressed with the customer, and this can draw out the process. 

You do have to pay more the more you use technical support.

Clients have had a free year and then a monthly cost that they need to pay for licensing and access.

I don't use it personally, as I'm a consultant. However, if I implement it for clients, I do use it.

I'd rate the solution at a seven out of ten. There's still some work that needs to be done on the product that can make it a lot better.

I would recommend the solution to a company if they were a Microsoft shop. In that case, it's the obvious thing for them to do and it's a good choice.

We have implemented our data warehouse on Synapse.

The solution has been reliable so far.

The product is scalable, or, at least, that is my understanding. 

We've had a good experience with technical support in general. They are helpful. 

The solution has proven to be very user-friendly.

Right now, we are really struggling with the performance. it's not as good as we had hoped. 

I cannot recall coming across any missing features. 

One problem is that getting the query cost is not easy. I need to use multiple tools. It can be accessed through the web, or we have Azure Data Studio, or SSMS, and I only get the query cost in SSMS, the SQL Server Management Studio. In other tools, I'm not getting it. For example, in the web version or in Azure Data Studio, it is not available. They need to make it accessible in both of those places as well. 

I haven't used the solution for very long. 

The performance on offer is lackluster. We were hoping for better. 

That said, it is reliable, and if I get the required performance, I am happy with it. 

While I haven't really tested the scalability, it is my impression that the solution can scale and it shouldn't be an issue for any company to do so.

Technical support is good. They are helping us in improving the performance. We're quite satisfied with the level of service they are offing us. They are helpful and responsive. 

I did not handle the initial setup. That was handled by another party. Therefore, I don't have any insights into the process or how easy or difficult it was to implement. 

I don't have any insights into the licensing process. It is implemented on our client's side, and therefore, I'm not involved in that.

We're just customers and end-users. My company does not have any relationship. It's our client who has a relationship with Microsoft.

I'm not sure which version we are using, however, I would guess it is the latest version. I'm not 100% sure.

Since the solution is still new to me, and I am having issues with performance, it's too early to say if I would recommend the solution to other users or companies. 

I'd rate the solution at an eight out of ten.