4 Replies Latest reply on Apr 11, 2019 1:50 PM by Arun Kumar

    Change the default connection using script

    Arun Kumar Seasoned Veteran

      Hello,

       

      We have a bunch of workflows that execute stored procedures using dual table connections in the source and target. Its all using a default BI_DEV connection, which is guess is pointing to DEV environment. These are not parameterized, hence same BI_DEV connection is used in QA and PROD. We have a requirement to change these to BI_QA in QA env and BI_PROD in PRD env. Doing this manually for all the affected sessions is a very time consuming process as we need to parameterize first and change the same in connection settings. Is there a way all these connections can be changed in one go using a script?