Microsoft Azure Synapse Analytics Reviews

We are using this product data warehousing and analytics.

Pretty much all of the features are valuable, including storage and compute. All of the features are essential to what you do.

It's very reliable and cost-effective. It meets the needs of our clients.

It's user-friendly and has a good dashboard.

I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head.

I have been using Microsoft Azure Synapse Analytics for a couple of years.

It's a stable product and we're satisfied and comfortable with it. Our clients and partners have found it to be very stable and scalable, as well.

Synapse Analytics is a scalable product.

Generally, support from Microsoft is always good. I can't recall the specific instance where we had to contact them, but it was good.

The initial setup is very straightforward. It only took five minutes to set up.

We deployed the solution in-house, and we also deploy it for our clients.

This is a cost-effective product.

I highly recommend this solution to others, and we recommend it to our clients.

Overall, it's exceptionally good.

I would rate this solution a nine out of ten.

We are mainly using this solution as an interface between the Data Lake and the users.

We are consultants and this product assists with the services that we offer for our clients. Our company has a large number of consultants who are working in this space.

The most important feature for me is the integration with PolyBase.

Other valuable features for me are advanced threat protection and data privacy.

I would like there to be more focus on the Software as a Service (SaaS) product. For example, Snowflake, one of their competitors, is more focused on SaaS.

They need to improve a little bit in terms of user-friendliness. I would rate them a three out of five, in terms of how user-friendly the interface is.

The auto-scaling capabilities are quite poor, especially compared to Snowflake or Firebolt.

In total, I have been using Microsoft Azure Synapse Analytics for one year.

This is a stable solution.

You can scale it, although you need to put in more effort. We have approximately 800 users.

In general, Microsoft support is pretty good.

I have experience with similar products such as Snowflake and Firebolt.

The initial setup is very complex compared to other products. It takes weeks to deploy.

We implement this product for our clients.

The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte. The charge might be several thousand dollars or more each month.

There are multiple options that are available at an extra cost. For example, the advanced threat protection costs an extra $25 USD.

We evaluated several options before choosing Synaps Analytics.

The suitability of this product really depends on the use case. It is good if your company is using only Microsoft products and you don't want to use another stack. If you want to use other platforms then you should consider Snowflake, which is also deployed on Azure. It really depends on what it is that you need.

I would rate this solution an eight out of ten.

We haven't really implemented any SSIS. I haven't been in a project where it was implemented as part of the data we have been building.

The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.

So far, with the current SQL that I'm using compared to what we've previously used, I'm happy with it. I wouldn't necessarily point out anything that needs improvement.

From my point of view from what we have implemented recently, I'm happy with the solution, I'm happy with the performance. I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it.

I have been using this solution for around 18 months.

It is very stable.

I think the architectural design is very scalable.

I never contacted Microsoft customer support. 

We do have access to it, but we haven't needed to.

I've used Tableau, I've used SQL DB, I've used SAP DB.

The initial setup wasn't complex. It was okay. It wasn't complex at all.

To set it up within full compliance with our cloud infrastructure team, I'd say maybe two weeks after beginning our testing. I'd say the team wasn't a hundred percent devoted to setting it up as they had other things to do. So I'd say I'll give it two weeks to be realistic for a large organization.

It depends on whether you have those resources internally or not. If you have internal resources you wouldn't need to outsource, if you don't have, you would. So it's not a matter of how good that application is but a question of whether you have the capability in house.

The enterprise services are pretty expensive.

We have been using Microsoft Azure Synapse Analytics as our proof of concept in our data warehouse. As for the analytics part, we have not used it because we do not have any SQL pools. We think it is a bit more than we need because our data is not implicated and the data sets are not very large. It is mostly been used for the detection functions and to link up the sources.

The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services.

When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options.

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

The solution is incredibly stable. 

The only thing that has not been stable are the pipelines that we are using runtime integration on our on-premise server and something is slowing everything down, it might be a particular ODBC connection. I am not sure if that is due to the Microsoft platform or it might be some other setup or settings that are causing the issue. However, other than this issue, the solution has been brilliant. It has been very reliable and stable.

The solution is scalable. I have changed the interface and most of the operations can be done from the interface by clicking a few buttons, it is quick and easy.

At the moment we only have approximately four people using the solution because it is a data warehouse creation in the back end. We have not reached the stage where our staff will use the product but we are building a single customer view using the platform and we will be increase usage in the future.

The initial installation is straightforward. There is a lot of documentation provided by Microsoft making it very easy to get started.

Having used the serverless option for the database has saved us a lot of money.

We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month.

It is beneficial to always plan exactly what the main aims are and then choose the solution that can do it. If you want something quick, I set something up without any knowledge with Azure in three weeks. Once you get going, everything will be at your fingertips.

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

We are an IT service provider. We develop solutions for our clients and this solution is used in some aspects of that.

The dashboards are good.

We haven't had any issues when it comes to customization.

The security seems to be okay. It hasn't given us any problems and we don't feel insecure.

The pricing seems to be quite fair.

I know their roadmap, and I am looking forward to what they have already published.

We've been happy with the level of reporting and documentation on offer.

There aren't any features that are really lacking in the solution. We don't really have any issues with it in its current form.

When we used the on-premises deployment model, we had data latency issues and suffered from page performance problems. However, since we've moved to the cloud, we haven't had these problems.

The initial setup has a bit of a learning curve.

We've been using the solution for the past 18 months so far.

The solution seems to be scalable. We haven't had any issues with bugs or glitches. It doesn't crash or freeze. It's quite good.

