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. For more information about the supported driver properties see the SQLite documentation.
Advanced
This tab allows you to define KNIME framework properties such as connection handling, advanced SQL dialect settings or logging options.
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.
Popular Predecessors
- Reset on Load7 %
- CSV Writer6 %
- Column Expressions5 %
Row Filter (deprecated)3 %- Table Row to Variable Loop Start3 %
- DB Connection Closer2 %
- Java Edit Variable (simple)2 %
Table Row to Variable2 %- DB SQL Executor2 %
- Variable Creator2 %
- Create File/Folder Variables2 %
- Table Manipulator2 %
- Container Input (Variable)2 %
- Create File Name (legacy)2 %
Table Row To Variable Loop Start2 %- Merge Variables2 %
- Credentials Widget2 %
- File Reader2 %
- Java Edit Variable2 %
- Create Folder2 %
- URL to File Path (Variable)1 %
- Wait...1 %
- Try (Variable Ports)1 %
Loop End1 %- String Manipulation (Variable)1 %
- Credentials Configuration1 %
- Table Row to Variable1 %
- Path to String (Variable)1 %
- String to Path1 %
- String to Path (Variable)1 %
- Refresh Button Widget1 %
- Container Input (JSON)1 %
- Column Resorter1 %
- Create Temp Folder1 %
- Path to String1 %
- Sorter1 %
- Generic Loop Start1 %
- Credentials Input (legacy)1 %
CASE Switch Variable (Start)1 %- File Upload Widget1 %
Table Reader< 1 %- Variable Expressions< 1 %
- String Input (legacy)< 1 %
- Python View (legacy)< 1 %
- Workflow Service Input< 1 %
- Create Directory (legacy)< 1 %
- Duplicate Row Filter< 1 %
Column Rename< 1 %- String Manipulation< 1 %
- Create Temp Dir (legacy)< 1 %
Excel Writer (XLS)< 1 %- String Configuration< 1 %
- Table Row To Variable Run-to-time Loop Start< 1 %
- Table Column to Variable< 1 %
Database Writer< 1 %- DB Reader< 1 %
- Excel Writer< 1 %
- Delete Files/Folders< 1 %
- Value Selection (legacy)< 1 %
- Benchmark Start< 1 %
Table Row to Variable< 1 %File Reader< 1 %- Table Creator< 1 %
- Group Loop Start< 1 %
- Concatenate< 1 %
- Column Filter< 1 %
- GroupBy< 1 %
- SQLite Connector< 1 %
- DB Writer< 1 %
- DB Table Selector< 1 %
Excel Sheet Appender (XLS)< 1 %- Local File Browser Configuration< 1 %
- String Widget< 1 %
Python Script (1⇒2)< 1 %- Python Edit Variable (legacy)< 1 %
- Download (legacy)< 1 %
- Variable Loop End< 1 %
- Domain Calculator< 1 %
- Data Generator< 1 %
- Capture Workflow Start< 1 %
- Excel Reader< 1 %
- List Files/Folders< 1 %
Transfer Files< 1 %- File Upload (legacy)< 1 %
- Single Selection (legacy)< 1 %
- R Snippet< 1 %
- GET Request< 1 %
Views
- This node has no views
Workflows
00 Send Reporting_vMediumKNIME Hub- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- Show all 1936 workflows
Links
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.