Options

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

RavanRavan Member Posts: 2 Contributor I
edited June 2019 in Help
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
Tagged:

Answers

  • Options
    MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    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
  • Options
    RavanRavan Member Posts: 2 Contributor I
    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
    image

    Thanks,
    Ravan
  • Options
    miguelalmiguelal Member Posts: 23 Contributor II
    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.
Sign In or Register to comment.