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.
Options
Connection settings
JDBC Parameters
This tab allows you to define JDBC driver connection parameter. The value of a parameter can be a constant, variable, credential user, credential password or KNIME URL. Please see the KNIME Database Extension Guide for detailed setup examples.
Advanced
This tab allows you to define KNIME framework properties such as connection handling, advanced SQL dialect settings or logging options. If you want to connect to a serverless SQL pool in Azure Synapse Analytics you have to disable the transaction support. To do so uncheck the Enable option in the Transaction section.
Input Type Mapping
This tab allows you to define rules to map from database types to KNIME types.
Output Type Mapping
This tab allows you to define rules to map from KNIME types to database types.
Input Ports
…- 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.
Popular Predecessors
- Excel Writer7 %
- DB Writer4 %
Microsoft Authenticator (Deprecated)4 %- Table Row to Variable Loop Start3 %
- GroupBy3 %
Column Rename2 %- Column Expressions (legacy)2 %
- Credentials Configuration2 %
- Column Filter2 %
Row Filter (deprecated)2 %- Excel Reader2 %
- Variable Creator2 %
- DB Connection Closer1 %
- Column Resorter1 %
- Merge Variables1 %
Row Splitter (deprecated)1 %- Try (Variable Ports)1 %
- Joiner1 %
- Rule-based Row Filter1 %
- DB Insert1 %
- DB SQL Executor1 %
- Credentials Widget1 %
- CSV Reader1 %
- Wait...1 %
- Concatenate1 %
Table Row To Variable Loop Start< 1 %- Create Date&Time Range< 1 %
- String Manipulation (Variable)< 1 %
CASE Switch Variable (End)< 1 %- Column Appender< 1 %
- Loop End< 1 %
- DB Query Reader< 1 %
- Table Creator< 1 %
- Variable Loop End< 1 %
- Duplicate Row Filter< 1 %
- Date&Time Configuration< 1 %
- Java Edit Variable< 1 %
Merge Variables< 1 %- String to Date&Time< 1 %
- Table Row to Variable< 1 %
- Rule Engine< 1 %
- Variable Expressions (legacy)< 1 %
Table Row to Variable< 1 %- DB Update< 1 %
- Container Input (Credentials)< 1 %
- Empty Table Switch< 1 %
- Data to Report (BIRT)< 1 %
Flow Variable IF Switch< 1 %- Java Snippet< 1 %
- String Manipulation< 1 %
CASE Switch Variable (Start)< 1 %- CSV Writer< 1 %
- Delete Files/Folders< 1 %
- Chunk Loop Start< 1 %
- CASE Switch Start< 1 %
- Variable to Credentials< 1 %
- Cache< 1 %
- Transfer Files< 1 %
- String Widget< 1 %
- Time Generator (legacy)< 1 %
- CASE Switch End< 1 %
- R Snippet< 1 %
- Table Writer< 1 %
- Azure Blob Store Connection (legacy)< 1 %
Joiner< 1 %- Missing Value< 1 %
- Date&Time Input (legacy)< 1 %
- Reset on Load< 1 %
- Table Column to Variable< 1 %
- DB Merge< 1 %
- DB Reader< 1 %
- Table Manipulator< 1 %
- Delete Files (legacy)< 1 %
Catch Errors (DB Ports)< 1 %- Extract Variables (Data)< 1 %
Database Writer< 1 %- String to Number< 1 %
- Constant Value Column< 1 %
- RowID< 1 %
- Sorter< 1 %
- Rule Engine Variable< 1 %
- Parallel Chunk Start< 1 %
- DB Connector< 1 %
- Math Formula< 1 %
Excel Reader (XLS)< 1 %- Tableau Writer< 1 %
- String Configuration< 1 %
- Credentials Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Generic Loop Start< 1 %
- Cross Joiner< 1 %
- String Manipulation (Multi Column)< 1 %
- End IF< 1 %
- Send Email< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Loader< 1 %
- DB Table Selector< 1 %
- List Files/Folders< 1 %
- String to Path (Variable)< 1 %
- Column Selection Configuration< 1 %
- Single Selection Configuration< 1 %
- Boolean Widget< 1 %
- Integer Widget< 1 %
- Container Input (Variable)< 1 %
- Single Selection Widget< 1 %
- External Tool< 1 %
- Rule-based Row Splitter< 1 %
- Reference Row Filter< 1 %
- Number Rounder< 1 %
- Counting Loop Start< 1 %
- Column Auto Type Cast< 1 %
- Run Garbage Collector< 1 %
- Number to String< 1 %
- Parquet Writer< 1 %
- Date&Time Shift< 1 %
- Call Workflow Service< 1 %
- Benchmark Start (Flow Variable)< 1 %
- TimeDelay Loop Start< 1 %
Flow Variable End IF< 1 %Generic Loop Start< 1 %- Nominal Value Row Filter< 1 %
- Value Selection Configuration< 1 %
Table Row to Variable< 1 %CSV Reader< 1 %- String Replacer< 1 %
Excel Writer (XLS)< 1 %- Variable to Table Column< 1 %
- Extract Variables (Database)< 1 %
- DB Transaction End< 1 %
- Refresh Button Widget< 1 %
- Container Input (Table)< 1 %
- Container Input (JSON)< 1 %
- Window Loop Start< 1 %
- Catch Errors (Data Ports)< 1 %
MySQL Connector< 1 %Table Column to Variable< 1 %Loop End< 1 %- Group Loop Start< 1 %
- Unpivot< 1 %
- Parquet Reader< 1 %
- Math Formula (Variable)< 1 %
- Container Input (Row)< 1 %
Container Input (Variable)< 1 %- JSON to Table< 1 %
- Python Script (legacy)< 1 %
- URI Port to Variable< 1 %
- Try (Data Ports)< 1 %
- Create File Name (legacy)< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %- Loop End (Column Append)< 1 %
- MySQL Connector< 1 %
- DB Connection Table Writer< 1 %
- Math Formula (Multi Column)< 1 %
- Local File Browser Configuration< 1 %
- Integer Configuration< 1 %
- Multiple Selection Configuration< 1 %
- Integer Input (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Double Widget< 1 %
- Python Edit Variable (legacy)< 1 %
- Catch Errors (Var Ports)< 1 %
CSV Writer< 1 %- Extract Context Properties< 1 %
Table Reader< 1 %- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Reference Row Splitter< 1 %
- Create Temp Dir (legacy)< 1 %
Excel Writer (XLS)< 1 %- Path to String< 1 %
- POST Request< 1 %
- Date&Time Difference< 1 %
Views
- This node has no views
Workflows
00_xplan sf dbconv-insert via xport-AccountKNIME Hub
01 - Geracao_Analiticos_OperacaoKNIME Hub
01_xplan sf dbconv-insert via xport-AddressKNIME Hub- 03 - Importacao_Log_Acionamentos v2KNIME Hub
- 03_Read_and_Write_PNG_Images_in_Databases.knwf 1KNIME Forum
- Show all 108 workflows
Links
- MS SQL database (odbc) connection to KNIMEby izaychik63 on 2020-04-02forum.knime.com/p/86246
- Connection to MS SQL Serverby JanDuo on 2022-01-25forum.knime.com/p/145450
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.