🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How to use MongoDB in RapidMiner community version?

User: "SultanAlNahian"
New Altair Community Member
Updated by Jocelyn
I need to use no-sql database MongoDB with RapidMiner. There is a connector for mongoDB in RapidMiner but only in the professional licensed version. Is there any MongoDB connector in Rapidminer community version?

Find more posts tagged with

Sort by:
1 - 6 of 61
    User: "JEdward"
    New Altair Community Member
    Not as far as I'm aware. 

    Maybe ask RM for a trial licence of RM Studio professional &, if it proves worth it to your project upgrade to the full version

    Alternative options: I'd recommend the PostgreSQL route myself. 
    User: "BalazsBaranyRM"
    New Altair Community Member
    Another possibility: Using the Foreign Data Wrapper for MongoDB in PostgreSQL:
    https://github.com/citusdata/mongo_fdw

    With that, you don't need to export your data to PostgreSQL, just define access rules ("Foreign Tables") for your MongoDB queries.

    That's even the approach MongoDB uses with their BI Connector: https://www.mongodb.com/products/bi-connector (even if that connector is proprietary).
    User: "JEdward"
    New Altair Community Member
    Thanks Balázs!  I didn't know that one. 

    Great to know. 
    User: "BalazsBaranyRM"
    New Altair Community Member
    You should check out the rest of the PostgreSQL Foreign Data Wrappers: https://wiki.postgresql.org/wiki/Foreign_data_wrappers

    They can do amazing things.

    Maybe one day there'll be a RapidMiner Foreign Data Wrapper for executing RapidMiner processes in the database. That would be really cool.
    How complicated is this?
    User: "BalazsBaranyRM"
    New Altair Community Member
    Well, you need to have a good knowledge of PostgreSQL administration. Probably compile the extension yourself. Then you define the structure of the MongoDB query in SQL (more or less) to create the Foreign Table. It is a kind of a view to the remote "database".

    Not something that can be done by novice GUI users, probably.