Microsoft Azure Synapse Analytics Reviews

We are ingesting data from different sources and using Power BI for reporting and decision-making for analytics.

It helps centralize our data and create one source of truth, helping us become a data-driven organization.

The fact that we can ingest from different types of sources, whether they are internal systems or external sources. It also offers insights and proposes what we can use with that data.

I wish the data governance feature could be incorporated without requiring an additional license.

We have been working with it for two to three years.

The stability of Synapse Analytics is rated as ten. It is very stable.

The scalability of Synapse Analytics is also rated as ten. It is meant for big data and is scalable based on how much we want to use.

If they have allocated a resource, like a task team to assist, then they do a good job. However, if you log a general call, it will take longer. Dealing directly with the account manager is quicker.

Neutral

We used products from other vendors before, but now we primarily use Microsoft.

It took about twelve months because of the complexities related to ingesting data from different sources.

Microsoft offered us a FastTrack team that guided us. From our side, six engineers took part in the deployment.

At this point, I cannot put the financial benefit.

It is not a cheap solution. That said, it is reasonable compared to its peers.

Overall, Microsoft Azure Synapse Analytics offers good integration, is user-friendly for data analysts, and helps in centralizing data.

I'd rate the solution ten out of ten.

Dealing with big data is the primary use case.

Its scalability and ease of use are valuable. It is fairly simple for a tool that's that powerful. If you have a background in Microsoft SQL Server, it is a very easy-to-transition path.

They should automate some of the features. There are some things, such as the creation of external tables, that you have to do manually. They should be automated.

In terms of additional features, they're adding new features all the time. They have new features faster than I can figure out what to do with them.

I have been using this solution for five years.

So far, it has been pretty good. In five years, it has had two failures, which is pretty acceptable from my standpoint. Those were more environmental failures.

It is pretty much infinitely scalable if you got the money to pay for it.

Currently, we probably have 600 or 700 users in the county. They are mostly data analysts and data scientists. As far as developers go, we probably have 15 developers working with it right now.

It is fairly simple. It is a fairly simple tool to set up. It is all just clicking buttons. There is nothing overly complex to the initial setup process.

In terms of maintenance, it is a cloud product. So, the updates happen behind the scenes.

It just depends on how big your instance is. It could be anywhere from 1,000 to 50,000 per year depending on how big your instance is. You pay based on how big you make your database. Essentially, they charge you per hour of usage.

I am generally very satisfied with it. So, I would definitely recommend it.

I would rate it a nine out of ten.

When this application is in use, it's utilized to extract data and observe its performance and behavior. It also helps to make adjustments to fine-tune the application.

Azure Synapse combines the strengths of SQL technologies for effective enterprise data management. So, essentially, it excels in managing enterprise data.

I'm not very certain about suggesting specific improvements, but Microsoft consistently introduces enhancements, approximately on a quarterly basis, which is commendable. It could be beneficial to focus on integration with various data sources and similar enhancements. I noticed they have already integrated Power BI, which is advantageous. These developments are gaining prominence, and perhaps incorporating generative AI and leveraging it could be part of their future plans. 

It also provides both serverless and dedicated resource models. Azure Synapse already incorporates SQL machine learning models to some extent, but I anticipate that it will offer even more comprehensive AI capabilities in the future.

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

Azure products are highly scalable, so I would rate it nine out of ten. 

It is good most of the time, but it can be improved.

Positive

Before Microsoft Azure Synapse Analytics, we used different technology but shifted mainly because of the scalability.

If the person has a general understanding and some basic knowledge of the subject, setting it up shouldn't pose a significant problem or challenge. I would rate the setup an eight out of ten.

There are multiple teams, each with their individual setups, while the overall backend configuration and maintenance tasks are handled by a dedicated team. This team might be a global team consisting of more than twenty members who manage these responsibilities.

Microsoft's pricing is relatively high, and it varies according to the extent of our usage. The pricing is directly tied to our consumption. This decision is ultimately a business choice.

