Hub

146 results

Filter
Filter by tag
Db
Database SQL SQLite Education Books KNIME Advanced Luck Database preprocessing Life science Read/Write Apache Spark
+6
  1. Workflow
    Model Deployment SQL Recoding
    Deployment File Database
    +7
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads new unseen data from a database, reads the…
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding
    0
    knime
  2. Node / Manipulator
    DB SQL Executor
    DB Utility
    This node allows custom SQL statements to be executed on the input database. The output port can be used for flow control, to pre…
    0
    knime
  3. Workflow
    Recommending Restaurants Using Association Rules
    Recommendation engine Retail Supply chain
    +3
    In this workflow we demonstrate how to use the KNIME Spark nodes for giving locality recommendations. For this we are using the Y…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 08_Learning_Asociation_Rule_for_Next_Restaurant_Prediction
    0
    knime
  4. Node / Source
    Microsoft SQL Server Connector
    DB Connection
    This node creates a connection to a Microsoft SQL Server, an Azure SQL Database or Azure Synapse SQL pool via its JDBC driver. Yo…
    0
    knime
  5. Node / Source
    DB Remove SQL From connection
    Community Nodes Vernalis Databases
    +1
    The node strips the empbedded SQL statement(s) out of a database connection, leaving only the authenticated database connection T…
    0
    vernalis
  6. 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
  7. Workflow
    Working with PL/SQL Procedures in Oracle
    Db Stored procedure Oracle
    This workflow demonstrates how work with stored procedures in Microsoft SQL Server. The workflow first creates a stored procedure…
    tobias.koetter > Public > DB > Oracle > OracleStoredProcedure
    0
    tobias.koetter
  8. Workflow
    Titanic KNIME Beispiel (deutsch) - SQL Datenbanken mit KNIME
    Knime Titanic Einführung
    +6
    Titanic: Machine Learning from Disaster https://www.kaggle.com/c/titanic Einführung in KNIME (deutsch) - https://hub.knime.com/ml…
    mlauber71 > Public > knime_einfuehrung_beispiel_titanic > m_150_sql_database_titanic
    0
    mlauber71
  9. 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
  10. Workflow
    DB Looping Example
    DB Read/Write DB Loop
    +4
    This workflow demonstrates the usage of the DB Looping node. The node allows the user to write a SQL query that uses the values f…
    knime > Examples > 01_Data_Access > 02_Databases > 24_DB_Looping
    1
    knime
  11. Workflow
    Database Pivot
    Database Pivoting
    This workflow creates an SQL statement that generates a pivot table. A pivot table allows you to quickly summarize your data base…
    knime > Examples > 01_Data_Access > 02_Databases > 05_Pivoting_in_Databases
    0
    knime
  12. Workflow
    Database Pivot
    Database Pivoting
    This workflow creates an SQL statement that generates a pivot table. A pivot table allows you to quickly summarize your data base…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 4_Examples > 05_Pivoting_in_Databases
    0
    knime
  13. 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
  14. Workflow
    Database Sampling
    Database Stratified sampling Sqlite
    This workflow creates an SQL statement that allows you to extract a sample of data from a database. The node also supports strati…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 4_Examples > 06_Sampling_in_Databases
    0
    knime
  15. Workflow
    Database Sampling
    Database Stratified sampling Sqlite
    This workflow creates an SQL statement that allows you to extract a sample of data from a database. The node also supports strati…
    knime > Examples > 01_Data_Access > 02_Databases > 06_Sampling_in_Databases
    0
    knime
  16. Workflow
    KNIME_Demo Oracle Stored Procs and Functions
    Oracle Stored Procedures User Defined Functions
    +5
    Demonstration workflow showing how to execute both DML and DDL statements against an Oracle database. Procedure calls can be made…
    takbb > Public > KNIME_Demo Oracle Stored Procs and Functions
    0
    takbb
  17. Node / Other
    Impala to Spark
    Tools & Services Apache Spark IO
    +1
    Imports the result of an incoming Impala query into Spark as a DataFrame/RDD. The query is executed using Spark SQL, which suppor…
    0
    knime
  18. Node / Other
    Hive to Spark
    Tools & Services Apache Spark IO
    +1
    Imports the result of an incoming Hive query into Spark as a DataFrame/RDD. The query is executed using Spark SQL, which supports…
    0
    knime
  19. Workflow
    Connect to Microsoft SQL Server with Azure Active Directory Authentication
    Database Sqlserver Aad
    +1
    This workflow describes how to connect to Microsoft SQL Server with Azure Active Directory authentication using the latest JDBC d…
    tobias.koetter > Public > DB > MSSQL > MSSQL_AAD_interactive
    0
    tobias.koetter
  20. 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