Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Uploading Master Data in MongoDB Atlas

DZone's Guide to

Uploading Master Data in MongoDB Atlas

Read this short tutorial that includes informational pictures in order to learn more about how to efficiently upload master data into MongoDB Atlas.

Free Resource

New whitepaper: Database DevOps – 6 Tips for Achieving Continuous Delivery. Discover 6 tips for continuous delivery with Database DevOps in this new whitepaper from Redgate. In 9 pages, it covers version control for databases and configurations, branching and testing, automation, using NuGet packages, and advice for how to start a pioneering Database DevOps project. Also includes further research on the industry-wide state of Database DevOps, how application and database development compare, plus practical steps for bringing DevOps to your database. Read it now free.

We hope you already have a MongoDB Atlas instance and you need to import master data in your collections.

Before you can import data, you need to whitelist your IP and create a user that has read/write permissions through the security tab.

Image title

MongoImport

MongoImport can be used to import data from json , csv, or tsv file.

To fire MongoImport command, traverse to the path where you have installed MongoDB on local:

Image title

Command to Be Used on windows:

C:\Program Files\MongoDB\Server\3.4\bin>mongoimport --host dzone-shard-00-00-abcde.mongodb.net:27017 --ssl --authenticationDatabase admin --username <userName> --password <password> --db testDB --collection Test --file C:\DZone\Test.json --jsonArray

Note : Please replace host , userName , password , db, and collection.

MongoFiles

The MongoFiles utility makes it possible to manipulate files stored in your MongoDB instance in GridFS objects from the command line. It is particularly useful as it provides an interface between objects stored in your file system and GridFS.

Command to Be Used on Windows:

C:\Program Files\MongoDB\Server\3.4\bin>mongofiles --host dzone-shard-00-00-abcde.mongodb.net:27017 --ssl --authenticationDatabase admin --username <userName> --password <password> --db <DB> -l C:\DZone\Test.pdf put Test.pdf

Note : Please replace host , userName , password , db, and collection.

New whitepaper: Database DevOps – 6 Tips for Achieving Continuous Delivery. Discover 6 tips for continuous delivery with Database DevOps in this new whitepaper from Redgate. In 9 pages, it covers version control for databases and configurations, branching and testing, automation, using NuGet packages, and advice for how to start a pioneering Database DevOps project. Also includes further research on the industry-wide state of Database DevOps, how application and database development compare, plus practical steps for bringing DevOps to your database. Read it now free.

Topics:
database ,mongodb atlas ,json ,csv ,mongodb

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}