Database Reader (legacy)

Source

This node is part of the legacy database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

Establishes and opens a database access connection to read data from.

If the optional input is connected the database connection information is taken from the port, otherwise you need to specify the connection information in the dialog.

Make sure you have your vendor-specific database driver registered in the KNIME preference page (section Database Driver).

Input Ports

  1. Type: Database Connection
    An optional database connection that should be used instead of providing the connection information in the dialog. (optional)

Output Ports

  1. Type: Data
    Table with data read from the database

  1. Database - Simple IO

    Demonstrates using Database Reader and Database Writer nodes in a simple KNIME worflow.
    Users > knime > Examples > 01_Data_Access > 02_Databases

  2. Database connectors

    Users > thegreatcat

  3. Create ESCO network with SQLite

    OrientDB NoSQL network analysis
    This workflow creates an ESCO network with SQLite. It pulls data from text files - ESCO dataset - places them in a datab…
    Users > knime > Examples > 40_Partners > 05_Redfield > 01_KNIME_meets_OrientDB

  4. Snowflake meets Tableau

    snowflake data warehouse Hyper Tableau KNIME
    This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales …
    Users > knime > Examples > 01_Data_Access > 02_Databases

  5. Will They Blend? Teradata Aster - KNIME Table

    Teradata database data blending KNIME Table .table
    Today's challenge is to blend the data between a Teradata Aster database and a KNIME table in the KNIME Analytics Platfo…
    Users > knime > Examples > 01_Data_Access > 02_Databases

  6. MMP Databased Example with Fingerprint Databasing

    Matched Molecular Pairs MMP MMPA Fingerprint Database
    This is a more complex Matched Molecular Pairs (MMP) example, in which we demonstrate storing fragmentations and transfo…
    Users > knime > Examples > 99_Community > 04_Vernalis

  7. Twitter Data Analysis

    This workflow examines a sample of tweets from the days surrounding the scottisch referendum for independence in 2014 [1…
    Users > knime > Examples > 50_Applications > 19_TwitterAnalysis

Extension

This node is part of the extension

KNIME Core

 v4.0.0

Short Link

Drag node into KNIME Analytics Platform