Home DevShare Designing BIRT Reports

Mongo DB ODA Plugin for BIRT

Share

by ankit garg

Contributor Contest - 1 winDevShare - 1 postPoll Voter
Posted 25 Apr 2012 - 10:35 AM

(4)  (0)   (863 views)

By downloading this item, you are agreeing to the Terms of Use for the site.

Mongo DB ODA plugin provides a new Data Source that allow a user to quickly connect to Mongo database ,it not only extract the data but also allows to filter the data in SQL and JSON format to provide more usability in BIRT Report.

Birt Version:-2.5

This devshare submission qualifies for Plug In 2 BIRT Contest

MongoDB  is an open source,high-performance , document-oriented NoSQL database system.

MongoDB makes part of the "new" NoSQL family of database systems. Instead of storing data in tables as is done in a "classical" relational database, MongoDB stores structured data as JSON-like documents with dynamic schemas (MongoDB calls the format BSON), making the integration of data in certain types of applications easier and faster.It is a improved way of developing applications since there is no joins and also eliminates complex transactios.

The person who will use this Mongo DB ODA driver will be able to filter the records of collection using SQL as well as JSON format,since I created the parser that will translate the SQL format to JSON format , so it will be very easy to access this database using BIRT Tool for the users who dont know JSON syntax.

Now accessing the Mongo DB becomes as easy as SQL Wink: collection_name(attribute1,attribute2,.....) where {condtion} {sort clause}

For more information you can refer to the attached user guide.

Download (902.19 KB)

By downloading this item, you are agreeing to the Terms of Use for the site.



RahulG

Posted: 30 Apr 2012 - 11:31 AM

filtering mongo db using sql is really gud...

DevShare - 10 postsForum - 100 postsCommunity AdvisorPoll Voter

Megha Nidhi Dahal

Posted: 16 May 2012 - 04:01 AM

Nice idea, allows a non JSON guy (like me :-) ) to make use of SQL like syntax to access data from MongoDB. There are a lot many SQL keywords supported. The ODA works great. Nice work Ankit!

sambitbhad

Posted: 16 May 2012 - 11:53 PM

ODA works awesome... :)) I agree with u megha what u wrote here . For non JSON guy this ODA is perfect for accessing mongo db, its superb and very useful now.

DevShare - 100 postsForum - 2,000 postsCommunity Advisor

JasonW

Posted: 18 May 2012 - 12:49 PM

Nice oda. Do you plan on supporting parameters? Also can you get sub objects ie loc.x "_id" : ObjectId("4fb6a2e29ecc786437378415 "city" : "ACMAR", "zip" : "35004", "loc" : { "y" : 33.584132..

Contributor Contest - 1 winDevShare - 1 postPoll Voter

ankit garg

Posted: 19 May 2012 - 06:02 AM

Thanks rahul for trying my oda..... :-)

Contributor Contest - 1 winDevShare - 1 postPoll Voter

ankit garg

Posted: 19 May 2012 - 06:05 AM

Thanks megha and sambit for trying my oda and for the wonderfull comments....... :-)

Contributor Contest - 1 winDevShare - 1 postPoll Voter

ankit garg

Posted: 19 May 2012 - 06:16 AM

Thanks jason for trying my Plugin ....... :-) Yeah i m planing to include parameters that i will upload soon and sub objects works with json format only in my oda.

fdr1100

Posted: 20 Jun 2012 - 08:57 PM

Hi Ankit, You mentioned that "sub objects works with json format only in my oda." Is it possible to query sub objects (e.g. user.name, etc)? If so, can you post an example? I've tried different variations of syntax but no luck. Thanks!

DevShare - 100 postsForum - 2,000 postsCommunity Advisor

JasonW

Posted: 25 Jul 2012 - 08:03 AM

Ankit Have you published the source for this plugin? Jason

Contributor Contest - 1 winDevShare - 1 postPoll Voter

ankit garg

Posted: 29 Jul 2012 - 06:42 AM

@ jason : not yet

DevShare - 100 postsForum - 2,000 postsCommunity Advisor

JasonW

Posted: 30 Jul 2012 - 10:39 AM

Do you plan on putting it up?
 
Filter More