SSAS Project Data Sources and Automated Deployment

• JohnnyDBA

  SSCertifiable

  Points: 6355

  More actions

  March 2, 2015 at 2:16 pm

  #301621

  We have an SSAS project that we want to auto deploy. I am not sure how to handle the external data sources in the project. This one in particular has a single external data source defined to Microsoft SQL Server.

  I would like to be able to change the data source based on the environment. In SSIS projects I can do this by setting up environments in the SSISDB and linking them to project parameters in the SSIS project but SSAS projects don't seem to have a similar mechanism.

  Can someone please advise me on how to handle this? I would like to be able to have the build/deployment agent pass in server / database information to the data source based on environment (dev, QA, production).

  The only way to automate this that I've discovered is to have an intermediary process that executes after the build that updates the generated .asdatabase and .configsettings files in the bin folder replacing the connection string information. This does not seem ideal.

  Thanks in advance