Data connector for Azure Analysis Services in Data Factory

Question

There are multiple domains TBM in the Azure Analysis Services. A master TBM is to be built which would be having the high level metrics from each domain TBM. A common taxonomy need to be pulled from the Azure SQL DB.

Is there any approach by which I can pulled the metrics from the Azure analysis services TBMs using DAX/ MDX and store that data in the Azure SQL DB.

Appreciate your time !!!

 

Answer 1

There are multiple domains TBM in the Azure Analysis Services. A master TBM is to be built which would be having the high level metrics from each domain TBM. A common taxonomy need to be pulled from the Azure SQL DB.

Is there any approach by which I can pulled the metrics from the Azure analysis services TBMs using DAX/ MDX and store that data in the Azure SQL DB. 

Answer 2

Hi Siddhesh,

I can see one way to copy data from Azure Analysis Services(AAS) to Azure SQL DB. You can use a custom activity in Azure Data Factory to connect to AAS (I found a blog that will help you explore that), read data and write to Azure SQL (refer this doc).

To read more about custom activity, please refer this doc.

Let us know if this helps. Else we can continue to probe in further.

---

MSDN

Answer 3

Hey Chirag,

Thank you so much for the response.  :)

This definitely looks like it would work.

But unfortunately, we are keeping the .NET code as last solution.

Do let me know if you have any more options apart from the .NET code like in datafactory.

When our tabular model was on IAAS, we used to connect using the SQL dB connector of Azure DataFactory via. open query and linked server. In the similar way, when we move the tabular model to PAAS, how can data factory be used to put that data in the Azure SQL database.

Answer 4

Hi Siddhesh,

I do understand. Unfortunately at present there's no connector for AAS within ADF. The only ways I can think of are using a custom activity or by using an Azure Function.

---

MSDN