Hub
NodeNode / Source

Microsoft SQL Server Connector (legacy)

DB Database (legacy) Connector (legacy)
Drag & drop
Like
Copy short link

This node is part of the legacy database framework and will be deprecated at the end of 2022. For more information on how to migrate to the new database framework see the migration section of the database documentation .

This node creates a connection to a Microsoft SQL Server via the available 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 or via credentials set on the workflow.

By default the open source driver jTDS is used. Visit the jTDS Project for more information. It is also possible to register additional drivers in the preferences.

Node details

Output ports
  1. Type: Database Connection
    Database JDBC Connection
    A database JDBC connection

Extension

The Microsoft SQL Server Connector (legacy) node is part of this extension:

Related workflows & nodes

  1. Mix and Match Predictive Approach. From BlobStorage and SQL Server through In-Database Processing till KNIMEAnalytics Model Training.
    BlobStorage ETL KNIME
    +4
    This workflow reads CENSUS data from a SQL Server database; it then performs some In-Data…
    knime > Examples > 40_Partners > 01_Microsoft > 02_SQLServer_BlobStorage_andKNIMEModels
    tobias.koetter
  2. In-Database Processing on SQL Server
    ETL KNIME Microsoft
    +3
    This workflow shows how to perform in-database processing on Micrsoft SQL Server. It star…
    knime > Examples > 40_Partners > 01_Microsoft > 01_SQL_Server_InDB_Processing(Azure)
    tobias.koetter
  3. Clustered Seguros
    martinduarte > Public > Clustered Seguros
    martinduarte