Azure Data Factory V2 how to process azure analysis service cube

Question

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?

score 4 · Accepted Answer · answered Feb 13 '18 at 03:57

4

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/

answered Feb 13 '18 at 03:57

Mark Kromer MSFT

3,578
1
10
11

Just keep in mind you need to enable the incoming firewall from the automation account into the SSAS cube, and the automation account could be on any number if different IP's – Nick.Mc Jun 08 '18 at 07:23

score 1 · Answer 2 · answered Nov 10 '19 at 12:32

1

My preferred approach for processing Azure Analysis Services from ADFv2 is to use built-in Web Activities along with the built-in MSI authentication. A sample can be found here.

answered Nov 10 '19 at 12:32

GregGalloway

11,355
3
16
47

Azure Data Factory V2 how to process azure analysis service cube

2 Answers2