Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

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

Find more posts tagged with

AI Studio

Databases

SQL

Accepted answers

All comments

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.