question

Deepal avatar image
4 Votes"
Deepal asked NandanHegde-7720 answered

When to use Azure Analysis Service vs Azure Synaptic Analysis

As I understand:
Azure Analysis Service is upgraded version of SQL server Analysis Service on the cloud.
Azure Synapse Analytic is upgraded version SQL DW + ML +Power BI that intergrates with ADLS + Data Bricks.

So it seems lik both have a significant overlap. If so why would I ever use a pipeline like this?
It sems Azure Synapse Analytics can do OLAP just as well. Why would would someone design a pipeline this way?

98362-image.png


azure-sql-databaseazure-synapse-analyticsazure-analysis-services
image.png (64.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
4 Votes"
NandanHegde-7720 answered

Hey,
Though both Azure synapse and Azure analysis services are olap system, there are multiple reasons why we still need AAS as below:
1) SQL dw being a mpp architecture,there is a restriction of concurrent users in SQL dw but not in Azure analysis services. So in case if there are reports with 500 users accessing simultaneously , in case of SQL dw there would be some queue involved for some users but this won't be the case for Aas.
2) there are multiple features in aas which helps in analytics easily like dax rather than having everything done in SQL ( which sometimes becomes difficult and that too at SQL dw where many normal tsql functions are not supported)

Though msft is gradually moving AAS towards powerbi premium model but we do need a model similar to aas rather than directly SQL dw for some better performance .

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.