Hub
NodeNode / Source

DB Connector

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. DB Connection Type: DB Session
    DB Connection to the database.

Related workflows & nodes

  1. Rossmann - DB - Time Series(2)
    mwysocki > Public > Rossmann - DB - Time Series(2)
  2. Snowflake meets Tableau
    snowflake data warehouse Hyper +2
    This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales…
    knime > Examples > 01_Data_Access > 02_Databases > 11_Snowflake_meets_Tableau
  3. Lieferanten test
    jhein > Public > Lieferanten test
  4. Snowflake meets Tableau
    snowflake data warehouse Hyper +2
    This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales…
    ryannewsome > Public > 11_Snowflake_meets_Tableau
  5. Snowflake meets Tableau
    snowflake data warehouse Hyper +2
    This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales…
    lcs > Public > 01_Data_Access > 02_Databases > 11_Snowflake_meets_Tableau
  6. 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
  7. 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 exercise is to read data from a d…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > Exercises > Exercise2
  8. Will They Blend? Teradata Aster - KNIME Table
    Teradata database data blending +2
    Today's challenge is to blend the data between a Teradata Aster database and a KNIME table in the KNIME Analytics Platf…
    lcs > Public > 01_Data_Access > 02_Databases > 09_Teradata_Aster_meets_KNIME_Table
  9. Database Operations
    KNIME Advanced Luck Books Database +2
    This workflow shows how to connect to a database and implement SQL queries, as free text or using the database nodes.
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > 1. Database_Operations
  10. Database Jam Session
    database credentials MySQL +5
    This workflow jams together data from not one, not two, but six databases! They are: MySQL, MongoDB, MS SQL Server, Mar…
    lcs > Public > 01_Data_Access > 02_Databases > 08_Database_Jam_Session