question

sakuraime avatar image
0 Votes"
sakuraime asked KranthiPakala-MSFT commented

Azure data factory pipeline vs Azure Synapse workspace pipeline

Are there any documentation to compare building pipeline in Azure data factory vs in Azure Synapse Workspace ?

azure-data-factoryazure-synapse-analytics
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sakuraime,

Following up to see if any of the below suggestions answers your query? If you have further query do let us know.



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

0 Votes 0 ·

Hi @sakuraime,

We still have not heard back from you. Just wanted to check if the below information was helpful.

0 Votes 0 ·
KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered

Hi @sakuraime,

Thanks for your query.

Synapse pipelines and data flows are the same codebase in ADF & Synapse, simply branded as "Synapse" vs. "ADF". ​

There are a few differences where some features don't port automatically to Synapse, like SSIS, but the intent is to be able to leverage the same skills you learned in ADF when you are performing data integration and ETL in Synapse.​

You can find most of the difference called out here: Differences from Azure Data Factory - Azure Synapse Analytics | Microsoft Docs

When building an analytics solution in Azure, we recommend starting with Synapse since you have a fully integrated design experience and Azure analytics product conformance in a single pane of glass. ​

For ETL engineers and migrations from classic ETL tools, you may find ADF a more comfortable place to start in Azure.

Hope this info helps.



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

You can go through more detailed blog over here -

https://www.mssqltips.com/sqlservertip/6678/azure-synapse-analytics-vs-azure-data-factory-building-synapse-pipeline/


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.