How to do reporting with MongoDB?

mongodb reporting
mpen picture mpen · Jan 11, 2013 · Viewed 50.3k times · Source

I'm considering MongoDB for my next big project, but I have a couple of concerns. In particular, how can I do reporting?

My understanding is that I can't do the same kinds of joins and aggregation I would normally do in a relational database. The reporting I had in mind involves aggregating a lot of data from different "tables" with strict criteria.

Is this easily doable in MongoDB, or is it going to be a big headache?

Answer

John A. De Goes picture John A. De Goes · Apr 15, 2015

While Pentaho and Jaspersoft and other legacy reporting solutions have ways to pump data out of MongoDB, there are two newer solutions designed explicitly for analytics and reporting on MongoDB data:

  • JSON Studio. This is a commercial solution that lets you visually build aggregation pipelines and connect them to charts.
  • SlamData. This is an open source solution that lets you run SQL queries directly on MongoDB (including JOINs, GROUP BY, HAVING, etc), through the GUI interface or an API. The current version of the project has data visualization baked in, and allows you to create and embed reporting dash boards into MongoDB applications.

Because both of these run on top of MongoDB (versus the other approach, i.e. pumping the data out and normalizing it for reporting in Mondrian or something), they are much easier and more natural for MongoDB reporting. The flip side is that because the data is not loaded into all-memory cubes (for example), the reporting experience can suffer if you try to do complicated report generation in real-time.

Disclaimer: I'm a contributor for the SlamData project, although I have no affiliation with JSON Studio.

Related questions

How to query MongoDB with "like"?

I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.

Read More
Find objects between two dates MongoDB

I've been playing around storing tweets inside mongodb, each object looks like this: { "_id" : ObjectId("4c02c58de500fe1be1000005"), "contributors" : null, "text" : "Hello world", "user" : { "following" : null, "followers_count" : 5, "utc_offset" : null, "location" : "", "profile_text_color" : "000000", "friends_count" : 11, "profile_…

Read More
How can I list all collections in the MongoDB shell?

In the MongoDB shell, how do I list all collections for the current database that I'm using?

Read More