"RM with a non-SQL database(MongoDB)"

Ravan

Hi All,

I'd like to use RM with a non-SQL database, namely MongoDB (www.mongodb.org).would it be difficult to integrate it into RM?
Please help me on this..

Thanks!
Ravan

MariusHelf

Hi Ravan,

there is a jdbc driver for mongodb, if you are lucky you can just plug it into RapidMiner and you'll have (limited) access to your database: http://sourceforge.net/projects/mongojdbcdriver/?source=directory
If that does not work or is not sufficient, you probably have to create a RapidMiner extension which connects to mongodb and contains operators to retrieve documents from the database as a RapidMiner example set. That will require some effort, but should not be too hard for a java developer.

Best regards,
Marius

Ravan

Thanks Marius for quick response ..
I just placed the Drivers @Rapidminer/lib//JDBC
While managing a connection for MongoDB I am able to browse the same drivers,needed following details as well:-
1) URL prefix
2) Schema Separator
3) Driver Class


Thanks,
Ravan

miguelal

You can also create your own MongoDB operator as Tobias suggests in this thread:
http://rapid-i.com/rapidforum/index.php/topic,1627.0.html

We have done it, and now have a very rudimentary operator that executes find and aggregate commands against MongoDB, and it wasn't that difficult.

Another option is to buy a 3rd party driver, for instance do a search on "Simba MongoDB driver", I am not affiliated in any way with this or any other driver company.

I hope this helps.