Share via

DataFlow Sink not allow to on premise SQL sqrver

Mahesh Madhusanka 176 Reputation points
2020-10-12T00:57:01.9+00:00

Hi Team,

Currently we have requirement to dataflow output data load to on premise SQL server table, According to when we trying to add SQL server connector to data flow Sink connection, its hide and Not allow to select it. But same connection allow to copy activity on the pipeline level, However our requirement is load data on the dataflow, For your reference here with attached snapshot, Could you please check and advise on this.?
31368-dataflow-sql-connection.png

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 80,096 Reputation points Microsoft Employee
    2020-10-12T08:40:14.7+00:00

    Hello @Mahesh Madhusanka ,

    Unfortunately, Azure Data Flows doesn’t support SQL Server has supported sink types.

    31586-image.png

    Currently the following datasets can be used in a source transformation:

    31624-image.png

    Reference: Azure Data Flow – Supported sink types

    I would suggest you to provide feedback on the same:

    https://feedback.azure.com/forums/270578-data-factory

    All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

    Hope this helps. Do let us know if you any further queries.

    ----------------------------------------------------------------------------------------

    Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    0 comments
  2. MarkKromer-MSFT 5,186 Reputation points Microsoft Employee
    2020-10-13T05:57:43.003+00:00

    You'll use ADF's Copy Activity together with Data Flow activities in your pipeline to implement an ELT pattern in ADF: https://www.youtube.com/watch?v=IN-4v0e7UIs

    0 comments