Microsoft Azure Synapse Analytics Reviews

We are a software development company and this is one of the solutions that we recommend to our clients. The applications that we develop make use of this technology.

Using Azure SQL Data Warehouse means that you don't have to worry about big servers.

The best part is the easy and user-friendly administration and handling of the data.

The configuration for things like high-availability could be more user-friendly for non-technical users.

We have been using Azure SQL Data Warehouse for almost twelve years.

This is a stable solution with no issues.

Scalability is the best part of going with a cloud-based solution. I don't have to worry about server space. Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to. What we propose to the people who are implementing this solution is to start with the minimum requirements and then scale up based on demand.

We have not seen any problems with technical support. We have Microsoft certification, so we very rarely contact them for any help. Normally, we handle the support for our clients.

The initial setup is straightforward. The requirements are very clear, and there is not much of a problem when you're doing it.

One of the recent upgrades we have done that included high-availability, loading the data, and setting everything up, took about a month and a half.

The licensing fees for this solution are on a pay-per-use basis, and not very expensive.

The core strength of Microsoft technologies is ease of use and administration, regardless of the type of product.

This is a good solution to go with, the cost is reasonable, and I recommend it.

I would rate this solution an eight out of ten.

We are a solution provider and we provide different tools for our clients. Microsoft Azure SQL Data Warehouse is one of the solutions that we have implemented.

The use cases vary depending on the client. We have a couple of clients who are moving their data from on-premises to Azure databases, and they are using this solution primarily for reporting analytics. They also use visualization tools on top of the reporting.

The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.

When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.

With respect to what needs to be improved, concurrent connectivity has some limitations. 

We have been using Microsoft Azure SQL Data Warehouse for about one year.

This solution is stable.

We are satisfied with the scalability.

A lot of people use the analytics and I would estimate it to be between 50 and 100 users. Most of them are business users, although some are power users who built the system for them.

It is good technical support in general, we find. We were in contact with them when we were doing a migration from on-premises to the cloud, and it was very nice.

The initial setup is straightforward.

This solution is being changed from day-to-day. Now it has become Synapse Analytics and a lot of things are being added to it. I'm curious to see how that turns out. They have a lot of new integrations and features, including predictive analysis and big data integration. They may have solved the issues with concurrent connectivity, so I'm curious to put my hands on it.

The product is being upgraded and updated to support a lot of analytic features, and it is a great tool to use.

I would rate this solution a nine out of ten.

There are around 10 people using this solution within our organization and we have plans to increase the usage. 

Microsoft Azure uses the Massively Parallel Processing concept for data warehousing. The speed is great and the architecture is excellent. 

Microsoft should develop an interface to make it easier to shift from on-premise to the cloud.

There needs to be a lift and shift tool to move on-premise, IMS high-volume data to synopsis sequence data on the cloud.

I have been using this solution for two years.

The stability is okay, but it could be improved. I believe Microsoft is working on fixing this at the moment.

We are satisfied with the technical support.

We used to use an AWF product, but Microsoft Azure is a better cloud-based solution compared to AWF.

Our license is very expensive.

I would recommend this solution to other enterprises.

On a scale from one to ten, I would give this solution a rating of seven.

We use this solution for data warehousing. Specifically, we have an ERP that does not have a direct connection to our Power BI solution. This connection will exist in the future, but in the meantime, we use an ETL process to transport data out of the ERP into Azure SQL, and then from Azure SQL into Power BI. At that point, we can use the dashboard to display our information.

Our environment is a private cloud.

The most valuable features of this solution are its easy setup and ease of use.

The SQL functions are ok. I've been working with Microsoft SQL Server, MySQL, and PostgreSQL for a long time, and everything is good.

Technical support is very good.

There are several things that I would like to see improved with this solution, including:

• The price of this solution could be improved.
• I would like to see better integration with Active Directory, because we have had problems, and we still do.
• I expected that Microsoft would have had something out of the box for Office 365, but they do not.
• It is difficult to configure, especially if you have multiple domains.
• I would like to see a simpler interface for the Azure portal because it is kind of complicated.
• It would be nice to have better monitoring of the usage of the data inside Azure SQL. What we don't use could be achieved in cloud storage. This would allow us to cut down the price.
• Better customization would improve this solution.