There were tests conducted alongside Microsoft Azure, although Azure was the preferred partner for our organization. It's important to note that the choice isn't solely based on price or the best product; sometimes, it's driven by the existing setup running on a particular platform, leading to the selection of the best available option.

There is a need to analyze the business objectives and technical needs before making a decision. If Synapse aligns with your business goals and meets your data warehousing requirements, you can proceed. Additionally, it's advisable to conduct price and scalability assessments and perhaps carry out a small proof of concept (POC) using production data before making a final decision.

I would rate the solution an eight out of ten.

What I found most valuable in Microsoft Azure Synapse Analytics is that it's native only for Azure, so you get better performance and there's no issue. To explain further, many different types of data come, in particular, structured and unstructured data. For audit purposes, there's also unstructured data, so the most important aspect is that with Microsoft Azure Synapse Analytics, you have the capability of using both technologies, meaning that you can use or mix structured and unstructured data which is important. This can also be done in Hadoop, and on other platforms, so you have everything in one place. You don't have to worry about how to manage both structured and unstructured data and where to store information. With Microsoft Azure Synapse Analytics, you can take care of everything, particularly in Azure.

The solution also provides you with many features apart from analytics, for example, storage which makes it better.

An area for improvement in Microsoft Azure Synapse Analytics is its user interface. You can use it for analytical purposes, but its platform should be a little bit more user-friendly.

Another small point for improvement in Microsoft Azure Synapse Analytics is its stability. It's good currently, but it could still be improved.

Microsoft is combining different tools and technologies into one solution, so in the future, I'm expecting to see even more improvement in Microsoft Azure Synapse Analytics.

An additional feature I'd like to see in the next version of Microsoft Azure Synapse Analytics is the drag-and-drop feature. If you're doing some integrations where you can write Scala or you have SPARK programming or SQL, or you're combining different programming, the process should be seamless, and you should be able to drag and drop in Microsoft Azure Synapse Analytics. When doing reporting in the solution, you should also be able to drag and drop. There should be connectors available and a drag-and-drop feature available in the user interface of Microsoft Azure Synapse Analytics, so you won't have to worry about how all processes would work together. You need to be able to drag and drop even from the backend, and having this feature will make the solution more user-friendly.

I've been using Microsoft Azure Synapse Analytics for three years.

In my opinion, Microsoft Azure Synapse Analytics is stable. I would rate its stability seven out of ten.

As Microsoft Azure Synapse Analytics is on the cloud, it's scalable, and you won't have that many issues with scalability. If a solution is cloud-based, you won't have to worry about whether it's scalable or whether it supports other features, because you'd have all features in the cloud itself. You can scale up or scale down Microsoft Azure Synapse Analytics based on your requirement, so it all depends on what exactly you want. In the cloud, you won't have to schedule, wait, think, or plan. You can scale up or scale down automatically anytime.

I'm working on behalf of a vendor for the client, so my team is supporting not just users of Microsoft Azure Synapse Analytics within my company, but several other companies as well. Apart from supporting the infrastructure, data-related services, and other services, my team provides a combined type of effort for clients. My team is a big team with people working together from three different companies providing support for Microsoft Azure Synapse Analytics. My team provides technical support for the solution.

The initial setup for Microsoft Azure Synapse Analytics is straightforward because Azure makes it very easy. Any Azure solution is very user-friendly, but you just have to know how to use the solution, and that's it. Setting up Microsoft Azure Synapse Analytics is not that complex if you're knowledgeable.

I evaluated AWS, and if you compare Microsoft Azure Synapse Analytics with AWS, Azure excels more than AWS.

