Geek Answers Handbook

MongoDB and BIRT Reporting?

Has anyone used BIRT to create reports from MongoDB, can you describe what problems, etc.?

It seems that you can use the JDBC interface and this experimental driver: https://github.com/erh/mongo-jdbc

However, I'm not quite sure how to install this driver in eclipse to check it out.

+4
source share
4 answers

I have successfully integrated BIRT with MongoDB - it works fine. The idea is this: define a data source in BIRT, and then define a data set using this data source. There is an “open” event in the dataset in which you place a call on the Mongo Java Driver and execute your query with MongoDB (and get the DB cursor). Then in the "fetch" event, you basically get the next Cursor value, populating the data from the cursor into the data set.

This is possible because BIRT scripts use the RHINO Javascript engine with Java integration. Put the MongoDB Java driver in the classpath and start coding :)

+3
source

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

Let me know if you encounter any problems. The user guide, available in the Downloads section, should help you use ODA.

+2
source

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

+2
source

JDBC has only had one check over a year. I think the JDBC driver project is dead. JDBC and NoSQL are incompatible.

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

+1
source

More articles:


All Articles