Hub

407 results

Filter
Database
SQLite Data access Education ETL Csv
+11
  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
  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
  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
  4. 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
  5. 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
  6. 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
  7. 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
  8. Workflow
    データベースのトランザクション処理
    Db Database Transaction
    DB Transaction StartノードとDB Transaction Endノードでは、データベーストランザクション、つまり、完全に処理されるか、全く処理されないかの作業単位をモデル化することができます。つまり、DB Transaction Star…
    infocom > Public > 01_データアクセス > 02_データベース > 13_データベースのトランザクション処理
    1
  9. 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
  10. 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
    1
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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…
    1
  17. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    burdhasp > Public > Exercises - L1-DW KNIME Analytics Platform for Data Wranglers - Basics > 02 Accessing Databases
    0
  18. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    kellytm2 > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 02 Accessing Databases
    0
  19. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    the32bitphoenix > Public > Excercises 1 - Data Wrangler Beginner > 02 Accessing Databases
    0
  20. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    zangyun_928 > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 02 Accessing Databases
    0