Amazon or AWS is established, and there's no doubt about it. It's also less costly in comparison with Microsoft Azure Synapse Analytics, but since I worked on both platforms, if you want everything where you have to pay a little bit, and you don't want to pay or invest in some other development areas, and you want certain features to be automatically available for you, apart from a lot of features to be available on any platform you use, then your choice should be Microsoft Azure Synapse Analytics. Amazon is a cloud provider only and relies mostly on open-source, but Azure has support from Microsoft which is an innovative company. Whatever product is offered by Azure, Microsoft support is there, and as a company, Microsoft is always very innovative, so a product such as Microsoft Azure Synapse Analytics is very useful and very user-friendly, which you won't get that much, at least for now, from Amazon. If Amazon wants to be comparable to Azure and have the same capabilities, then it will need to depend on some other companies. Whereas for Microsoft products, for example, GEO, it's native to the Microsoft platform, so it's comfortable to use, even though it's open-source and you're never sure of what type of problems could arise. Microsoft Azure Synapse Analytics, because it's an Azure or Microsoft solution, is more advantageous than AWS.

I'm an architect and I'm using Microsoft Azure Synapse Analytics, and apart from that solution, I'm also using other types such as Big Data, AIML, SPARK, and Scala. I'm also into other languages and reporting services.

I'm using the solution for my clients. Currently, I'm using it for clients, particularly Netherland-based banking institutions that have a cloud setup on Azure, but the deployment is now hybrid because of an ongoing migration. It's not completely migrated yet, so there's still something left in the data center. The clients have an ongoing migration from Hadoop and SD inSITE as well, which would be moved completely to Azure Cloud, so as of now, the deployment of Microsoft Azure Synapse Analytics is still hybrid.

My rating for Microsoft Azure Synapse Analytics is seven out of ten as it combines many different features that you can use, so it's a good solution, and in the future, I'm expecting it to be better and better.

Several teams use Microsoft Azure Synapse Analytics, but then in my team, around twenty-five people use it, but that's not the complete number of users. Many people use the solution, with different features being used.

I don't see a product comparable to Microsoft Azure Synapse Analytics that's available on the cloud. Currently, there's no comparison, so you can't say whether it's good or bad, though room for improvement in any product will always be there. Based on all the features of Microsoft Azure Synapse Analytics, my rating for it is seven out of ten, at the moment, there's no competition for the solution because I've not come across any other tool that's comparable to Microsoft Azure Synapse Analytics.

The good thing about Synapse is the scale factor. It can handle a lot more volume of data compared to Azure SQL. There is Azure SQL, and there is a SQL Data Warehouse, which is now called Synapse. SQL is for smaller databases, and SQL Data Warehouse (Synapse) is for larger databases. Performance-wise, if you process a huge amount of data, SQL Data Warehouse is good due to its parallel processing capability. It's scalable. 

The setup is pretty simple. 

It's stable. 

In Azure, when you do the scaling up, it is not totally simple. It takes time to scale up. It actually kind of rebuilds the database behind this when you scale. If I am utilizing 1,000 of what they call the Data Warehouse and you need 1,200, there is downtime required.

There is a limit on the number of concurrent queries to around 125 for Azure Synapse.

I've been using the solution for a while at this point. 

The solution is pretty stable. The dedicated pool is pretty stable. It can handle quite a heavy workload.

The product can scale. 

For one of my clients, it was used as an Enterprise Data Warehouse, so it has got all kinds of insurance functions, and users. It has got an underwriting team, it has got the actual team, it has got a claims operations team, et cetera. All the enterprise Data Warehouse users start consuming data while using the visualization tools like Boll-BI, and then MicroStrategy, et cetera.

The initial setup is not complex. It's pretty simple and straightforward. 

There was a pool of DBAs that maintain all the Data Warehouse on-premise and cloud. There were hundreds of databases, and this is just one of the databases added to that list. The DBA team is comprised of five to six DBA team members.

I'm not sure of the exact cost, however, it is around $100,000 a year. 

We are Microsoft partners. 

Potential customers should check out the ease of management. This solution is easier to maintain compared toother options. 

I'd rate the solution seven out of ten. There are some challenges related to this replication and then there is quite a lot of design thinking to be done.

The solution offers great flexibility and the resource availability is quite good. It's abundant in the market. 

The initial setup is very simple.

The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications.

Of course, it varies from use case to use case. Before we get into the implementation part, we have to validate the pros and cons of the architectural components as part of the design and development. Once that's clear, then we'll go for implementation. We might get into technical glitches, however, there are multiple ways to work around them by putting in the right architectural component, which can solve the problem. There is always a workaround.

