0

We're moving from on-premise to Azure and will be using Azure Synapse. Our transformations will largely be lift-and-shift of SQL stored procs to start.

Looking at the high-level documentation, I'm not seeing any differences between ADF & Azure Synapse Pipelines that would matter for our use case: MS Overview

Given we'll be using Azure Synapse Analytics, does it make the most sense to use Synapse Pipelines over ADF, just to be a bit more streamlined, or are there other considerations?

i.e. could pricing be totally different, documentation/support (I assume ADF would be better...but maybe they're so similar it's a moot point), etc.

bbb0777
  • 165
  • 14
  • 1
    There are a few use cases that are supported by Data Factory but not in Synapse. My advice would be to use Synapse unless your use case is not supported. I don't know all those use cases. I see one answer below with 2 of them. – Omar Abdel Bari Apr 26 '23 at 05:08

1 Answers1

2

Everything depends on how you want to design and architect because there are still couple of discrepancies between Synapse pipelines and ADF:

  1. IRs cannot be shared between Synapse workspaces unlike ADFs
  2. AIRFlow integration and Power Query are in ADf and still not in synapse

https://azurede.com/2021/03/27/difference-between-synapse-pipelines-and-azure-data-factory-pipelines/

Nandan
  • 3,939
  • 2
  • 8
  • 21