Forum Discussion
Azure Analysis Service: Process Tabular Model with SSIS
- 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-processing-your-azure-analysis-services-models/
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
Hello,
Thank you for your help.
I will see test this solution.
Thanks
Hello GilbertQ
Thank you for your help.
I will test the Christian Wade's AsPartitionProcessing.
Have you ever used it in a production environnment ?
- 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 serverlessHello 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?
