Azure Analysis Service: Process Tabular Model with SSIS

[Lidou_Cand]

Hello, I hope you are well. I know this is not the right place to discuss Azure Analysis Services but I have not found a forum for this product. I would like to process an Azure tabular model using SSIS but I am experiencing connection difficulties in SSIS. I think it should have a configuration to do in Azure Active Directory. Anyone have an idea on how to do this? A tutorial would help me a lot. Thank you

[GilbertQ]

Hi there

You would be best looking into possibly use the REST APIs for AAS

Or you could look at Christian Wade's AsPartitionProcessing which I am using to process, which can be found here: https://github.com/Microsoft/Analysis-Services/tree/master/AsPartitionProcessing

[Lidou_Cand]

Hello @GilbertQ 

Thank you for your help.

I will test the Christian Wade's AsPartitionProcessing.

Have you ever used it in a production environnment ?

[GilbertQ]

Hi there

I have been using in my production customers for about 2 years now with no issue. It just works!

I have even ported it into Azure using Azure Functions and Azure SQL Server serverless

[Lidou_Cand]

Hello @GilbertQ 

I hope you are doing well.

Hello,

This weekend I looked at Christian Wade's AsPartition solution.
I tried using it locally but encountered some implementation issues due to Active Directory rights.
Speaking of which, I think you have a lot of experience with Azure AS.
In the project I am working on, our data source is a SQL Server On Premise database.
On a therefore set up a data gateway to connect us to our Azure Analysis Service server.
I would like to have your opinion concerning the impersonal account to process the model.
I encounter security difficulties to process the cube with the MFA set up by the company.
- Should we create a special login - password account especially for the model process?
- Should we instead create Application Service Principal to process the model? If so, is it complicated to set it up?

From your experience, what is your opinion?

[GilbertQ · Accepted solution]

Hi there

Thanks for having a look into it.

What I have done is the following:
1. When creating the database connection I use a SQL account without any expiry on the account. This allows me to always be able to authenticate to the configuration database.
2. For connecting to the Azure AS to process the partitions, I have created a Service Principal which I then configured in Azure AS and within AsPartitionProcessing. I followed these steps to create and configure the Service Principal https://cloudblogs.microsoft.com/industry-blog/en-gb/cross-industry/2018/06/22/how-to-automate-proce...

[Lidou_Cand]

Hello @GilbertQ 

Thank you for your help.
I used a service principal and that works well.

[GilbertQ]

Thanks for letting us know it worked!

[Lidou_Cand]

Hello,

Thank you for your help.

I will see test this solution.

Thanks