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

Opens a database connection based on the input settings and reads the entire data table from the database into KNIME.

Input ports
  1. Database Connection Type: Database Query
    Database connection to a table
Output ports
  1. Data read from Database Type: Data
    Database read from database
  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 sour…
    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. 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 transf…
    knime > Examples > 99_Community > 04_Vernalis > 04_Databased_MMP_Example
  4. 01_Guided_Analytics
    Having such a big competition on the market, companies face the problem of defining and implementing right pricing stra…
    mrameez > Public > 01_Guided_Analytics
  5. 01_Guided_Analytics
    Having such a big competition on the market, companies face the problem of defining and implementing right pricing stra…
    knime > Examples > 50_Applications > 44_Price_Benchmarking > 01_Guided_Analytics
  6. add fields to Hive table
    hive sql big data
    There has been no description set for this workflow's metadata.
    mlauber71 > Public > kn_example_bigdata_hive_add_column
  7. KNIME and SQLite - simple example (3.7 Legacy DB nodes)
    sqlite sql db database knime
    this demonstrates the use of a local SQLite database where you can store data and keep the variable type and perform da…
    mlauber71 > Public > sqlite_knime_37 > t_001_sqlite_knime_37_db_legacy
  8. 01_Bioactivity_Prediction_Load_Pull_Data
    This workflow is the first one executed by the model factory. It pulls the data from the ChEMBLdb (https://www.ebi.ac.u…
    knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates > 01_Bioactivity_Prediction_Load_Pull_Data
  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 fir…
    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 PostGreSQ…
    knime > Examples > 08_Other_Analytics_Types > 04_Social_Media > 01_Twitter_meets_PostgreSQL