Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Reader
NodeNode / Source

DB Reader

Uncategorized Streamable

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

Like
Copy short link

Executes the input query in the database and retrieves the result into a KNIME data table.
If the node consumes a lot of memory you might want to decrease the "Fetch size" in the "Advanced" tab of the corresponding connector node. The fetch size specifies how many rows are fetched from the database server into KNIME per network round trip. The higher the number the more memory is consumed. However the smaller the number the more network round trips are necessary to fetch large results. Also not all JDBC driver support this option and thus might ignore it.

Node details

Input ports
  1. Type: DB Data
    DB Data
    DB Data connection with the query to execute.
Output ports
  1. Type: Table
    KNIME data table
    KNIME data table with the result form the database query.

Extension

The DB Reader node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    KNIME Tweet Analysis
    Text processing NLP Natural Language Processing
    This workflow performs textprocessing on KNIME tweets using the Dictionary Tagger (Multi …
    knime > Examples > 08_Other_Analytics_Types > 01_Text_Processing > 24_Analyzing_Twitter_Posts_with_Custom_Tagging
    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits