Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Wiki Markup
{scrollbar}
Excerpt

How to read data from a data source (flat file) and write it to a collection in MongoDB

. By the end of this guide you should understand how data can be read from many different data sources and written to MongoDB. The data we are going to use contains data about the flow of visitors to a web site.

Intro Video

Widget Connector
width600
urlhttps://www.youtube.com/watch?v=Tgyrd1UiQhE
height480

Prerequisites

In order follow along with this how-to guide you will need the following:

...

Check the MongoDB Collection

  1. Using the Mongo CLI, type:

    Code Block
    
    
    use Demo;
    db.PageSuccessions.find();
    
    

    You should see a result like this:

    Code Block
    
    { "_id" : ObjectId("4f21850e09d01689c7d9887e"), "key" : "--firstpage--~^~/about", "url" : "--firstpage--", "nextUrl" : "/about", "Count" : NumberLong(504) }
    { "_id" : ObjectId("4f21850e09d01689c7d9887f"), "key" : "--firstpage--~^~/about/awards", "url" : "--firstpage--", "nextUrl" : "/about/awards", "Count" : NumberLong(80) }
    { "_id" : ObjectId("4f21850e09d01689c7d98880"), "key" : "--firstpage--~^~/about/customers", "url" : "--firstpage--", "nextUrl" : "/about/customers", "Count" : NumberLong(667) }
    


    Summary

    During this guide you learned how to populate a MongoDB collection using PDI's graphical design tool. You can use can use this tool to load data into MongoDB from many data sources.
    Other guides in this series cover to sort and group MongoDB data, create reports, and combine data from MongoDB with data from other sources.

    Wiki Markup
    {scrollbar}