we are using MongoDB (on Linux) as our main database. However, we need to periodically (e.g. nightly) export some of the collections from Mongo to a MS SQL server to run analytics.

I am thinking about the following approach:

  1. Backup the Mongo database (probably from a replica) using mongodump
  2. Restore the database into a Windows machine where Mongo is istalled
  3. Write a custom made app to import the collections from Mongo into SQL (possibly handling any required normalization).
  4. Run analytics on the Windows SQL Server installation.

Are there any other "tried and true" alternatives?

Thanks, Stefano

EDIT: for point 4, the analytics is to be run on SQL Server, not Mongo.

sql-server mongodb
Edit
Report