question

RiteshJaiswal-7287 avatar image
0 Votes"
RiteshJaiswal-7287 asked ShaikMaheer-MSFT commented

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

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

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SHAIKMAHEERBASHA-8675 avatar image
0 Votes"
SHAIKMAHEERBASHA-8675 answered ShaikMaheer-MSFT commented

Hi @RiteshJaiswal-7287 ,

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

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thanks for the answer, it is partially resolved my issues.
Do you know how to do the mappin gof Flat schema to JSON format of MongoDB?
I gone through the Microsoft links but it doesn't make much sense to me. If possible please provide some examples as well.

0 Votes 0 ·

Hi @RiteshJaiswal-7287 ,

You can try import mappings option inside copy activity or manually having mappings created. Please try and let us know how it goes. Thank you.

0 Votes 0 ·

Hi @RiteshJaiswal-7287 ,

Did you get chance to share updates?

0 Votes 0 ·
Show more comments