#AzureSQLDW: Hub and Spoke series Integration with Azure Analysis Services

Community Manager

Azure SQL Data Warehouse is Microsoft’s SQL analytics platform, the backbone of your Enterprise Data Warehouse. The service is designed to allow customers to elastically (and independently) scale compute and storage with massively parallel processing. SQL DW integrates seamlessly with big data stores and acts as a hub to your data marts and cubes for an optimized and tailored performance of your EDW. Azure SQL DW offers guaranteed 99.9% high availability, compliance, advanced security, and tight integration with upstream and downstream services so you can build a data warehouse that fits your needs. Azure SQL DW is the first and only service enabling enterprises to replicate their data everywhere with global availability in more than 30 regions. Today, we will show you how to push data quickly into Azure Analysis Services for optimized performance.

Benefits of using Azure Analysis Service with SQL DW

Several great benefits exist when leveraging Azure Analysis Services (AAS) with SQL DW:

  • Fewer to no queued queries while increasing the overall solution concurrency
  • Improved short query read performance with AAS as a caching layer
  • Reduce overall solution cost by lowering DWU levels for SQL DW with query offloading


Read about it in the Azure blog.

0 Replies