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

Output Ports

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

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

  2. 01-FIRST_project

    danieltm1987 > 01-FIRST_project

  3. Basic RESTful Web Services Example 2

    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 > 02_Create_basic_service2

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

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

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

  7. Database Pivot

    This workflow creates an SQL statement that generates a pivot table. A pivot table allows you to quickly summarize your …
    knime > Examples > 01_Data_Access > 02_Databases > 05_Pivoting_in_Databases

  8. Mix and Match Predictive Approach. From BlobStorage and SQL Server through In-Database Processing till KNIMEAnalytics Model Training.

    BlobStorage ETL KNIME Microsoft Azure In database Processing SQL Server
    This workflow reads CENSUS data from a SQL Server database; it then performs some In-Database Processing on SQL Server; …
    knime > Examples > 40_Partners > 01_Microsoft > 02_SQLServer_BlobStorage_andKNIMEModels

  9. Model Deployment SQL Recoding

    Deployment File Database SQL Recoding PMML Java Model Prediction Flight Delay
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads new unseen data from a database, …
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding

  10. Google Big Query meets SQLite. The business of baseball games.

    Databases Google Big Query Big Query SQLite Sunburst Chart Bar Chart Baseball Weather
    This workflow graphically explores attendance at baseball games together with weather conditions and calendar informatio…
    knime > Examples > 01_Data_Access > 02_Databases > 10_GoogleBigQuery_meets_SQLite