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

516 results

Filter
Database
SQLite Data access Education Csv Table ETL Excel Read
  1. Go to item
    Workflow
    Database Jam Session
    Database Credentials MySQL
    +8
    This workflow jams together data from not one, not two, but six databases! They are: MySQL, MongoDB, MS SQL Server, MariaDB, Orac…
    knime > Examples > 01_Data_Access > 02_Databases > 08_Database_Jam_Session
    3
    knime
  2. 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
  3. Go to item
    Workflow
    Advanced Query Building
    Database SQL Custom query
    +1
    This workflow shows how to write custom SQL queries using KNIME database nodes with an embedded script editor. These nodes can be…
    knime > Examples > 01_Data_Access > 02_Databases > 15_Advanced_Query_Building
    2
    knime
  4. Go to item
    Workflow
    Database - Simple IO
    Database Io Sqlite
    This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME worflow. It uses the file-based "sqlite" d…
    knime > Examples > 01_Data_Access > 02_Databases > 01_Database_Simple_IO_Example
    2
    knime
  5. Go to item
    Workflow
    Will they blend? MS Access - H2
    Database Microsoft access H2
    +1
    This workflow blends data between two different relational DBMS in KNIME Analytics Platform. It focuses on two common relational …
    knime > Examples > 01_Data_Access > 02_Databases > 07_MSAccess_meets_H2
    2
    knime
  6. 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
  7. Go to item
    Workflow
    Play around with SQLite and Date and Time functions
    Sql Date Time
    +2
    Play around with SQLite and Date and Time functions
    mlauber71 > Public > kn_example_db_sqlite_timestamp
    1
    mlauber71
  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
    Create a SQLite table with R (and manipulate data)
    Sqlite R Database
    Create a SQLite table with R (and manipulate data) You can do all the stuff you want in R and then put the results into SQLite by…
    mlauber71 > Public > kn_example_r_sqlite_multiple_tables_40
    1
    mlauber71
  10. 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
  11. 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
  12. Go to item
    Workflow
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text or using the database nodes.
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.6_20220810 > AdvancedLuck > Chapter2 > 1. Database_Operations
    1
    rs1
  13. Go to item
    Workflow
    Fetch Data from Database
    Life Sciences Database SQLite
    This example workflow shows how to retrieve data from SQLite database. Specifically, it shows how to select columns from a table …
    knime > Workflow Snippets > Fetch_Data_from_Database
    1
    knime
  14. Go to item
    Workflow
    Anonymizing Workflow Service
    Workflow Service Integrated Deployment Database
    This workflow can be used as a workflow service. A caller sends a SQL query and a workflow snippets via the corresponding Workflo…
    knime > Examples > 06_Control_Structures > 07_Workflow_Orchestration > 03_Process_Anonymized_Data > 01_Anonymizer
    1
    knime
  15. Go to item
    Workflow
    Vendor database preparation
    Real World Canvas Database
    +4
    Label compounds from a single vendor. Prepare and filter compounds by various criteria.
    schroedinger > Workflow_examples > Real world > Database preparation > Database preparation 1-3
    1
    schroedinger
  16. Go to item
    Workflow
    Extract SMILES or other data from ChEMBL
    Giribio Nyroindia Chembl
    +5
    Pull any data (SMILES, Activity, Assay, others from ChEMBL via API GET services) Input: CSV or List of ChEMBL ID (Target or Molec…
    nyroindia > Workshops by Girinath (@giribio) on CADD > GGP2113_ChEMBLSMILES
    1
    nyroindia
  17. Go to item
    Workflow
    Load data into Snowflake
    Snowflake Database
    This workflow demonstrates how to load data into Snowflake. It defines a table structure using a DB Table Creator and then bulk l…
    knime > Examples > 01_Data_Access > 02_Databases > 17_Load_data_into_Snowflake
    1
    knime
  18. Go to item
    Workflow
    Chapter 2 / Exercise 3
    SQLite Books Exercise
    +3
    The goal of this exercise is to practice with the Parameterized DB Query Reader node for looping purpose. Extract make, nr_doors,…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > Exercises > Exercise3
    1
    jeany
  19. 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
  20. Go to item
    Workflow
    データベースのトランザクション処理
    Db Database Transaction
    DB Transaction StartノードとDB Transaction Endノードでは、データベーストランザクション、つまり、完全に処理されるか、全く処理されないかの作業単位をモデル化することができます。つまり、DB Transaction Star…
    infocom > Public > 01_データアクセス > 02_データベース > 13_データベースのトランザクション処理
    1
    infocom

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