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. 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

  2. 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

  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…
    knime > Examples > 08_Other_Analytics_Types > 04_Social_Media > 01_Twitter_meets_PostgreSQL

  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. 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

  6. Basic RESTful Web Services Example 1

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

  7. 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…
    knime > Examples > 01_Data_Access > 02_Databases > 03_Read_and_Write_PNG_Images_in_Databases

  8. 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…
    knime > Examples > 01_Data_Access > 02_Databases > 07_MSAccess_meets_H2

  9. Database Sampling

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

  10. Big Data Preprocessing

    Hive Hadoop Big Data SQL in-database
    This workflow demonstrates the usage of the database nodes in conjunction with the Hive Connector node, which is part of…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 01_Big_Data_Preprocessing_Example