question

AhsanKhawaja-4410 avatar image
0 Votes"
AhsanKhawaja-4410 asked KranthiPakala-MSFT commented

Dynamically changing self hosted IR's via Advance JSON

109799-changeshirdynamically.pngHi,

I have 2 self hosted integration runtimes in different data centres across different countries, I am trying to switch self hosted IR "on fly" using Advance JSON properties of Linked Service, I am able to pass all parameters with success accept the SHIR itself ("connect via" the one in bold) which does not seems to be working, are there any way outs ? can you change the name of SHIR dynamically? Many Thanks

{
"name": "OnPremiseSQL",
"type": "Microsoft.DataFactory/factories/linkedservices",
"properties": {
"parameters": {
"keyvault": {
"type": "string"
},
"secretname": {
"type": "string"
},
"SHIR": {
"type": "string"
}
},
"annotations": [],
"type": "SqlServer",
"typeProperties": {
"connectionString": {
"type": "AzureKeyVaultSecret",
"store": {
"referenceName": "AzureKeyVault",
"type": "LinkedServiceReference",
"parameters": {
"KeyVault": {
"value": "@linkedService().keyvault",
"type": "Expression"
}
}
},
"secretName": {
"value": "@linkedService().secretname",
"type": "Expression"
}
}
},
"connectVia": {
"referenceName": "@linkedService().SHIR",
"type": "Expression"

}
}
}



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

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

Hi @AhsanKhawaja-4410,

Welcome to Microsoft Q&A forum and posting your query.

As per my understanding you are trying to parameterize the Integration runtime with in your liked service.

Unfortunately it is not possible to parameterize Integration runtime in a linked service currently. And I don't see any workarounds at the moment.

Below are few exiting feature requests submitting by other users for the same requirement. I would recommend you to please up-vote and/or comment on these feedback items which would help increase the priority of the feature requests.

Hope this info helps.



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.




· 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.

Hi @AhsanKhawaja-4410,

Just checking in to see if the above information was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @AhsanKhawaja-4410,

We still have not heard back from you. Just wanted to check if the above info was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·