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