Microsoft Azure Synapse Analytics Review

Good analytics and integration with Power BI, but the ETL capability is far behind other products

What is our primary use case?

We primarily use this solution for source analytics and procurement.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

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

What do I think about the stability of the solution?

This is a stable product.

What do I think about the scalability of the solution?

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.

How are customer service and technical support?

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

Which solution did I use previously and why did I switch?

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.

How was the initial setup?

The initial setup is straightforward.

What about the implementation team?

We implement this solution for our customers.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Microsoft Azure Synapse Analytics reviews from users
...who work at a Computer Software Company
...who compared it with Snowflake
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: July 2021.
523,372 professionals have used our research since 2012.
Add a Comment
ITCS user