How to use MongoDB in RapidMiner community version?

SultanAlNahianSultanAlNahian Member Posts: 2 Contributor I
edited November 2018 in Help
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?
Tagged:

Answers

  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn
    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. 
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 788 Unicorn
    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).
  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn
    Thanks Balázs!  I didn't know that one. 

    Great to know. 
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 788 Unicorn
    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.
  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,231 RM Data Scientist
    How complicated is this?
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 788 Unicorn
    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.
Sign In or Register to comment.