How can I connect a DataBase of MS SQL SERVER to KNIME?


I’m trying to know how connect a database of Microsoft SQL Server to Knime with the node of Microsoft SQL Server Connector? I do not know really well how to configure the node? Where do I have to search on Microsoft SQL Server to configure the node?

Please, I really need help for this.

Hello @LilianaGarcia ,

have you checked Database Guide? Each configuration field is explained in it and there is even examples on how to connect to some databases including Microsoft SQL Server.

Seems you should start from there and then ask if you don’t manage to connect or have a specific configuration question :wink:



That’s all there is to it:

But I would recommend using the official Microsoft SQL driver, I had quite a few problems with the default driver. The microsoft sql driver can be installed as a knime extension:

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.