Share via

Process a SSAS via Azure Data factory

Sahil Mehta 61 Reputation points
2020-12-28T10:06:47.793+00:00

We have a requirement wherein we need to process SSAS via ADF as the ETL operations is being done via ADF into an Azure SQL database

any help regarding this will be appreciated

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
440 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,803 questions
Accepted answer
  1. Nandan Hegde 29,911 Reputation points MVP
    2020-12-28T10:09:20.963+00:00

    Hey,
    you can create a linked server across a On Prem database instance and Analysis service instance and then execute TSQL on the database instance via ADF to process the cube.
    You can refer the below Doc :
    https://github.com/furmangg/automating-azure-analysis-services/blob/master/LinkedServer/SQL%20Linked%20Server%20to%20Azure%20Analysis%20Services.sql

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Siddhesh Khavnekar 1 Reputation point
    2021-02-05T14:01:25.007+00:00

    You can write a powershell script in Azure Function and call that Azure function from ADF v2.

    Powershell script can be found here -
    https://stackoverflow.com/questions/56934974/automate-process-ssas-tabular-model-using-azure

    Your TBM should have a MSMD Pump URL so that it won't have any connectivity issues.