Mapping Data Flow Sink to SQL on IaaS VM

Question

Does Mapping Data Flow allow us to sink the data into a SQL DB hosted on a IaaS VM? Currently, there is no option other than Azure Blob Storage or Azure SQL. Any inputs here are highly appreciated. Thanks.

Answer 1

Hi @Priyaranjan Midde ,

Welcome to Microsoft Q&A platform and thanks for using this forum.

Currently ADF mapping data flow only supports the following data source/sink. (Ref: Supported source types)

Azure Data Factory has access to over 90 native connectors. In order to load transformed data from data flow to your SQL DB in Azure VM, you may have to first load the data to one of the data flow supported sink stores and then use a subsequent Copy Activity to load that data from dataflow supported staging area to your final sink/destination - ie., SQL DB in Azure VM.

Please note that Mapping data flow doesn't support Self Hosted Integration Runtime.

Here are couple of existing feature requests threads from other Azure users. I would recommend you to please up-vote and/or comment on these user voice items to help increase the priority of feature implementations.

• Add datasets to Data Flows that can support all the connectors found in Azure Data Factory
• allow to use DataFlows with Self hosted integration runtime

In case if you have a specific feedback, please feel free to log a new user voice item and share the link here, so that other readers can up-vote and share their thoughts.

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

Thank you

----------

Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.