Synapse Pipeline Configs, URL's - How to prep for production?

Question

Hi,

How do I prepare Synapse pipeline's for production? For example,

1. I am using a web activity to read a sceret from Key Vault. How do I change the URL when moved to prod? Notice in the URL - I have UAT https://company-keyvault-uat.vault.azure.net/secrets/SomeID?api-version=7.0

2. How about Linked Services which talk to storage accounts, SQL DB etc?

Answer 1

Sure @Giri, Seshu , Detailed article here - https://iterationinsights.com/article/azure-data-factory-ci-cd-with-devops-pipelines/ you can refer.

Please feel free to reach out if you need any explanation related same.

• Please don't forget to click on or upvote button whenever the information provided helps you.

Answer 2

Hello @Giri, Seshu ,
Thanks for the question and using MS Q&A platform.

I understand you want to parameterize the URL in a web activity for different environments.

I think the easiest solution, is to use Global Parameters, in this case.

A global parameter is made available to any and all pipelines in a Factory. When you change the value of a global parameter, it then affects ALL places it is used.
You can make the global parameters one of the things you set when doing CI/CD or moving dev -> test -> prod.

There are a couple ways you could use it. The most straightforward is to store the appropriate URL , and then reference it in the web activity like @concat(pipeline().globalParameter.KeyVaultURL , "secrets/SomeID?api-version=7.0) .

A more convoluted way, is to store a lablel indicating which environment this is. Then in the web activity URL you could put an expression like

@if(  
  eq( "prod" , pipeline().globalParameter.environment ),  
  "MyProdKeyvaultURL",  
  "MyDevKevaultURL")  

I personally recommend the simpler method.

There is a way to set the URL itself as something to parameterize in the ARM template, but this would effect ALL web activities, not just this one. Thus I recommend the global parameter route.

Please do let me if you have any queries.

Thanks
Martin

---

• 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

Answer 3

Hi @MartinJaffer-MSFT ,

I am using Synapse, there is no support for Global parameters. Any other idea?

Answer 4

Hi @Giri, Seshu you can achieve this by using release pipelines of Azure. You can add stages and pipeline variables based on the environment to achieve this.

Let me know if you need more details about creating release pipeline, also please accept the answer if this help.

• Please don't forget to click on or upvote button whenever the information provided helps you.