data flows is not working in ADF

2023-05-31T05:35:44.0566667+00:00

I am creating a dataflow in ADF while doing it am getting below error.my source is onprem(sql server) and target is azure sql or vice versa. how can i work with data flow when i click on validation or debug button? please suggest me asap.

error details:

linked service with self-hosted integration runtime is not supported in dataflow.

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

1 answer

Sort by: Most helpful
  1. Suba Balaji 11,206 Reputation points
    2023-05-31T13:05:33.0633333+00:00

    Hello @Bommisetty, Rakesh (Hudson IT Consultant)

    Currently we don't have the flexibility to point to data source which is in on premise. If you have such requirement you need to bring the data to azure, to either ADLS or AZ. SQL and then use it in the data flow.

    On the other hand, you could follow the steps in this video or the documentation here

    For more details: https://techcommunity.microsoft.com/t5/azure-data-factory-blog/new-data-flow-connector-sql-server-as-source-and-sink/ba-p/2406213

    But it would be much easier to go with the first option, to move data from on Prem to azure storage/SQL. And then do the transformation using data flow.

    Please let us know if you have further questions

    BR