Mapping Data Flow Sink to SQL on IaaS VM

asked 2020-09-15T20:05:01.807+00:00
Priyaranjan Midde 1 Reputation point

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.

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

1 answer

Sort by: Most helpful
  1. answered 2020-09-15T22:54:09.93+00:00
    KranthiPakala-MSFT 32,896 Reputation points Microsoft Employee

    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)

    25055-image.png

    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.

    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.