Share via

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

heta desai 252 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,847 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,538 questions
Accepted answer
  1. Nandan Hegde 32,026 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.