Microsoft Azure Synapse Analytics Reviews

I am using Microsoft Azure Synapse Analytics with Snowflake.

The solution has been working well overall.

I have been using Microsoft Azure Synapse Analytics for approximately four years.

Microsoft Azure Synapse Analytics is stable.

I have not needed to contact the support, everything seems to work.

The solution could improve by having better costing information.

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

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. 

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 Microsoft Azure Synapse Analytics for analytics.

If I'm looking for something good in the cloud, I would want it to have better standard connectors.

I have been working with Microsoft Azure Synapse Analytics for two years.

We are up-to-date with the latest version.

I have been working with Microsoft, and they have been very helpful.

It's the only product I've used. I'm not sure what's wrong or what could be done better.

I don't know about the price, but I'm trying to get a sense of the cost. I believe having a good comparison would help.

This is the only product I've ever used, as such, it's extremely difficult for me to say anything about it. For example, if I needed a bike, and now I have one and am riding it. If you ask me some questions, it's difficult for me to say, "Oh, I really missed this one on my first bike," unless I've ridden a few bikes. I'm not sure why everything is the way it is. I had a need, and I'm only using it now.

I'm trying to understand what else is out there and how it compares to what is out there.

I am able to use it. If I am able to use it, I would rate Microsoft Azure Synapse Analytics an eight out of ten.

My primary use case of this solution is as a data warehouse.

The most valuable feature of this solution is its filling of the gap between big data and classic data warehouses. As a solution, Synapse allows you to do almost everything. 

An area for improvement would be advanced analytics. The product also comes with a pretty steep learning curve, which could be improved. In the next release, I would like an improvement in internal security, which currently doesn't work at all.

I've been working with this solution for about two years.

Initially, the product had some issues with stability, but these seem to have improved with time.

Scalability is one of the main advantages of this solution.

Tech support is ok but more difficult tickets can take a long time to solve.

The setup was complicated because the data must be organized differently from the classic SQL database. There are also different techniques for query performance and managing caches, which makes the process more complicated.

Synapse is a very costly solution, and other products are available for less.

One of the main pros of Synapse is the ability to work with the classic data warehouse and the big data. Another is the ability to use the Spark engine for preparation. Before implementing this product, consider whether it will provide the results you want. If you are already using Microsoft products, Synapse is easy to integrate. I would score this solution as eight out of ten.