We have a wf with DB nodes, and we want that wf chooses between two database credentials, depending on if it’s executed locally (my machine) or in the server, because we have created individual users for this database, and also a knime server user. So, we have created this wrapped metanode as template:
Single selection node allows us to choose between automatic login (which selects credentials based on where we are, local machines or server), or manual login (both user or knime server options).
This metanode works great locally, and we thought also the same about the server, but we are having a lot of problems with DB nodes in some wfs including this template: ORA12592, ORA28000,… (user blocked). So we are not sure this is an optimal approach. Also we have the problem that credentials arent managed very well as flowvariables, and this is even more complicated in the server where you cant visualize them.
We have tried to created a similar automated credential selection using workflow credentials, but they are only available at workflow level and not inside a wrapede metanode template. Another solution would be to create a template that outputs directly a db connection, but I would have to extend this connections everywhere.
Any other ideas?