mongodb and birt reporting

mongodb and birt reporting  using -'mongodb,reporting,birt'

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:

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

asked Oct 6, 2015 by atulpariharmca
0 votes

3 Answers

0 votes

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 :)

answered Oct 6, 2015 by 20shahi
0 votes

Try this

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.

answered Oct 6, 2015 by nimisha.jagtap
0 votes

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.

answered Oct 6, 2015 by ajit.chavhan