Hub

643 results

Filter
Filter by tag
DB
Database
SQLite Education Data access Csv Table ETL Excel Read Connection Community Nodes
+6
  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
    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
  3. 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
  4. 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
    2
    mlauber71
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. Workflow
    Example how to use H2 database with a uuid unique identifier
    H2 Sql Create
    +6
    Example how to use H2 database with a uuid unique identifier
    mlauber71 > Forum > 2021 > kn_forum_36064_db_h2_use_uuid_unique_identifier
    1
    mlauber71
  12. 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
  13. 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
  14. 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
  15. 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
  16. Workflow
    データベースのトランザクション処理
    Db Database Transaction
    DB Transaction StartノードとDB Transaction Endノードでは、データベーストランザクション、つまり、完全に処理されるか、全く処理されないかの作業単位をモデル化することができます。つまり、DB Transaction Star…
    infocom > Public > 01_データアクセス > 02_データベース > 13_データベースのトランザクション処理
    1
    infocom
  17. Workflow
    Will they blend? Twitter and PostgreSQL Database
    Data blending Database PostGreSQL
    +2
    This is a mini-workflow for Data WareHousing, in particular it archiviates daily tweets. History is saved in a PostgreSQL databas…
    knime > Examples > 08_Other_Analytics_Types > 04_Social_Media > 01_Twitter_meets_PostgreSQL
    1
    knime
  18. 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
  19. 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
  20. 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