Converting azure synapse pipelines to azure data factory pipelines

Charan 20 Reputation points
2023-09-07T09:52:42.5633333+00:00

Our application was developed in Synapse workspace. We want to move to Azure data factory. Please let me know the process to move from Synapse to data factory.

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.
5,373 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
{count} votes

Accepted answer
  1. Amira Bedhiafi 33,071 Reputation points Volunteer Moderator
    2023-09-07T12:08:40.37+00:00

    Migrating from Azure Synapse Analytics to Azure Data Factory (ADF) involves transferring Synapse Pipelines to Data Factory Pipelines. While both services offer data integration capabilities, they have distinct functionalities and design philosophies.

    I am assuming the following (this is a step-by-step guide ) :

    1. Assessment:
      • Identify your Synapse workspace's pipelines, datasets, linked services, and triggers.
      • List all external dependencies, such as storage accounts, databases, and external systems that are connected to your Synapse workspace.
    2. Environment Setup:
      • Create an Azure Data Factory instance in the Azure portal if you haven't already.
      • Set up necessary authentication mechanisms. For example, set up Managed Identity or Service Principal to provide ADF with access to Azure resources.
    3. Migrate Linked Services:
      • In Synapse, Linked Services define the connection parameters to the external systems. In ADF, the concept remains the same.
      • Recreate these linked services in ADF manually or by exporting the ARM templates from Synapse and modifying them for ADF.
    4. Migrate Datasets:
      • Datasets in Synapse represent the data structures, such as tables or files.
      • You can manually recreate these in ADF or, similar to linked services, use ARM templates for migration.
    5. Migrate Activities:
      • Activities in Synapse might have different configurations than those in ADF.
      • Review each activity in Synapse and recreate them in ADF. Some might be straightforward, while others might need adjustments or reconfiguration.
      • Pay close attention to mapping data flows and other transformation activities, as there might be differences between Synapse and ADF.
    6. Migrate Triggers:
      • If you have any scheduled or event-driven triggers in Synapse, replicate them in ADF.

0 additional answers

Sort by: Most helpful

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.