Search code examples
azuredataflowazure-data-factory

Azure data factory data flow task cannot take on prem as source

enter image description here

Hey, I am having trouble in creating a Data Flows task which uses an on-prem source. Is this not possible in the Preview version?

I have created a self hosted IR to connect ADF to my laptop, and that is what I want to use. In the pic below I am trying to create a dataset off self hosted IR. It works great in Copy task but for Data Flows it is greyed out.

Solution

  • For this question, I asked Azure support for help and they replied me with the answer:

    Answer:

    This means on-premise SQL server is not supported as dataset in data flow in current stage.

    Screen shot: enter image description here

    Update:

    Data flow now only support Azure IR so it doesn’t support on-premise dataset. Refer to Integration runtime types. enter image description here

    Hope this helps.