Connect ADF to SQL hybrid availability group for data copy

Question

Hi everyone,

What's the best possible solution to connect Azure Data Factory to a hybrid SQL always-on availability Group for Data copy ?

Current Situation:
Azure Data factory is currently connected via self-hosted integration runtime to connect to the on-prem SQL databases.
At the same time, we are setting up an always on availability group (with read-intend routing) between our on-prem cluster and a VM running in Azure in a private VNET.

Is there a possibility to connect Azure Data factory directly to the VM running in Azure, and if yes, what would be the impact or changes that we need to do?

In the current setup, when using the read-intend routing our self-hosted integration runtime will probably handle the data transfer, meaning the data is downloaded from the cloud and uploaded again to the data factory.
Is there a possibility to avoid the download and upload of the data (since it is already replicated to Azure) ?

Here a quick visual of the setup:

Answer 1

Hello ,

Thanks for the ask and using this forum .

Please do allow me to put forward my understanding . Since you are already having a secondary replica running on Azure of the always on setup , the ask is if we can use that to connect to ADF .

Since we don't have the setup so we are not able to test this , but in theory this should work . To my understanding you may have to move the SHIR on to the VM on which SQL is running , since the VM is in Azure it can work without that also , but I am not sure .

Please do let us know how it goes .

Thanks Himanshu

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members