Home
Discussions
Community Q&A
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
Find more posts tagged with
AI Studio
Databases
Oracle
Accepted answers
BalazsBaranyRM
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
All comments
BalazsBaranyRM
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
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)