5

Has anyone used BIRT to generate reports from MongoDB, can you describe how, any issues, etc. ?

It looks like it might be possible to interface using JDBC and this experimental driver: https://github.com/erh/mongo-jdbc

However, I am not exactly sure how to install this driver in eclipse to test it.

Scott Szretter
  • 3,938
  • 11
  • 57
  • 76

4 Answers4

4

I've successfully integrated BIRT with MongoDB - it works perfectly well. The idea is this - define a scripted data source in BIRT, then define a data set that using that data source. The data set has an "open" event in which you place the call to Mongo Java Driver and execute your query against MongoDB (and obtain a DB Cursor). Then in the "fetch" event you basically get the next value of the Cursor, filling data from the Cursor into the data set.

This is possible because BIRT scripts utilize RHINO Javascript engine which has Java integration. Place the MongoDB java driver in the classpath and start coding :)

Michael Weinberg
  • 41
  • 1
3

Birt has builtin support now for MongoDB :) http://www.eclipse.org/birt/phoenix/project/notable4.3.php#jump_5

Godekere
  • 350
  • 3
  • 8
3

Try this http://code.google.com/a/eclipselabs.org/p/mongodb-oda-birt-plugin/

Let me know if you face issues. The user guide available in the Downloads section should be able to help you with the usage of the ODA.

Pulak Bose
  • 31
  • 1
  • Thanks for suggesting ODA. i have been trying to use Command Expression Builder and I'm getting `org.eclipse.datatools.connectivity.oda.OdaException: Error in parsing the JSON expression`. I couldn't find a manual how write expressions correctly. I would greatly appreciate your help. – Alexander Suraphel Jun 30 '14 at 13:56
1

The JDBC has only one checkin for more as a year. I think the JDBC driver project is dead. JDBC and NoSQL are not compatible.

I think you need to write your own layer that create relational data from your NoSQL.

Horcrux7
  • 23,758
  • 21
  • 98
  • 156