CI/CD deployment in multiple KNIME Server environments

We are creating multiple workflows in knime that have a database connection node which needs the database server name and credentials. Once we are done with development then we need to be deploy this work flow in staging large Knime server then in a production large knime server but I would have to manually change the database connection node server name and credentials.

Is there a way (like a configuration file) to get the database name and credentials changed automatically in the database node from stage environment to production environment?

I had similar problems and solved by extracting system properties, in my case I check för the user name och set the correct ones with rule engine, so now I don’t need to think of the environment it’s running on

Skärmavbild 2020-06-26 kl. 10.48.19