Does Azure Data Factory Self-Hosted IR support data flow ?

Amy Z 291 Reputation points
2022-05-04T11:38:24.683+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,161 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. MarkKromer-MSFT 5,206 Reputation points Microsoft Employee
    2022-05-04T22:42:53.27+00:00

    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.

    1 person found this answer helpful.

  2. Nandan Hegde 31,436 Reputation points MVP
    2022-05-04T12:02:26.38+00:00

    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