Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Search

136 results

Filter
Filter by tag
DB
Database Release 4.6 Sql Snowflake CI Churn Customer Intelligence Connection Community Nodes Databases
+5
  1. Go to item
    Workflow
    Working with Database Transactions
    Db Database Transaction
    The DB Transaction Start and DB Transaction End nodes allow you to model a database transaction, i.e. a unit of work that is eith…
    knime > Examples > 01_Data_Access > 02_Databases > 13_DBTransactionExample
    2
    knime
  2. Go to item
    Node / Manipulator
    DB Concatenate
    DB Query
    This node concatenates two database tables. The table at inport 0 is given as the first input table (top input port), the table a…
    2
    knime
  3. Go to item
    Node / Source
    DB Table Selector
    DB Query
    This node takes a DB Connection as input and allows to select a table or view from within the connected database. The node output…
    2
    knime
  4. Go to item
    Workflow
    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 Analytics Platform.
    tobias.koetter > Public > DB > PostgreSQL > PostgresJSON
    1
    tobias.koetter
  5. Go to item
    Workflow
    Returning data for modified rows in PostgreSQL
    PostgreSQL Database Db
    This workflow demonstrates how the DB Query Reader node can be used to execute a DML statement that returns the changed values. T…
    tobias.koetter > Public > DB > PostgreSQL > PostgresInsertWithReturn
    1
    tobias.koetter
  6. Go to item
    Workflow
    KNIME and SQLite - simple example (4.0 New DB nodes)
    DB Sqlite R
    +2
    this demonstrates the use of a local SQLite database where you can store data and keep the variable type and perform database ope…
    mlauber71 > Public > sqlite_knime_40 > t_001_sqlite_knime_40_db_nodes
    1
    mlauber71
  7. Go to item
    Workflow
    Transferring data between databases
    Database Db Streaming
    +2
    This workflow demonstrates how data can be transferred between two different databases using the KNIME Streaming Execution. When …
    tobias.koetter > Public > DB > DBStreamingDataTransfer
    1
    tobias.koetter
  8. Go to item
    Workflow
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
    Database Sql Hive
    +11
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark) KNIME as a powerful data anaylytics platfo…
    mlauber71 > Public > _db_sql_bigdata_hive_spark_meta_collection
    1
    mlauber71
  9. Go to item
    Workflow
    データベースのトランザクション処理
    Db Database Transaction
    DB Transaction StartノードとDB Transaction Endノードでは、データベーストランザクション、つまり、完全に処理されるか、全く処理されないかの作業単位をモデル化することができます。つまり、DB Transaction Star…
    infocom > Public > 01_データアクセス > 02_データベース > 13_データベースのトランザクション処理
    1
    infocom
  10. Go to item
    Workflow
    Working with Databricks
    Big data Databricks Spark
    +2
    This workflow demonstrates the usage of the Create Databricks Environment node which allows you to connect to a Databricks Cluste…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 03_DatabricksExample
    1
    knime
  11. Go to item
    Node / Source
    Amazon Athena Connector
    DB Connection
    This node creates a connection to Amazon Athena using the native Amazon Athena JDBC driver. You need to provide the server's host…
    1
    knime
  12. Go to item
    Node / Source
    ChEMBL-DB Extractor
    LigandScout Database
    The ChEMBL-DB Extractor node fetches molecules from the ChEMBL database that show activity towards selected targets.
    1
    inteligand
  13. Go to item
    Node / Manipulator
    DB Joiner
    DB Query
    This node joins two DB Data tables. The join is based on the joining columns of both tables.
    1
    knime
  14. Go to item
    Node / Source
    DB Looping
    DB Read/Write Streamable
    This node runs SQL queries in the connected database restricted by the possible values given by the input table. It restricts eac…
    1
    knime
  15. Go to item
    Node / Source
    DB Query Reader
    DB Read/Write
    Executes an entered SQL query and returns the result as KNIME data table.
    1
    knime
  16. Go to item
    Node / Source
    DB Reader
    DB Read/Write Streamable
    Executes the input query in the database and retrieves the result into a KNIME data table. If the node consumes a lot of memory y…
    1
    knime
  17. Go to item
    Node / Sink
    DB Writer
    DB Read/Write Streamable
    Inserts data rows into the database based on the selected columns from the input table. If the database table does not exist it w…
    1
    knime
  18. Go to item
    Node / Source
    Hive Connector
    DB Connection
    This node creates a connection to Apache Hive™ via JDBC. You need to provide the server hostname (or IP address), the port, and a…
    1
    knime
  19. Go to item
    Node / Source
    SQLite Connector
    DB Connection
    This node creates a connection to a SQLite database file via its JDBC driver. You need to provide the path to the database file o…
    1
    knime
  20. Go to item
    Workflow
    Working with Database Transactions
    Db Database Transaction
    The DB Transaction Start and DB Transaction End nodes allow you to model a database transaction, i.e. a unit of work that is eith…
    haoran > Public > 01_Data_Access > 02_Databases > 13_DBTransactionExample
    0
    haoran

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