Hub
NodeNode / Source

DB Connector

DB Connection
Drag & drop
Like
Copy short link

This node creates a connection to an arbitrary JDBC database. You need to select an appropriate driver and provide the JDBC URL of the database (which is database specific). New database drivers are registered via the KNIME preferences page. Login credentials can either be provided directly in the configuration or via credential variables. For more details see the database documentation .

Node details

Output ports
  1. Type: DB Session
    DB Connection
    DB Connection to the database.

Extension

The DB Connector node is part of this extension:

Related workflows & nodes

  1. dq-demo-regular-exp
    mraraman > Public > IPF > dq-demo-regular-exp
  2. dq-demo-regular-exp
    alamisrar > Public > IPF > dq-demo-regular-exp
  3. test 1
    liuzhang > Public > test 1
  4. 01 DB Connect Exercise Solution
    Big Data Education
    Big Data Course DB Exercise #1 Solution
    yzer > Public > 01_DB_Connect
  5. 01 DB Connect Exercise Solution
    Big Data Education
    Big Data Course DB Exercise #1 Solution
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 3_Solutions > 01_DB_Connect
  6. Will They Blend? Teradata Aster - KNIME Table
    Teradata Database Data blending
    +3
    Today's challenge is to blend the data between a Teradata Aster database and a KNIME tabl…
    knime > Examples > 01_Data_Access > 02_Databases > 09_Teradata_Aster_meets_KNIME_Table
  7. Will They Blend? Teradata Aster - KNIME Table
    Teradata Database Data blending
    +3
    Today's challenge is to blend the data between a Teradata Aster database and a KNIME tabl…
    haoran > Public > 01_Data_Access > 02_Databases > 09_Teradata_Aster_meets_KNIME_Table
  8. Chapter 2 / Exercise 2
    Books KNIME Advanced Luck Exercise
    +3
    Reads dataset cars-85 from KCBBook.sqlite DB, prepared in exercise1. The goal of this exe…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > Exercises > Exercise2
  9. Lieferanten test
    jhein > Public > Lieferanten test
  10. Chapter 2 / Exercise 2
    Books KNIME Advanced Luck Exercise
    +3
    Reads dataset cars-85 from KCBBook.sqlite DB, prepared in exercise1. The goal of this exe…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter2 > Exercises > Exercise2