Database 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. Type: Database Connection
    A database connection to select a table from

Output Ports

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

  1. Basic RESTful Web Services Example 2

    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

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

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

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

  5. Dimensionality Reduction

    This workflow shows 7 methods for dimensionality reduction: 1. High ratio of missing values 2. Low variance 3. High corr…
    Users > knime > Examples > 04_Analytics > 01_Preprocessing

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

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

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

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

  10. 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
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to p…
    Users > knime > Examples > 50_Applications > 28_Predicting_Departure_Delays

Extension

This node is part of the extension

KNIME Core

 v4.0.0

Short Link

Drag node into KNIME Analytics Platform