How to push the csv data into MongoDB from Azure Data Factory with detailed description?

Ritesh Jaiswal 21 Reputation points
2021-09-23T20:55:04.327+00:00

How to push the csv data into MongoDB from Azure Data Factory with detailed description?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,659 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. SHAIK MAHEER BASHA 76 Reputation points
    2021-09-24T10:14:43.517+00:00

    Hi @Ritesh Jaiswal ,

    Thank you for posting query in Microsoft Q&A Platform.

    You can leverage Copy activity to push csv data into MongoDB using Azure data factory.

    Step1: Create a Dataset for your csv file
    Step2: Create a Dataset for your MongoDB
    Step3: Inside Copy activity, Under source tab - use csv dataset(created in step1)
    Step4: Inside Copy activity, Under sink tab - use MongoDB dataset(created in step2)
    Step5: If require, Inside copy activity, under mappings - import schema and map columns between source and sink accordingly.

    Click here for more details on csv type dataset.
    Click here for more details on MongoDB dataset.
    Click here to know about properties of Copy activity with csv dataset as source.
    Click here to know about properties of Copy activity with MongoDB dataset as sink.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators