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

Parameterizing the database connection

rachel_lomaskyrachel_lomasky Member Posts: 52 Maven
edited November 2018 in Help

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:

Best Answer

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data Scientist
    Solution Accepted

    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, Germany

Answers

  • rachel_lomaskyrachel_lomasky Member Posts: 52 Maven

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

Sign In or Register to comment.