Importing data from a JSON file
Procedure
- Double-click the second tMongoDBBulkLoad component to open its Basic settings view in the Component tab.
- In the MongoDB directory field, type in the MongoDB home directory. In this example, it is D:/MongoDB.
- In the Server and Port fields, fill in the information required for the connection to MongoDB. In this example, type in localhost and 27017.
- In the Database field, type in the target database to import data, bookstore in this example.
- In the Collection field, type in the target collection to import data, books in this example
- Browse to the desired data file from which you want to import data. Here, select books.json.{ "id": "4", "title": "Les Miserables", "author": "Victor Hugo", "category": "Language&Literature" } { "id": "5", "title": "Advanced Database Systems", "author": "Carlo Zaniolo", "category": "Database" }
- Select JSON from the File type list.
- Select Insert from the Action on data list.
- Click the Advanced settings tab to define the additional arguments as needed.