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

Question

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.

Answer 1

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.

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.