Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Type Mapper
NodeNode / Manipulator

DB Type Mapper

DB Utility
Drag & drop
Like
Copy short link

Change the database to KNIME type mapping configuration for subsequent nodes based column name and database type or only database type. The dialog allows you to add new or change existing type mapping rules. It does not allow you to delete existing mapping rules. All rules from the input DB Data port that are not changed in the node dialog and forwarded unaltered to subsequent nodes e.g. if one of thes mappings changes in a predecessor node these changes are propagated to all subsequent nodes of the DB Type Mapper node.

Node details

Input ports
  1. Type: DB Data
    DB Data
    DB Data with the input database to KNIME type mapping configuration.
Output ports
  1. Type: DB Data
    DB Data
    Data object with the changed database to KNIME type mapping configuration.

Extension

The DB Type Mapper node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Working with JSON columns in PostgreSQL
    JSON Db PostgreSQL
    +1
    This workflow demos how to write and read PostgreSQL JSON columns from within the KNIME A…
    tobias.koetter > Public > DB > PostgreSQL > PostgresJSON
    tobias.koetter
  2. Go to item
    Database Structure Manipulation
    Database Utility DB
    +4
    This workflow shows how to move a local data table into a database, and vice versa. Data …
    knime > Examples > 01_Data_Access > 02_Databases > 16_Database_Structure_Manipulation
    knime
  3. Go to item
    データベース構造の操作
    Database Utility DB
    +4
    このワークフローでは、ローカルデータのテーブルをデータベースに移動したり、その逆を行ったりする方法を紹介します。データは、直接データベースに読み込むことも、テーブルの構造を最初に…
    infocom > Public > 01_データアクセス > 02_データベース > 16_データベース構造の操作
    infocom
  4. Go to item
    Database Structure Manipulation
    Database Utility DB
    +4
    This workflow shows how to move a local data table into a database, and vice versa. Data …
    haoran > Public > 01_Data_Access > 02_Databases > 16_Database_Structure_Manipulation
    haoran
  5. Go to item
    DB_practice_v01
    khs > Public > DB_practice_v01
    khs
  6. Go to item
    Rossmann - DB - Time Series
    mwysocki > Public > Rossmann - DB - Time Series
    mwysocki
  7. Go to item
    Rossmann - DB - Time Series(2)
    mwysocki > Public > Rossmann - DB - Time Series(2)
    mwysocki
  8. Go to item
    beta
    deepsika > Public > beta
    deepsika
  1. 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