Set DB Connector Login via Flow Variable

This workflow demonstrates how the login for the DB Connector can be set via flow variables.


This is a companion discussion topic for the original entry at https://kni.me/w/SJKCBSJ1tzzXQY8t

I’d appreciate a piece of advice about how to wrap this piece of workflow in a shared component which would read connection parameters including a password from an external configuration e.g. properties file so that the only thing an outer workflow would have to do in order to get a database connection would be introducing this shared component with no need of input parameters or flow variables pushed to the component.

According to my experience so far, the Credential Configuration node loses its binding to the workflow variable that holds a password when such a shared component get added to a workflow.

This is related to the issue Recommended way of configuring a database connectors I posted recently.

Instead of using the node chain as demonstrated in the workflow you can also use the new Variable to Credentials node: