Microsoft Azure Synapse Analytics Reviews

 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 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.

The product is easy to use. 

One potential area for improvement could be the availability of an on-premises data lake implementation, as the product is currently only implemented in a cloud environment. 

Additionally, the possibility of integrating data from multiple sources could be beneficial. 

We have used Microsoft Azure Synapse Analytics for approximately three months.

The platform's scalability is similar to that of SQL databases. It requires developing components, implementing services, and performing other related tasks.

The initial setup process is straightforward. 

My advice would be to remain open to learning new things, particularly because working with Synapse Analytics requires a shift in mindset from traditional tools like SQL Management Studio to newer tools and approaches.

I rate it an eight out of ten. 

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.

The most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user.

There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics.

I have been using Microsoft Azure Synapse Analytics for approximately one year.

The stability of Microsoft Azure Synapse Analytics is great. It offers a high level of performance.

The scalability of Microsoft Azure Synapse Analytics is good.

The support from Microsoft Azure Synapse Analytics is excellent.

There is a steep learning curve to do the implementation.

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

The entire Microsoft Azure ecosystem is well connected and Microsoft has done well with the features.

My advice to others is to try out the solution, do your homework and research, and set up a POC environment.

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

We are using Microsoft Azure Synapse Analytics with multiple customers for data integration, data migration, and data analytics. I offer these services to my customers as part of my service organization called Edge Technologies.

Customers use the solution for analytics, such as forecasting reports. There are a lot of business cases, we customized them based on the customer.

The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud.

Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial.

I have been using Microsoft Azure Synapse Analytics for approximately nine months in production.

The stability of Microsoft Azure Synapse Analytics is good. However, there is a global transformation and consolidation happening.

Microsoft Azure Synapse Analytics is able to scale to the needs of our requirements.

The initial setup of Microsoft Azure Synapse Analytics is easy.

We only have to pay for what we use in the solution. It's easy for the customers. It's not more than some companies, not more than 300 to 400 users. They do not need to buy other license products, such as SAP B1, or analytics tools in the market, such as Tableau.

There is going to be competition in the market with the release of SAP Cloud Analytics.

The solution does not require maintenance because it is sized-based.

I would recommend this solution to others. I have evaluated the fact sheet on the solution.

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

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.