NodeDatabase Connection Table 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.

Opens a database connection based on the input settings and reads the entire data table from the database into KNIME.

Input ports

  1. Database Connection Type: Database Query
    Database connection to a table

Output ports

  1. Data read from Database Type: Data
    Database read from database

  1. Will they blend? Twitter and PostGreSQL Database

    data blending database PostGreSQL Twitter
    This is a mini-workflow for Data WareHousing, in particular it archiviates daily tweets.History is saved in a PostGreSQL…
    knime > Examples > 08_Other_Analytics_Types > 04_Social_Media > 01_Twitter_meets_PostgreSQL

  2. Geolocation IP static 2013

    This example demonstrates how to analyze a weblog and display the most prominent nationalities of visitors by percent an…
    knime > Examples > 03_Visualization > 04_Geolocation > 01_Static_geolocation_of_IP_addresses

  3. Workflow variable connections to control execution order

    This workflow shows how to use workflow variable connections to control the execution order of nodes. Note that the firs…
    knime > Examples > 06_Control_Structures > 03_Flow_Variables > 02_Using_Flow_Variables_to_control_Execution_Order

  4. 01_Bioactivity_Prediction_Load_Pull_Data

    This workflow is the first one executed by the model factory. It pulls the data from the ChEMBLdb (https://www.ebi.ac.uk…
    knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates > 01_Bioactivity_Prediction_Load_Pull_Data

  5. 01_Guided_Analytics

    Having such a big competition on the market, companies face the problem of defining and implementing right pricing strat…
    mrameez > 01_Guided_Analytics

  6. 01_Guided_Analytics

    Having such a big competition on the market, companies face the problem of defining and implementing right pricing strat…
    knime > Examples > 50_Applications > 44_Price_Benchmarking > 01_Guided_Analytics

  7. Database Jam Session

    database credentials MySQL MongoDB Oracle MariaDB PostgreSQL MS SQL Server
    This workflow jams together data from not 1, not 2, but from 6 databases! That is: MySQL, MongoDB, MS SQL Server, MariaD…
    knime > Examples > 01_Data_Access > 02_Databases > 08_Database_Jam_Session

  8. Databases - Advanced Usage

    Shows a KNIME workflow with a number of database nodes that directly work inside a database. Note, this flow uses the sq…
    knime > Examples > 01_Data_Access > 02_Databases > 02_Database_Advanced_Example

  9. 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…
    knime > Examples > 99_Community > 04_Vernalis > 04_Databased_MMP_Example

  10. Demonstration of the KNIME Webportal

    This workflow will allow the user to pick a data source and do some decision tree model learning on it. Valid data sourc…
    knime > Examples > 09_Enterprise > 02_WebPortal > 01_Example_for_a_Data_Mining_WebPortal