How to specify connection / impersonation string of user / password in SSAS CD?

Question

I have seen discussions that hover around this in the past, but there has never been a direct solution (or "you cannot do this"). I manage the Jenkins CD / CD system. We create and deploy SSAS tabular and dimensional models. We run DevEnv to create it, Microsoft.AnalysisServices.Deployment.exe / s to create the deployment script, and then run the script.

The BI team requested the ability to specify credentials for the connection string and the impersonation user in the deployment configuration. Deployment.exe creates files that, in its opinion, can be changed to include credentials, but MS documents do not provide the actual schema / properties / values ​​for use.

Is anyone successful?

Answer 1

For this and this , maybe you can solve this by running the deployment wizard in the answer file mode (/ a switch) and tell the development team that they can provide their required settings by transferring the answer file to the original control, and then your team will be able to integrate this response file into the pipeline with batch or command line scripts.