Parameterizing the database connection

rachel_lomasky
rachel_lomasky New Altair Community Member
edited November 2024 in Community Q&A

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.

Best Answer

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    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

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    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

  • rachel_lomasky
    rachel_lomasky New Altair Community Member

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