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