DB SQL - H2 Database, Insert Data - Bulk, Load and SQL Executor
DB SQL - H2 Database, insert data in various ways. Including INSERT VALUE statement with Flow Variables
URL: DB SQL - H2 Database, Insert Data - Bulk, Load and SQL Executor - KNIME Forum (77635) https://forum.knime.com/t/which-node-to-use/77635/15?u=mlauber71
URL: Insert Coordinates as Point into PostgreSQL database - KNIME Forum (77635) https://forum.knime.com/t/which-node-to-use/77635/17?u=mlauber71
URL: Medium Blog: KNIME, Databases and SQL https://medium.com/p/273e27c9702a
Nodes
- DB Reader (Labs)6 ×
- DB SQL Executor (Labs)5 ×
- DB Table Remover (Labs)4 ×
- Column Filter3 ×
- DB Table Creator3 ×
- DB Table Selector (Labs)3 ×
- Column Renamer2 ×
- DB Insert (Labs)2 ×
- DB Writer2 ×
- String Manipulation2 ×
- Table Row to Variable Loop Start2 ×
- Variable Loop End2 ×
- Cell Splitter1 ×
- Insert Column Header1 ×
- Coordinate Parser1 ×
- Coordinate to Latitude/Longitude1 ×
- DB Loader1 ×
- Date&Time Part Extractor1 ×
- Extract Table Spec1 ×
- H2 Connector (Labs)1 ×
- Latitude/Longitude to Coordinate1 ×
- Map Viewer1 ×
- Math Formula (Multi Column)1 ×
- Number To String1 ×
- OSM Map View1 ×
- Partitioning1 ×
- PostgreSQL Connector (Labs)1 ×
- Row Filter (Labs)1 ×
- RowID1 ×
- String Manipulation (Multi Column)1 ×
- Table Creator1 ×
- Table Writer1 ×
- Test Data Generator1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Database
- FeatureKNIME Javasnippet
- FeatureKNIME Math Expression (JEP)
- FeatureKNIME Open Street Map Integration
- Show all 7 modules
Links
- No links available