An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
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?
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.
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