NodeDB Query Reader

Source

Executes an entered SQL query and returns the result as KNIME data table.

Input ports

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

Output ports

  1. KNIME data table Type: Data
    KNIME data table with the result from the database query.

  1. Data Blending and ETL

    Sources SQLite Data Blending ETL
    Task. Starting from different data sources this workflow shows how to blend data (extract value from multiple data sourc…
    baishikele_hw > Example Workflows > Basic Examples > Data Blending

  2. DB reading on a server from inside the workflow

    beginner DB database sqlite
    An example how to access an SQLite DB file inside workflow. Works both locally and on a KNIME Server. Example for https:…
    lisovyi > forum > 11962

  3. Listado EESS

    tomasmaria > Listado EESS

  4. DB Looping Component for new DB Framework

    This workflow provides a component that emulates the functionality of the Database Looping (legacy) node for the nde dat…
    tobias.koetter > DB > dbLooping

  5. DB Looping and Parameterized Reader Nodes

    This workflow demonstrates the legacy Database Looping and Parameterized Database Query node as well as the new Paramete…
    tobias.koetter > DB > dbLooping_parameterized

  6. DB reading on a server from inside the workflow

    beginner DB database sqlite
    An example how to access an SQLite DB file inside workflow. Works both locally and on a KNIME Server. Example for https:…
    lisovyi > forum > 11962_rel372

  7. Oracle Data Pagination using ROWNUM

    db oracle loop window
    This workflow loops over data in an Oracle database using the ROWNUM function and between.
    tobias.koetter > DB > Oracle Data Pagination