We've had a couple of interactive sessions with Microsoft already. We have already recommended that they need to strengthen their presence in the data governance part, the data quality part, and then the metadata management, for example, data lineage. We need more data governance to give the flexibility to handle these data quality issues.

It would be great if they update their data features. 

We have been working with the solution for the past one and a half years.

The solution is mostly stable, however, we do experience glitches here and there. We do have solutions that ultimately correct the issue.

Azure cloud is very scalable and allows this product to scale as well. We can scale horizontally and vertically.

Technical support is so far, pretty good. It's solving the problem now. Some other clouds are coming in, such as AWS or Google Cloud. They'll eventually be much more competitive in terms of comparatively.

We have used hybrid architecture also. We used the storage part and we have used Snowflake also. Everything is available in one place so that the connectivity issues are solved and you get one component talking to everything. 

It's a very simple setup. it's not overly difficult at all. 

In terms of maintenance, it depends on the scope of coverage and other things. If it is a 24 by 7, we need a set of 14. Depending upon the service coverage and scope coverage, you'll need a certain amount of people. Even that depends upon the scope of the work also. Does the setup require monitoring, for example, or enhancements? Basically, it depends upon the type of contact, and what we get into the AMS projects in terms of the team composition.

While we do not have a business relationship with Azure, we are trying to become partners. 

Most of our implementations happen on Azure itself. Wherever we go, we take the solutions and we go to the other customers and we propose them. We tend to recommend this solution.

I'd rate the solution seven out of ten. There is a scope for improvement. Eventually, as they come across different case by case, they'll enhance things. Currently, what I see here is the data governance part is missing here from a development life cycle point of view.

We use the solution for data storage.

The product is easy to use, and anybody can easily migrate to advanced DB.

Adding more transformations and plugins to the solution is very important.

I have been using Microsoft Azure Synapse Analytics for 10 years.

I rate the solution’s stability a seven to eight out of ten.

Around 20 to 30 users, including developers and architecture engineers, regularly use the solution for migration purposes. For a small organization, fewer people would be required for the migration.

I rate the solution a seven to eight out of ten for scalability.

The solution provides good technical support. The support team's response time depends on the issue's criticality. They will call you back in two or three hours if the severity is high. If the severity is low, they will take more than 24 hours.

Microsoft Azure Synapse Analytics is a moderately priced solution. We pay a yearly licensing fee for the solution. If you get help from partners, it will be expensive for you.

Microsoft Azure Synapse Analytics is a cloud-based solution. Since we are migrating, the cost is high. We assume the cost will be reduced post-migration, increasing the company's profitability. Microsoft Azure Synapse Analytics will be more profitable for any company in the long run. I would recommend the solution to other users.

Overall, I rate the solution an eight out of ten.

Our company includes 50 analysts who use the solution on a daily basis to predict customer behavior. 

The solution's best feature is its predictive analytics. 

Integration with other vendors has limitations and could be improved. 

Integration of process analytics would be a nice addition that allows us to analyze efficiency. 

I have been using the solution for six months. 

The solution is stable. 

The solution is a web data warehousing and analytical platform built for enterprise environments, so it is definitely scalable. 

Technical support is very responsive and knowledgeable. 

I rate support an eight out of ten. 

Positive

We do not use other solutions because we operate in a Microsoft environment that is not expected to go to AWS.

The initial setup is complex and I rate it a four out of ten. 

The solution was implemented through a third-party vendor team. 

The solution has helped to predict sales and focus attention on enhancements that have improved the bottom line. 

I rate the ROI a six out of ten. 

I don't know specifics about pricing but I hear that it is quite expensive. For example, Power BI is not as expensive as this solution.  

The solution has superior modeling and predictive analytical abilities in comparison to Power BI. There isn't really an expectation that you would get these superior abilities in Power BI because the solutions have different purposes and use cases. 

I rate the solution an eight out of ten.