Microsoft Azure Synapse Analytics Reviews

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.

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.

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.

I mainly use Synapse Analytics to gather data, do aggregations, and generate reports.

Synapse Analytics' best features are notebooks, pipelines, and monitoring.

An improvement to Azure Synapse would be more templates for specific domains. 

I've been using Synapse Analytics for four months.

Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets.

Synapse Analytics is definitely scalable.

Microsoft's technical support is fast and responsive.

Previously, we used Databricks.

The initial setup was straightforward, and I would rate the experience as 4.5 out of 5.

We're getting a good ROI from Synapse Analytics.

I understand that Synapse Analytics' pricing is lower than Informatica's.

I also evaluated Informatica Cloud Integrations but felt that Synapse was more straightforward.

I would give Synapse Analytics a rating of nine 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 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.