Share via

ADF Ingestion

Anshal 2,246 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.
4,924 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,711 questions
Accepted answer
  1. Nandan Hegde 32,421 Reputation points MVP
    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,031 Reputation points Microsoft Employee
    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 Answers by the question author, which helps users to know the answer solved the author's problem.