Hub

388 results

Filter
Database
SQLite Data access Education ETL Csv
+9
  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
    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
  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
    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
  9. 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
  10. Workflow
    データベースのトランザクション処理
    Db Database Transaction
    DB Transaction StartノードとDB Transaction Endノードでは、データベーストランザクション、つまり、完全に処理されるか、全く処理されないかの作業単位をモデル化することができます。つまり、DB Transaction Star…
    infocom > Public > 01_データアクセス > 02_データベース > 13_データベースのトランザクション処理
    1
  11. 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
  12. 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
  13. 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
  14. Workflow
    02 Database Data Manipulation
    Database SQLite
    Exercise for database data manipulation. Write a local data table into a database. Aggregate, join, and filter the data on the da…
    natand51 > Public > Lab4-NathanAnderson > Custom Data Workflows > Exercises(CustomData) > 02 Database Data Manipulation
    0
  15. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    jalvear > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 02 Accessing Databases
    0
  16. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    elzamc > Public > MICAH ELZA L1-DW AND CUSTOMS > Exercises Micah Elza > 02 Accessing Databases
    0
  17. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    fuschiefox > IT 4015 snavelmy Projects > IT 4015 Project 1 > worked_on > 02 Accessing Databases
    0
  18. Workflow
    08 Database Data Manipulation
    Sqlite Database
    Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data directly on the da…
    jalvear > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 08 Database Data Manipulation
    0
  19. Workflow
    Chapter 2 / Exercise 2
    Books KNIME Advanced Luck Exercise
    +3
    Reads dataset cars-85 from KCBBook.sqlite DB, prepared in exercise1. The goal of this exercise is to read data from a database an…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.5_2022011 > AdvancedLuck > Chapter2 > Exercises > Exercise2
    0
  20. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    kellej6 > IT4015 Applied Business Intelligence > Lab 1 > L1-Airport Data > Exercises > 02 Accessing Databases
    0