Database 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. Type: Database Query
    Database connection to a table

Output Ports

  1. Type: Data
    Database read from database

  1. Geolocation IP static 2013

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

  2. 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…
    Users > knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates

  3. 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…
    Users > knime > Examples > 08_Other_Analytics_Types > 04_Social_Media

  4. 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…
    Users > knime > Examples > 06_Control_Structures > 03_Flow_Variables

  5. Will they blend? MS Access - H2

    This workflow blends data between two different relational DBMS in KNIME Analytics Platform. It focuses on two common re…
    Users > knime > Examples > 01_Data_Access > 02_Databases

  6. Database Sampling

    This workflow creates an SQL statement that allows you to extract a sample of data from a database. The node also suppor…
    Users > knime > Examples > 01_Data_Access > 02_Databases

  7. 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…
    Users > knime > Examples > 09_Enterprise > 02_WebPortal

  8. Basic RESTful Web Services Example 1

    Demonstrates how to create a REST-based web service that can be deployed via the KNIME Server.
    Users > knime > Examples > 09_Enterprise > 01_Server > 01_RESTful_Services

  9. Database - Read/Write PNG images

    This workflow demonstrates how you to read/write png images from/to a database. The Binary Object nodes are available vi…
    Users > knime > Examples > 01_Data_Access > 02_Databases

  10. 01_Guided_Analytics

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

Extension

This node is part of the extension

KNIME Core

 v4.0.0

Short Link

Drag node into KNIME Analytics Platform