Share via

Azure data factory pipeline vs Azure Synapse workspace pipeline

sakuraime 2,351 Reputation points
2021-05-07T03:22:02.82+00:00

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

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.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,827 Reputation points Moderator
    2021-05-07T03:51:03.493+00:00

    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 Learn

    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.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Vaibhav Chaudhari 39,011 Reputation points Volunteer Moderator
    2021-05-07T08:41:23.307+00:00

    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

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

Your answer

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