Linked Service in Axure Data Factory

Question

Hello Team,

I have a production environment and a test environment. Whenever a new changes is being done, I have to modify the linked service (might be a blob storage / SQL database) in each and every data sets to the test environment and then on merging back, I should be pointing it to the production environment. Looks to be a tedious process and should be extra careful as we are dealing with the production. Instead of modify the accounts in the linked service, is there a any other approach ?

Answer 1

Hello @Monica Manoharan and welcome to Microsoft Q&A. Thank you for your question.

There are multiple options available to accomplish this. My assumption is that you have 2 Data Factories, one for test, one for prod. The test Factory has a repository integration. The prod Factory does not need an integration.

Perhaps the easiest one, would be to leverage Azure Key Vault. You can have 2 Key Vaults, one for test, one for prod. Both should have the same secret names.
The idea is to have everything the same between the two Vaults, so all that needs to change is the Key Vault linked service base URL. This way, one change propagates through all the other linked services.

Other options include the CI/CD methods,
Manual promotion with parameterized template,
Global Variables and parameterized linked services