This demo will show how to import data from a CSV file into MongoDB using Pentaho Data Integration tool (a.k.a. Kettle). The following items will be demonstrated:
- Basics of how to map columns from CSV file to fields in a MongoDB JSON document.
- How to handle variable/optional columns.
- Perform basic data scrubbing before adding data into MongoDB.
Although this demo uses a CSV file as input data, PDI can just as easily import data from many JDBC compliant databases by using the Table Input step.