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

Question

I've seen discussions that hover around this in the past but never a direct solution (or "you can't do that"). I manage a Jenkins CI/CD system. We build and deploy SSAS Tabular and Dimensional models. We run DevEnv to build it, Microsoft.AnalysisServices.Deployment.exe /s to create a deployment script and then run the script.

The BI group has requested the ability to specify in the deploy configuration the credentials for the connection string and the impersonation user. Deployment.exe creates files that it appears could be modified to include the credentials but the MS docs don't give the actual schema/properties/values to use.

Anyone have any success doing this?

Answer 1

As per this and this, perhaps you could solve this by running the deployment wizard in answer file mode (/a switch) and tell the development team that they can provide their required settings by committing an answer file to source control and then your team could integrate this answer file into a pipeline with batch or powershell scripts.