The stability is perfect. We have no problem with this solution, and it has not gone down in three years.

This scalability of this solution is five out of five. It is easy to scale, although it is a bit pricey compared to the competition, even with the Microsoft discount that we get for being a big enterprise.

We have approximately three hundred users for Azure SQL. With respect to Power BI reporting that can run queries in Azure SQL, I think that there are thousands. We have no plans to expand at this time.

Technical support for this solution is amazing. I have contacted them once, and the response time was amazing. They actually developed something that I suggested in the dialog within two months.

We used Power BI before choosing this solution.

The initial setup of this solution is straightforward, with no issues.

The deployment took about three and a half months, although the time was not because of Azure SQL. It was our ETL tools that we used in-house during the deployment.

We have one cloud engineer, somebody from Microsoft that helps us from time to time, and someone from TPC who assists with the maintenance.

We used an integrator, TPC US, to assist us with our deployment, and I highly recommend them.

We have seen ROI, for sure, but I cannot provide any numbers.

This is a pricey solution.

This solution was my recommendation, and I made it because we are a big Microsoft customer and, as such, felt that the integration would be smoother. It probably was.

We did evaluate other options including Google Sheets, Google BigQuery, and another solution from Microsoft.

My advice for anybody researching this or a similar solution is to list the pros and cons, along with the price, and estimate your needs before starting the project. I would also suggest contacting support for Microsoft, Google, and Amazon. Finally, look into other, better-niched providers, like Teradata.

Scaling this solution is easy and the uptime is okay. It is easy to use, and the support is excellent. My biggest complaint is the cost.

I would rate this solution a nine out of ten.

We're using this solution for analytics and its modeling capabilities. It allows you to have your visualization on top of your synapse analytics. We are partners with Microsoft. 

I like that the overall deployment and integration is pretty fast and then you also have virtualization to Power BI so it's also quite cost-effective.

For improvement, I would like to see more connectors and better integration for Hadoop. There are currently limitations for Hadoop on-prem. I'd like to see better integration and more flexibility. 

I've been using this product for almost a year. 

This is a stable solution. We have four companies who are customers of this solution and we have a team that deals with any problems. 

The product is scalable. 

The technical support is very good. 

The initial setup is straightforward and takes around two hours. 

There is a license for Azure, and whether it's a monthly or annual payment depends on the agreement you have with Microsoft. A long-term plan is more cost effective. 

I rate this solution a nine out of 10. 

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.

Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across. 

I have been using Microsoft Azure SQL Data Warehouse for three years. 

It could be more stable. 

It is a Cloud platform and so it is easy to scale.

When it comes to first level support, most of the time it's not a technical issue, it's a configuration issue where data mismatches. I get support anytime I want. Within an hour I can get anybody on the call and get the issue resolved. They have a one-to-one support channel which we can email when we require assistance.

We installed Datawarehouse in a couple of minutes. However, the configuration based on our data models took time. It can take us weeks because that's where our optimization sits. Just tuning the parameters can take several days' at a time. 

The price of the package is not expensive and depends on how much it is used.

I would rate Microsoft Azure SQL Data Warehouse a nine out of ten. 

It is for business intelligence. We are gathering all the data from legacy systems and transforming the data. We are then pushing the data back towards Power BI.

The whole solution is interesting for us.

They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed.

I have been using this solution for a year.

It is quite stable.

We don't scale up because the current level is enough for our customers. Our customers are small and medium companies in Europe.

I don't use their support.

It is complex. There are too many products that we need to involve in its setup, such as data factory and machine learning, and they're integrated so intricately. You need to have quite good skills to work with this. You would need a partner. You cannot do it yourself. The deployment usually takes a month.

It requires a less expensive version because currently, not every customer is able to buy it. If it could have a smaller setup that doesn't require so many resources, it would be helpful, and we would be able to use it in more cases. We are a small country, and most of our customers are quite small businesses.

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