How to create source to target mapping in ADF

rama matah 0 Reputation points
2023-03-08T09:53:50.06+00:00

Hi Folks,

I need details about how to create source target mapping in ADF.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,669 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee
    2023-03-09T07:34:27.5133333+00:00

    Hello @rama matah

    Thanks for the question and using MS Q&A platform.

    You can create source and sink target mapping in ADF using copy activity and the data flows.

    Using Copy Activity:

    To create a source to target mapping in Azure Data Factory (ADF), you can follow these steps:

    1. Create a pipeline in ADF by clicking on the "Author & Monitor" button in the ADF dashboard and selecting "Author".
    2. Drag and drop the "Copy Data" activity onto the pipeline canvas.
    3. Click on the "Source" tab in the "Copy Data" activity, and select the source data store from which you want to copy data.
    4. Choose the appropriate dataset for the source data store, which should have the required schema and access credentials.
    5. Click on the "Sink" tab in the "Copy Data" activity, and select the target data store where you want to copy data.
    6. Choose the appropriate dataset for the target data store, which should have the required schema and access credentials.
    7. Under the "Mapping" tab in the "Copy Data" activity, you can map the columns from the source dataset to the corresponding columns in the target dataset.
    8. To map columns, click on the plus icon next to the "Source" and "Sink" fields and select the column you want to map.
    9. Once you have mapped all the required columns, click on the "Debug" button to test the pipeline.
    10. If the test run is successful, you can publish the pipeline to the ADF service to make it available for production use.

    User's image

    That's it! You have successfully created a source to target mapping in Azure Data Factory.

    Using Data flows:

    You can use mapping data flows to extract data from a source, apply transformations, and load the data into a target. Mapping data flows provide a visual interface for transforming data in Azure Data Factory

    User's image

    For more details, refer to this article which covers all the steps on how to create source target mapping in ADF: https://www.tevpro.com/blog/creating-your-first-azure-data-factory-pipeline#section-5-setup-mappings

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.