Search code examples
azure-sql-databaseazure-analysis-servicesazure-data-factory

Azure Data Factory V2 how to process azure analysis service cube


In Azure Data Factory V2, how to process azure analysis service cube?

I am able to use Azure Automation Account to run runbook powershell script to process cube automatically. However, I want to add cube processing into my ETL process developed on ADF V2.

Can you please advise?


Solution

  • You can set-up a Webhook from the Azure Automation runbook and call that URL endpoint from an ADF pipeline Web Activity using POST method.

    Or, here is an example of processing AAS cubes using Web Activity, but calling a Logic Apps endpoint instead of an Automation Webhook (Thanks to Jorg Klein for this tip):

    https://jorgklein.com/2018/01/30/process-azure-analysis-services-objects-from-azure-data-factory-v2-using-a-logic-app/