Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Loader (deprecated)
NodeNode / Sink

DB Loader (deprecated)

DB Read/Write Streamable

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

Like
Copy short link

This node uses database specific bulk loading functionality that only some databases (e.g. Hive, MySQL, PostgreSQL and H2) support to load large amounts of data into an existing database table.
Notice:
Most databases do not perform data checks when loading the data into the table which might lead to a corrupt data table . The node does some preliminary checks such as checking that the column order and column names are compatible. However it does not check the column type compatibility. So before using this node please make sure that the column types of the KNIME columns and the database columns are compatible.

Depending on the database an intermediate file format is often used for efficiency which might be required to upload the file to a server. If a file needs to be uploaded, any of the protocols supported by the file handling nodes can be used, e.g. for Apache Hive HDFS or webHDFS. After the loading of the data into a table, the uploaded file gets deleted if it is no longer needed by the database.

If there is no need to upload or store the file for any reason, a remote file input connection prevents execution.

Some databases such as MySQL and PostgreSQL support file based and memory based uploading which require different rights in the database. If this is the case and if you do not have the rights to execute the file based loading of the data try the memory based method instead. If supported the different modes can be changed in the Loader mode section of the "Options" tab which is otherwise hidden.

Depending on the connected database the dialog settings may change. For example, MySQL and PostgreSQL use a CSV file for the data transfer. In order to change how the CSV file is created go to the "Advanced" tab.

Node details

Input ports
  1. Type: Table
    Data to load into the database
    A KNIME data table containing the data rows to load into the database.
  2. Type: DB Session
    DB Connection
    DB Connection to the database.
  3. Type: Remote Connection
    Connection information port
    An optional file connection for uploading or storing the intermediate file.
Output ports
  1. Type: DB Data
    DB Data
    DB Data referencing the selected database table.

Extension

The DB Loader (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    deprecated_db_loader
    ana_ved > Public > deprecated_db_loader
    ana_ved
  2. Go to item
    Create HIVE table and show the way it was created and describe the structure
    Hive Big data Knime
    +3
    Create a Big Data table, show the structiure and fields
    mlauber71 > Public > kn_example_hive_create_table_show_describe
    mlauber71
  3. Go to item
    01_Flight_Delay_Statistics
    tobias.koetter > Public > Big_Data_Workshop_2020 > 01_Flight_Delay_Statistics
    tobias.koetter
  4. Go to item
    データベース構造の操作
    Database Utility DB
    +4
    このワークフローでは、ローカルデータのテーブルをデータベースに移動したり、その逆を行ったりする方法を紹介します。データは、直接データベースに読み込むことも、テーブルの構造を最初に…
    infocom > Public > 01_データアクセス > 02_データベース > 16_データベース構造の操作
    infocom
  5. Go to item
    Create HIVE table and show the way it was created and describe the structure
    Hive Big data Knime
    +3
    Create a Big Data table, show the structiure and fields
    mbergman > Public > kn_example_hive_create_table_show_describe
    mbergman
  6. Go to item
    01_Flight_Delay_Statistics_Impala
    bjoern.lohrmann > Public > Big_Data_Workshop_2020 > 01_Flight_Delay_Statistics_Impala
    bjoern.lohrmann
  7. Go to item
    Working with Google cloud services
    Google Bigquery Cloud storage
    +2
    This workflow demonstrates how to connect to various Google Cloud Services such as Google…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 04_GoogleCloudExample
    knime
  8. Go to item
    Working with Azure services
    Azure Microsoft Hdinsight
    +6
    This workflow demonstrates how to connect to various Azure services such as HDInsight clu…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 09_AzureExample
    knime
  9. Go to item
    Working with Azure services
    Azure Microsoft Hdinsight
    +6
    This workflow demonstrates how to connect to various Azure services such as HDInsight clu…
    andisa.dewi > Public > 09_AzureExample
    andisa.dewi
  10. Go to item
    Working with Azure services
    Azure Microsoft Hdinsight
    +6
    This workflow demonstrates how to connect to various Azure services such as HDInsight clu…
    dedalo > Public > 09_AzureExample
    dedalo

No known nodes available

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