How to use MongoDB in RapidMiner community version?

SultanAlNahianSultanAlNahian MemberPosts:2Contributor I
edited November 2018 inHelp
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, MemberPosts:578Unicorn
    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 projectupgrade to the full version?

    Alternative options:I'd recommend the PostgreSQL route myself.
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:949Unicorn
    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, MemberPosts:578Unicorn
    Thanks Balázs! I didn't know that one.

    Great to know.
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:949Unicorn
    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.
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University ProfessorPosts:3,404RM Data Scientist
    How complicated is this?
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:949Unicorn
    你需要有一个好的Postgr知识eSQL 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 InorRegisterto comment.