CODEWITHSUNDEEP
azure-data-factory
Phil Lachmann
Phil Lachmann

Reputation: 231

ADF Dataflow Source - SQL Server not selectable

I am creating what should be a simple dataflow in ADF. However I am attempting to select a new dataset for SQL Server and the SQl Server option is not selectable.

Why can't I select SQL Server for my new dataset??????

enter image description here

Upvotes: 0

Views: 259

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

If we want connect to SQL Server, we must use self-hosted integration.

Data Flow doesn't support self-hosted integration. That's why it doesn't support on-premise SQL Server as Source and Sink.

Ref:https://learn.microsoft.com/en-us/azure/data-factory/connector-overview

HTH.

Upvotes: 0

Related Questions