RapidMiner

RapidMiner

Parameterizing the database connection

SOLVED
Highlighted
Regular Contributor

Parameterizing the database connection

I have a process that makes several database touches (read/write/execute sql).  Is it possible to parameterize the database connection?  I'd like to be able to switch it to write to the dev/staging/prod databases without having to manually change each operator.

2 REPLIES
RMStaff

Re: Parameterizing the database connection

Hi,

 

i think the most convinient way is to use a Subprocess or Branch opertor and choose depending on a macro.

 

Antoher way could be to use a macro in the Read Database COnnection setting. You need to put this one into the XML though.

 

Best,

Martin

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Regular Contributor

Re: Parameterizing the database connection

Thank you!  I had suspected the XML solution was going to be my best option.