For our Knime modelling factory we have the following set-up on Knime server:
We have a number of seperate modelflows on the Knime server. A “master workflow” is scheduled on the server and reads a table with the logic that determines which of the seperate model workflows need to be run on that particular time.
To call these workflows I use the “call local workflow (rowbased)” node as described below. Each of the seperate workflows however needs to connect to a database. Right now i added the credentials for this database in each seperate workflow but this is not ideal/secure.
Ideally I want to store these credentials in one secure location, and pass them to each workflow as needed. I would really appreciate it if i can get some advice on how to achieve this.