question

MonicaManoharan-9413 avatar image
0 Votes"
MonicaManoharan-9413 asked MartinJaffer-MSFT commented

Linked Service in Axure Data Factory

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 ?

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered MartinJaffer-MSFT commented

Hello @MonicaManoharan-9413 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


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MartinJaffer-MSFT ,

Thanks for your detailed comment. May be I ll try to do the same and let you know if any other input is needed.

Regards,
Monica.M

0 Votes 0 ·
MartinJaffer-MSFT avatar image MartinJaffer-MSFT ManoharanMonica-0153 ·

I have converted my comment to answer. You can now mark it as accepted answer, if it solves your issue. @MonicaManoharan-9413

0 Votes 0 ·