Dynamic DB connection for different types of databases

[ipazin]

Hello @bgopalam1981,

and welcome to KNIME Community!

Please don’t share any sensitive data here on forum.

To have this dynamic DB connection you can control Credentials Configuration node with flow variables and then use credentials to control database connector node:

Problems with Database Nodes KNIME 4.0

Hi stofffetzen, the new DB Connector node no longer supports plain text passwords ans input. To set the password via flow variable you have to use the Credentials Configuration node where you set the default password via the flow variable. The credential can then be used in the DB Connector node. Have a look at the this example workflow. Bye Tobias

Also similar approach can be made with Variable to Credentials node.

Br,
Ivan