Microsoft Azure Synapse Analytics Review

The architectural design is very scalable but the services are expensive

How has it helped my organization?

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.

What is most valuable?

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

What needs improvement?

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.

For how long have I used the solution?

I have been using this solution for around 18 months.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

I think the architectural design is very scalable.

How are customer service and technical support?

I never contacted Microsoft customer support. 

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

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

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

How was the initial setup?

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.

What about the implementation team?

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.

What's my experience with pricing, setup cost, and licensing?

The enterprise services are pretty expensive.

Which deployment model are you using for this solution?

Public Cloud
**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,975 professionals have used our research since 2012.
Add a Comment
ITCS user