NodeDB Table Selector

Source

This node takes a DB Connection as input and allows to select a table or view from within the connected database. The node outputs a DB Data object which contains the database connection information as well as a database query that defines the data in the database.
In addition, this node allows to enter a customized SELECT statement which is then propagated to all connected nodes.

Input ports

  1. DB Connection Type: DB Session
    DB Connection to connecto to the database.

Output ports

  1. DB Data Type: DB Data
    DB Data referencing the data in the database.

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

  2. Exporting Data - Solution

    export write pmml deployment BIRT report pdf education
    Solution to the exercise 6 for KNIME User Training - Writing data to a file - Writing a model to a PMML model file - Cre…
    knime > Education > 01 KNIME User Training > solutions > 06. Exporting Data - solution

  3. m_001_h2o_sparkling_water

    Combine Big Data, Spark and H2O.ai Sparkling Water
    mlauber71 > kn_example_h2o_sparkling_water > m_001_h2o_sparkling_water

  4. Credit Scoring

    Credit Scoring Credit Rating Customer Risk Decision Tree Neural Network SVM
    This KNIME workflow focuses on creating a credit scoring model based on historical data. As with all data mining modelin…
    maarit > Component Story > Workflows > Building a Credit Scoring Model_3

  5. Visualization - Solution

    visualization scatter plot line plot stacked area chart bar chart histogram composite view component JavaScript interactive view pivoting education
    Solution to the exercise 3 for KNIME User Training - Use different colors for different products in the data - Visualize…
    knime > Education > 01 KNIME User Training > solutions > 03. Visualization - solution

  6. Send data to tableau server example

    Tableau
    This workflow reads the data of the last 24 hours from a database and sends it to a tableau server. If the workflow is u…
    kathrin > Forum_Question_Tableau_Example > Send_Data_to_Tableau_Server

  7. Visualization

    visualization scatter plot line plot stacked area chart bar chart histogram composite view component JavaScript interactive view pivoting education
    Exercise 3 for KNIME User Training - Use different colors for different products in the data - Visualize data in a Scatt…
    knime > Education > 01 KNIME User Training > exercises > 03. Visualization

  8. Database

    database H2 database preprocessing education
    Exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggregating data in …
    knime > Education > 01 KNIME User Training > exercises > 11. Database

  9. Data Manipulation

    ETL concatenate join preprocessing remove duplicates transform replace education
    Exercise 2 for KNIME User Training - Concatenate data from two different sources - Bring values from a reference table t…
    knime > Education > 01 KNIME User Training > exercises > 02. Data Manipulation

  10. Data Mining

    machine learning data mining classification regression prediction model evaluation scoring ROC Curve clustering k-Means decision tree linear regression partitioning education
    Exercise 4 for KNIME User Training - Training a Decision Tree to predict a nominal target column - Evaluate the model pe…
    knime > Education > 01 KNIME User Training > exercises > 04. Data Mining