New feature request - button/option to disable DB node credentials auto-connect

Hi,

Currently we have workflows which we share with our team and we use workflow credentials so each of us use our own database logins (and don’t have to re-update each DB node individually with user and pass). When we make a change to the workflow and re-share it, we edit the workflow credential dialog box to remove our username and password, then share it. Though, now when a user opens the workflow, it appears the DB nodes try to autoconnect even though the password and username are blank; sometimes a user would just like to look at the results and not have to log in; we also don’t want to constantly sent invalid usernames (blank) and passwords to the database.

You can see the console log below when you open up a workflow with blank workflow credentials; KNIME seems to try to autoconnect on open. Could there be a new setting created somewhere to disable autoconnect?

Hi John-k,
the new database connector nodes create a new connection when the workflow is loaded if the node is executed. In order to prevent this from happening you could reset all database connector nodes before sharing the workflow. Would this already solve you problem?
Bye
Tobias

Hi @tobias.koetter , if i reset the DB nodes then this keeps them from auto-connecting. Though unfortunately, then the data is reset as well and can’t be shared with teammates.

Hi John-k,
that is true. We will think about this. Maybe we can change the connection creation to be lazy e.g. the connection will only be created the first time it is needed in the workflow. Thanks for the feedback.
Bye
Tobias

2 Likes

Thank You for considering this. Much appreciated.

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.