About Us Icon About Us Icon Business Analyst Icon Business Analyst Icon CEO Icon CEO Icon Datameer Icon Datameer Icon Envelope Icon Envelope Icon Facebook Icon Facebook Icon Google Plus Icon Google Plus Icon Instagram Icon Instagram Icon IT Professional Icon IT Professional Icon Learn Icon Learn Icon Linkedin Icon Linkedin Icon Product Icon Product Icon Partners Icon Partners Icon Search Icon Search Icon Social Networks Icon Social Networks Icon Share Icon Share Icon Support Icon Support Icon Testimonial Icon Testimonial Icon Twitter Icon Twitter Icon

Datameer Blog

Working with MongoDB in Datameer

By on July 19, 2012

Datameer works well with most types of data, wherever they come from, as we have demonstrated several times on this blog as well as in the documentation.

As far as NoSQL databases are concerned, we have some native connectors out-of-the box, like for HBase or Cassandra.  However someone asked us recently: how do you ingest data from MongoDB, a popular NoSQL database, into Datameer?

To use data from MongoDB, as for a number of other types of NoSQL databases, we can always work with Datameer-compatible data types connectors, such as our JSON plugin.

Let’s see an example, and first follow the MongoDB tutorial on how to create a data collection using the MongoDB JavaScript shell, that we will later export to use in Datameer.

The Mongo tutorial shows how to start with a new collection, created on the fly via JavaScript:

Now we are ready to populate this into Datameer. MongoDB has a useful export command that enables dumping its data in to a JSON format by default. Let’s use this ‘mongoexport’ command and export to a file:

We are now ready to ingest this data in to Datameer, by choosing the JSON data type after selecting the MongoDB export file:

The advanced section of the Datameer JSON wizard import lets you control exactly what you are going to want to ingest, with some options like ‘Ignore Surrounding Text’, which is useful when using an older version of MongoDB:

And there you go; we can now start importing our MongoDB data to explore in Datameer!

As always, let us know if you have any questions about specific data sources you might want to use in Datameer, and we’ll be happy to help.

Connect with Datameer

Follow us on Twitter
Connect with us on LinkedIn, Google+ and Facebook