The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Can i force RapidMiner to use Oracle database column settings
Maven
Hello,
I am writing some results on an Oracle database but the table we have in the database must have the "Number" datatype and certain size for VARCHAR.
RapidMiner, on the other hand, is changing the datatype from "Number" to "Float" and the size of the VARCHAR to smaller sizes.
Is there a way I can force it not to change those 2 things.
Thanks and best regards,
Zeyad
I am writing some results on an Oracle database but the table we have in the database must have the "Number" datatype and certain size for VARCHAR.
RapidMiner, on the other hand, is changing the datatype from "Number" to "Float" and the size of the VARCHAR to smaller sizes.
Is there a way I can force it not to change those 2 things.
Thanks and best regards,
Zeyad
1
Best Answer
-
BalazsBarany
Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 
Unicorn
Hi,
you are using Write Database. This operator has a parameter "overwrite mode".
If you create the database table yourself, with the appropriate settings (Numeric, Varchar), you should select overwrite mode = append in RapidMiner. This way the process won't touch the table structure. If you need the table cleaned before, use Execute SQL with a DELETE statement before writing into the table.
A best practice in database security is using a role (user) which can read and write into tables, but can't change the structure. This setup works well with RapidMiner as long as overwrite mode is append.
Regards,
Balázs7
