Share via

ADF Ingestion

Anshal 2,251 Reputation points
2023-09-20T08:42:05.09+00:00

What different ways you can ingest the data using ADF and Synapse

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.

Answer accepted by question author
  1. Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator
    2023-09-20T10:11:19.3033333+00:00

    You can leverage a copy activity to copy data from 1 azure sql database to another and/or to copy data of file (Assuming file system or blob etc) to azure sql database.

    1. https://learn.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-dot-net
    2. https://learn.microsoft.com/en-us/azure/data-factory/connector-sql-server?tabs=data-factory

    Rather than sql server, for your case it would be Azure SQL db

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    2023-09-22T17:26:52.07+00:00

    Thank you Nandan Hegde

    Hi Anshal,

    In addition to Nandan's answer.

    You can also leverage mapping data flows here for your requirements.

    https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-sql-database?tabs=data-factory

    I hope this helps.

    please let us know if you have any further questions.

    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.