The Altair Community and the RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options
Parameterizing the database connection
![rachel_lomasky](https://us.v-cdn.net/6030995/uploads/defaultavatar/nCCNNSPK1YM69.jpg)
![](https://s3.amazonaws.com/rapidminer.community/vanilla-rank-images/guru-16x16.png )
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.
Tagged:
0
Best Answer
-
Options
MartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,525
RM Data Scientist
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
- Sr. Director Data Solutions, Altair RapidMiner -
Dortmund, Germany1
Answers
Thank you! I had suspected the XML solution was going to be my best option.