Need to process SSAS on prem Model using ADF v2

Ravi Shukla 21 Reputation points
2021-02-05T14:05:38.967+00:00

Hi,

We have created SSAS tabular model and we are processing using agent jobs .
we have adf v2 for ETL process .

Problem :- we have to trigger manually agent job post adf pipeline finish .
and we need to automate cube processing using adf v2

please advice which is possible option adf v2 have to process ssas tabular model on prem server .

Azure Batch
Azure Batch
An Azure service that provides cloud-scale job scheduling and compute management.
345 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,999 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,297 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 32,911 Reputation points MVP
    2021-02-05T15:15:45.5+00:00

    Hey anonymous user ,
    Please refer the below link
    https://learn.microsoft.com/en-us/answers/questions/212042/process-a-ssas-via-azure-data-factory.html

    you can create a linked server across database and analysis instance and then execute tmsl scripts in the database instance via ADF

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.