1. Home
  2. Cloud Data Warehouse Software
  3. Azure Synapse Analytics Reviews
  4. User Review of Azure Synapse Analytics
Satisfied DBA/Data engineer
November 30, 2021

Satisfied DBA/Data engineer

Vladimír Mužný | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Azure Synapse Analytics (Azure SQL Data Warehouse)

I am an independent developer using Azure Synapse for other companies. My company is machinery production oriented (i.e. automotive companies) so I'm used to [utilizing] the Synapse for statistics-driven quality control, some logistics stuff, etc.
  • The combination of SQL/unstructured data
  • Keeping things "complicated, but simple"; [heterogeneous] data formats seen as just SQL tables to business experts used to use Power BI, Excel, and any other traditional SQL-oriented BI tools
  • Integration options using "Synapse pipelines", the application of ADFs
  • The greatly integrated solution of independent things (Spark MPP cluster, MPP SQL Servers, ADFs) - all sitting under one roof. Great job!
  • Integration with super-fast, globally replicated data. I really appreciate the integration of NoSQL databases (namely Core API and Mongo API under Cosmos DB) with purely batch-processed BI data
  • I have no idea right now. But... Synapse Analytics are typically seen as batch-processing of source data. What about tighter cooperation with streaming features like Event Hubs?
  • It's actually hard to answer the question as it is built up, sorry. But imagine, you are used to [sending] paper letters to your customers. What are your spending [on] the letters? You have some imagination, however, but let's develop a simple chart showing your spendings related to any other spendings, or, more descriptively, compared with expected profit. Oh, my! Is it really so much? What about some e-mail campaign next time? We can talk about dozens of similar examples, folks. Until data is seen in graphical format, it's just some opinion on what's going on in our businesses.
  • Using Synapse Analytics as well as any other cloud resource needs a big change to the administrator's mindset. Basically, the cloud is not just about technical skills like "I love the MPP approach of data processing", but it is about, says, economies of operations. Scaling stuff up and down, pausing servers, this is what the utilization of the cloud is all about! Go and mention it to people!
N/A As a data processing expert I never needed official MS support :-)

Do you think Azure Synapse Analytics delivers good value for the price?

Yes

Are you happy with Azure Synapse Analytics's feature set?

Yes

Did Azure Synapse Analytics live up to sales and marketing promises?

Yes

Did implementation of Azure Synapse Analytics go as expected?

Yes

Would you buy Azure Synapse Analytics again?

Yes

Great integrated development for data transformation and analysis.
Basically, the billing is predictable, and this all about it.
The most frequent answer to questions like this should be... IT DEPENDS. Synapse Analytics has some role in its DNA. It's not dedicated [to] tasks like some OLTP with many reads, however. When we are talking about Azure Synapse, we are talking about modernized BI stuff with great capabilities to involve big data processing to reach deeper insights [into] our data.