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.
Oracle and in-database processing
Learner I
Hello,
Is anyone aware of an alternative on executing a visual query as in-database processing on Oracle?
Found this In-Database Processing extension (marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_in_database_processing), but seems it only supports Google BigQuery (via OAuth 2), PostgreSQL and MySQL.
Ideas welcome.
Is anyone aware of an alternative on executing a visual query as in-database processing on Oracle?
Found this In-Database Processing extension (marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_in_database_processing), but seems it only supports Google BigQuery (via OAuth 2), PostgreSQL and MySQL.
Ideas welcome.
0
Best Answers
-
BalazsBarany
Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 
Unicorn
Hi @apivk,
support for additional databases can be added by RapidMiner developers if a customer is asking for it. This hasn't been the case yet for Oracle, it seems.
That said, you can just try it. SQL is reasonably well defined, so most things (SELECT from tables, JOIN, filter, aggregate, union) should work nevertheless. Generate Attributes won't help you with the available functions but you can still enter SQL expressions.
Regards,
Balázs5 -
tkenez
Employee, RapidMiner Certified Expert, Member Posts: 22 
RM Product Management
Hey @apivk ,Some more thoughts on this. As Balazs said above, we don't yet support Oracle in In-Database Processing Extension. It is on the roadmap, but I cannot say a firm date for it just yet.In the meantime, if you have the skills to meddle with Java code, there is a sample project on GitHub on how to extend the extension to support new databases, and Oracle is used in the example. Check it out here: https://github.com/rapidminer-labs/rapidminer-extension-indb-oracle-sampleThe reason why this hasn't been simply added to the extension just yet is that there are some kinks to work out so we can safely say it can support production workloads.
7
