This node creates a connection to a Microsoft SQL Server or an Azure SQL Database 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.