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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.