Hub

516 results

Filter
Database
SQLite Data access Education Csv Table ETL Excel Read
  1. 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. 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. 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. 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
  5. 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
  6. 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. 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
  8. 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
  9. 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. 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. 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
  12. 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
  13. 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
  14. 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 > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 4_Examples > 01_Database_Simple_IO_Example
    1
    knime
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. Workflow
    Identify tables in you database(s) and loop over them and store the data in a CSV file
    Sql Sqlite Loop
    +2
    Identify tables in you database(s) and loop over them and store the data in a CSV file
    mlauber71 > Public > kn_example_db_loop_multiple_tables
    1
    mlauber71