SQL Server DB and non person account

Hi,

thank you in advance for your assistance in this matter!

We would like to connect to a SQL Server database using a Non-Person Account (NPA) from the domain, by providing its username and password. The workflows developed are expected to run as schedules, data apps and APIs in the knime business hub.

Could you please advise if/how this would be possible?

Thank you!

create a secret with the credentials. load it, use it as flow variable

1 Like