NodeDatabase Table Selector (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.

This node takes a database connection as input and allows selecting a table based on the incoming database JDBC connection. The node outputs the incoming connection together with the query which can later on be used in subsequent database manipulation nodes.

Input ports

  1. Database JDBC Connection Type: Database Connection
    A database connection to select a table from

Output ports

  1. Database Connection Type: Database Query
    A database connection with an initial table

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

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

  3. Big Data Analytics - Model Selection to Predict Flight Departure Delays on Hive & Spark

    data blending data science machine learning Hadoop Spark model selection data preparation ETL airline data set flight delay
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to p…
    knime > Examples > 50_Applications > 28_Predicting_Departure_Delays > 02_Scaling_Analytics_w_BigData

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

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

  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…
    knime > Examples > 01_Data_Access > 02_Databases > 06_Sampling_in_Databases

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

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

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

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