Read SQL Connection from config orJSON or Properties file.

[AvnImpln]

We are trying to read SQL Connection details from either of the JSON file. We were able to do all config through the flow mentioned in image, but the password is not reading via flow variable and getting failed until we input password in config window manually.

[tobias.koetter]

Hello @AvnImpln ,

the password is stored encrypted in the node dialog which is why you cannot use flow variables to control it. However you can use the Variable to Credentials node to convert the username and password string variables into a single credentials flow variable which you can use in the Microsoft SQL Server Connector node.

May I ask you why you are doing this? We are planning a feature for KNIME Hub that would allow the user to define different connection settings e.g. DB URL and login based on environment the workflow is deployed to e.g. development and production. Is your use case similar?

Thanks
Tobias

[AvnImpln]

Hi @tobias.koetter Thanks for the suggestion and this actually worked well for creating a successful connection to Microsoft SQL Server Convertor from a JSON file.

Yes, the case is similar to your requirement where we are trying to reuse the package in multiple environments.

Thanks,
VJ