The scalability has been pretty good, in our experience. We have been able to scale it twice to the number of users we needed. We were also able to double the amount of data load. We haven't had issues. If a company needs to expand, it should be able to do so without problems.

We've dealt with technical support and have found them to be quite responsive and knowledgeable. We're quite satisfied with the level of support we have been getting so far. They're helpful.

It's hard to gauge the difficulty or simplicity of the setup. For our company, we were learning the processes as we were doing it. In that sense, it was challenging due to the fact that we had to learn and then do. After a period of time, we were able to get comfortable.

We handled the implementation ourselves. We taught ourselves about the process as we went.

We pay a licensing fee on a monthly basis. We find the pricing to be fair among the competition.

We're just end-users and customers. We don't have a business relationship with the organization.

We're using the latest version of the solution right now.

I'd recommend the solution to other organizations.

I'd rate the solution at a nine out of ten.

We are using this solution for data warehousing and analytics.

Pretty much all of the features are valuable. The storage, compute, all essentially differentiate what you do.

They are very reliable and cost-effective. It meets the client's requirements.

It's user-friendly, has a good dashboard, and my team is happy with everything.

I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head.

I have been using this solution for a while, I would say approximately two years.

We are using the latest version. It's always updated on the cloud.

We found it to be a very stable product.

It's a scalable solution and we find it to be easy to scale.

Generally, support from Microsoft is always good.

I can't recall where we had an issue that we had to contact technical support, but the support is very good.

The initial setup was very straightforward. It took only five minutes to set up.

We completed the deployment in-house, we did it ourselves. We also implement it for our clients. 

It's pretty straightforward, we do not need help with this.

Because it's a cloud solution, the cost is a different convention and the licensing costs are not the same.

I would highly recommend this solution to others who are interested in using it. We recommend it to our clients.

It's exceptionally good, and our clients and other partners find it both stable and scalable.

I would rate this solution a nine out of ten.

We primarily use this solution for source analytics and procurement.

The most valuable feature of the solution is the analytics and that it can connect with Power BI. I found it quite interesting and very compelling in terms of detail within a single stack.

I would like my team to be able to build pipelines that integrate with the Azure Data Factory. Some of the best-in-class ETL products that are available in the market, such as Informatica ETL, are far more mature than this solution.

We started implementing projects with Microsoft Azure SQL Data Warehouse about six months ago.

This is a stable product.

Scalability is good and we haven't had any issues.

We have approximately 150 users. We are stable at the moment but we will expand our usage as we get more data.

We have contacted Microsoft support twice, but I do not have much experience with them.

In addition to Azure SQL Data Warehouse, we work with the version that is on-premises.

We are also working with Oracle Data Warehouse and we plan to continue using both of these solutions.

The initial setup is straightforward.

We implement this solution for our customers.

If you are using Microsoft products, such as Office 365, then this solution is good because it can take the data from multiple sources. 

This is a good product, but when you compare to Oracle Data Warehouse there are differences in scalability, high availability, and implementation.

I would rate this solution a seven out of ten.

This is a data warehousing solution.

The most valuable feature is the scalability. It scales out, so you can build a large database and not have to think about whether it performs, or about connecting to the servers to become larger.

There are several specific features and functions available on the on-premises version that do not work with the cloud version. There are many issues regarding migration.

They are building it more and more, but if you have the same version on local you cannot just go to the cloud because some of the functionalities don't work yet. You would have to re-code everything, and maybe even do it differently.

In terms of documentation, they can make it easier or start with some advising or instruction. As it is now, it's like making a puzzle.

Technical support needs some improvement.

They will need to include some features for the Cloud version.

They can make subsets of the database so you can schedule the marking department to work only between nine to five, but ETL can run at night. 

With a subset database, you can cut costs, similar to Snowflake whose price is a lot lower.

This solution is stable.

This solution is scalable.

We have a couple of administrations using this solution and the rest are indirectly using third-party tools. They are developers and administrators.

The support is difficult. I don't think that their support is good.

You can call for help, they take your request, but they don't have an understanding of the tool.

You have to wait a couple of days for someone to call you back.

There have been times where I knew more than they did, so you have to figure it out for yourself.

I am not satisfied with the support, but I do understand that when you have a service desk or a help desk, they cannot go through the entire solution. What I expect is that the second line should, but they don't have a second line.

You submit in a support ticket and three days later you get a callback and have to explain the problem that you are having again. It takes more time.

I have called Microsoft and even they were not sure and nobody could really help me.

The initial setup for me was straightforward, but I have a lot of experience. I think that for some people who are less experienced it would be complex.

It's not just the documentation on what version you need to have and what pricing. It is really difficult.

You have to read a lot to understand what you are doing.

This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version.

It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a loop that is running all night, you could receive a very expensive bill.

The bad side to pay as you go is that sometimes it can stop the enthusiasm of the data scientists, as they are afraid to run a query because they are afraid of the bill and how much it will be.

It's a nice solution for a simple data warehousing, but it's still an immature solution.

It is stable but it takes a lot of time. 

Smaller companies have better products, but the problem will always be there and the smaller company will not survive.

Customers will have tools that are not supported anymore.

Microsoft is so big that people trust them, they will eventually get there but it will take time to get the features with quality. There are, however, some solutions available that are better and cheaper. You can purchase them instead of having to reprogram everything that you have already done.

My advice would be to compare this solution with others. Snowflake would be a comparable solution. It's cheaper, faster, and better.

I would rate this solution a seven out of ten.