Forum Discussion
Lidou_Cand
Helper III
Helper IIIAzure Analysis Service: Process Tabular Model with SSIS
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
- 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/
8 Replies
- GilbertQ
Super User
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_CandHello,
Thank you for your help.
I will see test this solution.
Thanks
- 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 ?
- GilbertQHi 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