MSDN Forum: Data flows to Onprem sql connectivity not enabled in Azure data factory

ashok basani 1 Reputation point
2021-02-01T06:39:50.91+00:00

I was trying to copy the data flow Blob to Onprem SQL server using data flows. When trying to choose a SQL Server (On Prem) as sink, sql server icon is diabled in the sink linked service.

Any reson for the same? Anyhow able to connect with normal copy activity in ADF. Attached the Image.

62347-image.png

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

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 80,096 Reputation points Microsoft Employee
    2021-02-01T09:06:56.563+00:00

    Hello @ashok basani ,

    Welcome to the Microsoft Q&A platform.

    Unfortunately, Azure Data Factory – data flow doesn’t support SQL server.

    Mapping data flow follows an extract, load, and transform (ELT) approach and works with staging datasets that are all in Azure. Currently, the following datasets can be used in a source transformation.

    62444-image.png

    Reference: Source transformation in mapping data flow - Supported source types

    I would suggest you to vote up an idea submitted by another Azure customer.

    https://feedback.azure.com/forums/270578-data-factory/suggestions/37472797-data-flows-add-support-to-access-on-premise-sql-a

    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.

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

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.