Can i force RapidMiner to use Oracle database column settings

ZAM

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

BalazsBarany

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ázs

BalazsBarany

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ázs