This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 26%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
Hi, we're trying to use data flow in ADF by SHIR but with no luck.
It seems only AutoResolveIntegrationRuntime supports it.
We only can find posts like these mentioned it.
https://stackoverflow.com/questions/67221359/azure-data-factory-not-using-data-flow-runtime
https://stackoverflow.com/questions/64105436/linked-service-with-self-hosted-integration-runtime-is-not-supported-in-data-flo
Not sure if if there's any official link covers it ?
And if there's any future plan will cover SHIR in data flow ?
Thank you
Data flows do not execute on self-hosted IR. However, you can use the managed VNET option in the Azure IR in order to open up data flows to data stores inside VNETs or on prem.
Hi @Amy Z ,
Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.
Hi @Amy Z ,
Just following up to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 49%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
you can use the managed VNET option in the Azure IR in order to open up data flows to data stores inside VNETs or on prem.
But then you will trigger the costs of running your IR in Azure, so potentially high impact.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 64%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Is there any link that can be posted that explains about "However, you can use the managed VNET option in the Azure IR in order to open up data flows to data stores inside VNETs or on prem."?
Hey,
Based on my understanding , SHIR is not supported in dataflows.
We can leverage private link :
https://techcommunity.microsoft.com/t5/azure-data-factory-blog/new-data-flow-connector-sql-server-as-source-and-sink/ba-p/2406213