Microsoft SQL Server Connector

This node creates a connection to a Microsoft SQL Server, an Azure SQL Database or Azure Synapse SQL pool via its JDBC driver. You need to provide the server's hostname (or IP address), the port, and a database name. Login credentials can either be provided directly in the configuration, via credential variables or via the dynamic input port. Please see the KNIME Database Extension Guide for detailed setup examples.

In order to use the official driver from Microsoft you either need to install the KNIME Microsoft JDBC Driver For SQL Server extension or manually register it due to license restrictions.

This node uses the selected driver's JDBC URL template to create the concrete database URL. Field validation in the dialog depends on whether the (included) tokens referencing them are mandatory or optional in the template.

Output ports

1. Type: DB Session
   DB Connection
   Microsoft SQL Server DB Connection.

Microsoft Authentication (Dynamic Inport)

When available the node will set the accessToken JDBC parameter automatically based on the information from the connected Microsoft Authenticator node. Depending on your database setup you might need to specify additional JDBC parameters which are described in the Microsoft documentation.

1. Type: org.knime.credentials.base.CredentialPortObject