By 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.
