Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Rapidminer In_DataBase Nest?

shivamnarwareshivamnarware Member Posts: 3 Learner I
Is there any way to give two or more connection names in the In_Database nest as I have two different connection DB as input and I am just able to get one connection name only?

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Hi!

    The In-Database Processing nest only connects to one database connection. It generates one SQL query to be executed in one database. 

    If you want to combine results from two different databases, you can get the results from both queries using two database nests and then join in RapidMiner.

    Sometimes database systems can create internal connections to other databases. (Example: The PostgreSQL Foreign Data Wrappers concept.) If you have such a setup, you are able to use In-DB Nest with just one connection, and the database system manages the data processing internally. 

    Regards,
    Balázs
  • shivamnarwareshivamnarware Member Posts: 3 Learner I
    Hi can we have in_database nest inside the other in_database nest ?
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,531 RM Data Scientist
    edited March 2023
    Hi,
    this is not possible, for same same reasons Balász pointed out.
    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.