MongoDB Map Reduce functionality

[naf305]

 Hi all,

I recently discovered that a new connector for the No-SQL platform MongoDB has just been released and I'm very excited about it.

My question is: Is the poweful Map Reduce feature supported in the connector? I know it is in the java driver so I wonder if it can be used in my reports directly as well?

 

Also let say I have so more complex processing/querying that I would want to do outside of jasperreport.... Is it possible to pass a json string as the report datasource? Like it is for XML.

 

Thanks!

[mdahlman]

I have a question before I can figure out the answer. Is it possible to use the MongoDB Map/Reduce feature in the advanced query syntax listed here:

http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-Specialoperators

It seems this it's probably possible based on a comment from that same page:
"you can use $where to do things like SIN and map/reduce for aggregates (like SUM)"
But I'm a little hesitant to base my answer on comment.

Therefore the answer should be yes. Please give it a try. Let us know how it goes. It ought to be possible, and if it's not then I'm sure we can find a way to make it possible.

For your second question, I'm not sure I understand it well. JasperReports does not have a built-in data source for JSON objects. So perhaps the answer is "no". But you could surely do what you need with a custom data source (or a custom query executer). Or perhaps you could do it even more easily just by casting the JSON string into a Java object. I'm not sure that this would be trivial to do... but it doesn't seem like it would be hard.

Regards,
Matt
Jaspersoft