Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • H2 Connector
NodeNode / Source

H2 Connector

DB Connection
Drag & drop
Like
Copy short link

This node creates a connection to a H2 database file via its JDBC driver. You need to provide the path to the database file or the name when using in-memory mode. No username and password are required for H2 databases.

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.

Node details

Output ports
  1. Type: DB Session
    DB Connection
    H2 DB Connection.

Extension

The H2 Connector node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    01 Practicing with Traditional Databases
    Big data Database
    L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipulate database ta…
    knime > Education > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 01 Practicing with Traditional Databases
    knime
  2. Go to item
    01 Practicing with Traditional Databases
    Big data Database
    L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipulate database ta…
    tqthanh168 > Public > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 01 Practicing with Traditional Databases
    tqthanh168
  3. Go to item
    01 Practicing with Traditional Databases
    Big data Database
    L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipulate database ta…
    halverdog > Public > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 01 Practicing with Traditional Databases
    halverdog
  4. Go to item
    01 Practicing with Traditional Databases
    Big data Database
    L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipulate database ta…
    manuel1972 > Public > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 01 Practicing with Traditional Databases
    manuel1972
  5. Go to item
    Writing data into a database
    Database Db
    This workflow uses the new database framework to write a KNIME table into a database tabl…
    tobias.koetter > Public > DB > Writing data into a database
    tobias.koetter
  6. Go to item
    Query reader modified
    adrix > Public > workflow_HUB > Query reader modified
    adrix
  7. Go to item
    Using virtual db instead of cross join and rule-based filter
    Scenario: We have a loopup table of Cities and we want to retrieve the cities whose name …
    bruno29a > Public > Demo > Using virtual db instead of cross join and rule-based filter
    bruno29a
  8. Go to item
    Working with user-defined database variables
    Db Database Variable
    This workflow demonstrates how you can create user-defined database variables in KNIME us…
    tobias.koetter > Public > DB > DBVariables
    tobias.koetter
  9. Go to item
    Just KNIME It Challenge 5 - Date to Fiscal Year
    Justknimeit-5
    In the accounting firm you work for, you are given contracts which were executed on diffe…
    bruno29a > Public > Just Knime It Challenges > Just KNIME It Challenge 5
    bruno29a
  10. Go to item
    Advanced Query Building
    Database SQL Custom query
    +1
    This workflow shows how to write custom SQL queries using KNIME database nodes with an em…
    knime > Examples > 01_Data_Access > 02_Databases > 15_Advanced_Query_Building
    knime
  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits