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. 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
  2. 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
  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. Advanced Row Filtering
    row filter advanced row filter
    Not only simple filtering with the Row Filter node, but also: filtering according to more complex rules with Nominal Val…
    knime > Examples > 02_ETL_Data_Manipulation > 01_Filtering > 04_Advanced_Row_Filters
  5. Geolocalization IP dynamic 2013
    This example-workflow demonstrates how a weblog can be used to create a video showing the nationality of the visitors on…
    knime > Examples > 03_Visualization > 04_Geolocation > 02_Dynamic_geolocation_of_IP_addresses
  6. In-Database Processing on SQL Server
    ETL KNIME Microsoft Azure In database Processing SQL Server
    This workflow shows how to perform in-database processing on Micrsoft SQL Server. It starts with a dedicated SQL Server …
    knime > Examples > 40_Partners > 01_Microsoft > 01_SQL_Server_InDB_Processing(Azure)
  7. Mix and Match Predictive Approach. From Hive through In-Database Processing till KNIMEAnalytics Model Training.
    Hive ETL KNIME Microsoft Azure In database Processing HDInsight
    This workflow reads CENSUS data from a Hive database in HDInsight; it then performs some In-Database Processing on Hive;…
    knime > Examples > 40_Partners > 01_Microsoft > 03_HDI_Hive_KNIME
  8. All inside BigData Predictive Approach. From Hive through Spark ETL till Spark Model Training.
    Hive ETL KNIME Microsoft Azure Spark HDInsight
    This workflow reads CENSUS data from a Hive database in HDInsight; it then moves to Spark where it performs some ETL ope…
    knime > Examples > 40_Partners > 01_Microsoft > 04_HDI_Hive_Spark
  9. Spark SQL meets Hive SQL. Age distribution for Men and Women in Maine (US) over the last 5 years.
    Spark Hive Hadoop Big Data SQL in-database
    This workflow builds a line plot of the age distribution for men and women in Maine (US) over the last 5 years. In parti…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 07_SparkSQL_meets_HiveQL
  10. 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 > Public > DB > dbLooping_parameterized