Microsoft Azure Synapse Analytics Reviews

The solution's scalability is very, very good. It's one of the most important aspects for us. 

We really need our data to stay in Western Europe. As an insurance company, it's important for our business. Microsoft can guarantee that it stays in Western Europe. That way, data is not processed anywhere else.

It's widely acknowledged as an excellent product throughout the industry. There's a lot of knowledge about it in the Netherlands as well. It makes it very easy to find a consultancy and also employees who can help us with its modern architecture.

The initial setup is easy. You don't need extensive training. It's an intuitive process.

What I would like to see is a possibility for time travel on the data. For instance, a financial department would like to do an analysis of the data set as it was for the first of the month while another department wants to run the analysis about how things went yesterday or last week. They have different starting points for the queries. I've seen Snowflake handle tasks such as these. It's got a feature called time shuffling, which can show me what's there on a certain variety of dates. It's very convenient.

It would be great if we could query the data of the day as well as in the data warehouse. 

They should have scalable memory processor options for the data warehouse.

While the solution is flexible, sometimes this works against the user.

We're new to the solution. We started using it last year around April or May. It's been less than 12 months so far.

The solution is scalable. It's online. That means you can scale it online and can stop the database to change the scaling of it.

We've had a few calls with technical support. They were very helpful and responsive. We have been satisfied with their level of support.

The initial setup is very straightforward. It's not overly complex. A company shouldn't have any issues with the initial setup or implementation. You don't need deep technical insights to have training.

You can create a floor space in an hour. That's no problem. Afterward, you have to work with the data and do a few more things in terms of configuration, however, it's not hard.

We are using the latest version of the solution.

I would rate the solution at an eight out of ten.

I would recommend Synapse, however, it depends on which industry an organization is working in. It can be complex, and often, you have to choose between several tools. They're all able to do the same job, they're just more industry-specific in some cases. 

If you want to transform your data, you can choose between the database, data factory, and SQL, and even other tools.

This means it is very flexible, however, it also makes it difficult to administer. It's not that one of these sources is harder per se. It's more about what is the best for the job. Sometimes you create something and it doesn't perform and you have to start from scratch.

We are using it internally and afterward some of the outcomes are made public, either to customers or in different projects.

It's mainly for preparing internal documents when we use Word. Otherwise, we use it for externally or for a lot of PowerPoint and Excel for budget purposes. Being a small company, we don't need a very sophisticated software solution, so with an Excel spreadsheet, we can handle the different budget of different projects simultaneously.

When connecting one project to the other, especially when it's handled by the same project director, the possibility of linking one spreadsheet to the other has been useful. Also, when using a Word document and making a link to another document based on an Excel spreadsheet, that's very useful. It's also great that we can interrelate one document to the other and sometimes one project to the other.

The macro functions of Excel are very useful. 

The stability is pretty good.

The solution has the potential to scale.

The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them.

If the project keeps growing we will need to link some of the documents to the data warehouse. However, at that time, I'm not sure about the possibility of keeping the same systems that we are using right now. We may need some kind of migration. I cannot say for sure, as I am not an expert. We'll need advice on that.

The initial setup is not straightforward.

The solutions not user-friendly and does require training of some sort.

The solution requires a lot of the memory of the different devices.

We've been using the solution for a while. We use it pretty much every day and have used it over the past 12 months.

My intention is to increase productivity. As long as a project can still be handled the way they are, we will keep using the current system. If we see a better alternative with better productivity achievement, we will most probably think about migration. For now, we find it to be stable and acceptable.

We do plan to increase usage and we may hire a consultant to help with an expansion in a few months. This will likely happen, however, anything can change in terms of the business and the larger industry.

Scalability is good. I foresee scalability in terms of the possibility of using more features and the only difficult thing that I see already is the macros of the Excel spreadsheets. I also know that it has a good opportunity for scalability, in terms of the more complex tasks that can be achieved. 

Currently, we have ten people on the solution.

We use an outsourcing service for technical support. We've been satisfied with their level of service.

We haven't used a different product. We've always used Microsoft.

The initial setup is complex. It's not straightforward.

In many ways, implementation is a never-ending process, as there are always things to improve. In a few months, most of our people are familiar with the product and have a good sense of the basics, however, there's always more to do.

There was actually one consultant at the beginning of the project. We will also definitely need someone for future migration. However, it's not something that we are considering at present. It's something we'll need to do probably in the next few months. It will depend on the growth of the business.

The licensing is okay. There might be a few extra fees in addition to the standard license.

I'm just an end-user and customer.

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

I'd rate them higher if they could make it more user-friendly in terms of those more sophisticated capabilities that the system offers. Also, the training requires long hours. That's something difficult to organize when people have to be allocated to specific training sessions, instead of being on the projects. There's a kind of complex way of balancing the possibility of some people using the more sophisticated solutions and getting trained. 

We use the solution on our servers for analytics.

We have found that it is easy to develop and to do the analytics in the modules of data.

More integration is needed to improve the product for the future. There needs to be more flexibility when developing applications with this product.

I have been using the solution for six months.

The solution is stable.

We have three to four people using the product.

The solution is subscription-based. You can also pay to use the product as you go. This is an advantage, you only get charged for the time you actually use it.

I would recommend this solution to others.

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

I work for a consulting firm, with many different use cases.

Synapse DW is for traditional data warehousing with a large amount of volume, that requires you to do reporting.

In terms of Synapse Analytics, I haven't put it in yet, but I'm looking at it for kind of one-stop-shop or Swiss Army Knife type projects. They've been asking for a factory or creating something that connects to the cosmos to turn it into analytics reportings, just sort of needless connecting and just making it easy from a developer standpoint to deliver on any sort of business analytics that needs to be done.

I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics.

I think that there should be better governance. Actual pipeline level security, if you create a pipeline within the tool, because it's a one-stop-shop for everything, you control who has access to what, and that goes for anything, whether it's an internal or an externally managed table. 

I think there needs to be an improvement with support for external tables supporting Spark, but further support of Lakehouse to make it a true data warehousing product where you have this true separation of computes and you have a separation of storage. 

I think it kind of dips its toes in there, but in order to achieve, I think with a vision that Microsoft is doing, trying to get at to replace Bolt, but compete with Snowflake and Databricks at the same time, it needs to have those features on.

In the next release, I would like to see Lakehouse and better governance.

I have been using Microsoft Azure Synapse Analytics for six months and Synaps for a couple of years.

It's a very stable solution. We have not had any issues with the stability of it.

For its traditional data warehousing, it's scalable.

For Synapse Analytics, I am uncertain about being able to trust it with large volumes, which is what you would expect with Databricks.

There are only three or four people in our organization who do this type of work.

We directly work with Microsoft in everything, so they're very responsive for us and they're definitely very committed to that product.

It's a complicated product.

I am a consultant. I implemented the solution myself.

It's very difficult to price unless you know exactly how the customer is using it.

I would recommend this solution to others who are interested in using it.

I think it's definitely something that they should consider. It's come a long way from where it started. 

It's just finished out a public preview and it's great if you're looking to combine a lot of tools into one and you're running a smaller shop. I think it's a great tool.

I would rate this solution a seven out of ten.

Our primary use case is to process data and provide it to our clients.

The most valuable feature is data processing.

The architecture, including compute and storage, is good.

The performance and data consistency need to be improved.

Support for PSQL functionality should be included, as it is something that is missing right now.

I have used Microsoft Azure Synapse Analytics over the past 12 months.

The stability has been getting much better. Two years back, there were issues with it.

Scalability is something that is improving.

The initial setup is straightforward.

We deployed it ourselves.

I would rate this solution an eight out of ten.

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