We have a new SQL database available at work which will be extremely useful. However, the connection actually doesn’t have a password, but Knime will not accept blank as a valid password!
Can anyone suggest a way around this?
We have a new SQL database available at work which will be extremely useful. However, the connection actually doesn’t have a password, but Knime will not accept blank as a valid password!
Can anyone suggest a way around this?
I finally managed to figure it out. I had to create the variables in table creator, change the missing password to blank with rule engine (MISSING $Password$ => “”) create variables, use the Variables to Credentials node and then use “credentials” rather than username/password in the SQL connector node.
Hopefully this explanation will help someone in future!
Glad you found a way through. Thanks for posting your solution!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.