Why on-premise sql server source table not visible in DataFlow?

Sonu Ojha 1 Reputation point
2021-03-12T19:15:49.273+00:00

Greetings.

I was trying to create a data flow in ADF.
Source:- on premise SQL Server
Target: - Azure SQL Server

I have proper connectivity with on premise db, IR is up.
When I am creating a Data flow with source as on-premise SQL Server dataset, I couldn't find the dataset to connect.

Can someone help me what is the wrong with this. Is this something that we can't do in ADF to connect on-prem sql server db and transform?

Could you please help me to fix it.

77258-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,516 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,576 Reputation points
    2021-03-13T04:44:37.977+00:00

    Mapping data flow follows an extract, load, and transform (ELT) approach and works with staging datasets that are all in Azure.

    So on-prem SQL server is not supported as Source in data flow.

    Reference - https://learn.microsoft.com/en-us/azure/data-factory/data-flow-source

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments