Icon

m_​001_​h2_​db

H2 java based database example

H2 is a free database you can use with KNIME either as a file on your drive or as an in memory DB

https://forum.knime.com/t/how-to-save-to-excel-sheet-thousands-of-matrices/17935/4?u=mlauber71KNIME, Databases and SQLhttps://medium.com/low-code-for-advanced-data-science/knime-databases-and-sql-273e27c9702a Example how to use H2 databases in KNIME H2 databaseshttps://www.h2database.com/html/main.htmlhttp://www.h2database.com/html/features.htmlhttp://www.h2database.com/html/advanced.html#passwords in memorylocal H2 fileget tablesSELECT * FROM INFORMATION_SCHEMA.TABLESget tablesSELECT * FROM INFORMATION_SCHEMA.TABLESPUBLIC.airqualitycount measures per daylocal filewith passwordUSER = knime_userPASSWORD = 123on tab JDBC drivertry to accessfile withoutpassword H2 Connector H2 Connector DB Query Reader Rule-basedRow Filter Rule-basedRow Filter DB Query Reader memory local file csv files DB Table Selector DB GroupBy H2 Connector with password H2 Connector https://forum.knime.com/t/how-to-save-to-excel-sheet-thousands-of-matrices/17935/4?u=mlauber71KNIME, Databases and SQLhttps://medium.com/low-code-for-advanced-data-science/knime-databases-and-sql-273e27c9702a Example how to use H2 databases in KNIME H2 databaseshttps://www.h2database.com/html/main.htmlhttp://www.h2database.com/html/features.htmlhttp://www.h2database.com/html/advanced.html#passwords in memorylocal H2 fileget tablesSELECT * FROM INFORMATION_SCHEMA.TABLESget tablesSELECT * FROM INFORMATION_SCHEMA.TABLESPUBLIC.airqualitycount measures per daylocal filewith passwordUSER = knime_userPASSWORD = 123on tab JDBC drivertry to accessfile withoutpasswordH2 Connector H2 Connector DB Query Reader Rule-basedRow Filter Rule-basedRow Filter DB Query Reader memory local file csv files DB Table Selector DB GroupBy H2 Connector with password H2 Connector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2019-09-07
On NodePit since: 2019-10-12
Last update: 2024-05-01
Created with KNIME version: v4.7.6
Tags: H2databasesql

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!