How can we parametrize two different integration runtime in azure devops for synapse workspace.

Question

Hello,

We have two environment, dev and UAT. We have different integration runtime for dev and uat.
How can we parametrize inetgration runtime in devops pipeline.

We need to override below parameters

},
"connectVia": {
"referenceName": "Testingdev",
"type": "IntegrationRuntimeReference"
}
},
"dependsOn": [
"[concat(variables('workspaceId'), '/integrationRuntimes/Testinguat')]",
"[concat(variables('workspaceId'), '/linkedServices/cddev')]"

Thank You

Answer 1

Hi @Aakash Desai ,

Welcome to Microsoft Q&A platform and thankyou for posting your query.

As per my understanding your requirement is to override parameter for your self hosted Integration Runtime to replace it for the higher environment , in your case UAT environment.

For this requirement , you can use write a powershell script to replace any parameter for 'Integration Run time' Connection string and add a 'Run inline Powershell' task in your release pipeline to run the code .

 (Get-Content -path $(System.DefaultWorkingDirectory)/_SynapseRepo/annu-analytics/TemplateForWorkspace.json) -replace 'Testingdev','Testinguat ' | Set-Content -Path $(System.DefaultWorkingDirectory)/_SynapseRepo/annu-analytics/TemplateForWorkspace.json   

Here , you need to replace the path where '_SynapseRepo' should be replaced by the artifact name that you provided for release pipeline and 'annu-analytics' should be replaced with your synapse workspace name

Please refer to the following thread for more details: https://learn.microsoft.com/en-us/answers/questions/704741/index.html

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators