Effective tool for relational data
November 07, 2020

Effective tool for relational data

Prabhu Sundararaj | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

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

Our clients belong to the energy and utility sector. I am a data engineer involved in migrating on-premises SQL data warehouse to Azure Synapse Analytics (Azure SQL Data Warehouse) to reduce costs and improve the data availability. Our existing on-premises system fetches enormous, unstructured data from HDFS and it required a tremendous amount of time to process the data. The effective polybase method in Azure Synapse Analytics (Azure SQL Data Warehouse) helps us satisfy our clients.
  • Massively parallel processing system reduces the bottleneck while loading the data from the source
  • Dynamic data masking helps us to secure the data
  • Automated indexing and alerts help us to rectify issues before they reach the business
  • Limited T-SQL query library
  • It is not suitable for OLTP environment
  • Doesn't support cross-database queries
  • Pay only for what you use
  • Software updates and patching taken care by Azure team
  • We can pause while the system not in use and it will cost only for storage

Do you think Azure Synapse Analytics (Azure SQL Data Warehouse) delivers good value for the price?

Yes

Are you happy with Azure Synapse Analytics (Azure SQL Data Warehouse)'s feature set?

Yes

Did Azure Synapse Analytics (Azure SQL Data Warehouse) live up to sales and marketing promises?

Yes

Did implementation of Azure Synapse Analytics (Azure SQL Data Warehouse) go as expected?

Yes

Would you buy Azure Synapse Analytics (Azure SQL Data Warehouse) again?

Yes

When using ELT loading source data into blob storage, we can directly load into the data warehouse with help of ploybase. The assively parallel processing engine helps us to save data directly in logical and physical partitions without going to control nodes. This prevents bottleneck while loading data from source to database.

Azure Synapse Analytics (Azure SQL Data Warehouse) Support

I am happy, the Azure team has strong customer support. They have an effective customer forum and weekly summits to encourage and establish their features and they support us in deep dives into the tool to utilize many benefits from it. They have 24/7 support and whenever we have issue they promptly resolve the tickets.

Using Azure Synapse Analytics (Azure SQL Data Warehouse)

It helps us to provide data just in time to our clients. With help of massively parallel processing, it consumes less time for both loading and querying the data and it also helps us to plan a more precise budget to our business and send just-in-time alerts in case of any outrage.