how to connect to On-premise SQL server from synapse mapping dataflow

heta desai 247 Reputation points
2022-08-17T08:06:39.52+00:00

I want to read data from SQL server(on-premise) using synapse mapping dataflow. Where I tried using self-hosted Integration Runtime it throws an error which tells that dataflow can not connect on-premise source using self-hosted IR.

Please suggest me the way to pull data from SQL server using mapping data flow.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,342 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,478 questions
Accepted answer
  1. Nandan Hegde 29,886 Reputation points MVP
    2022-08-17T08:21:55.717+00:00

    Hey
    If your goal is to use visual data transformations in ADF using Mapping Data Flows with on-prem data, then build a pipeline with a Copy Activity first. Use the Self-Hosted Integration Runtime with the Copy Activity to stage your data in Blob Store. Then add a subsequent Execute Data Flow activity to transform that data.

    As SQL server(Onprem) is not supported in dataflows:
    https://learn.microsoft.com/en-us/answers/questions/312392/why-on-premise-sql-server-source-table-not-visible.html

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest