Icon

Exercise 01 Development Data Pipeline - Connect and upload to KNIME Business Hub

There has been no title set for this workflow's metadata.

Learning objective: In this exercise you'll connect to KNIME Business Hub and upload your workflow to KNIME Business Hub.

Workflow description: This workflow showcases the important steps in connecting to KNIME Business Hub and uploading workflows to the Hub. Find below the two major tasks performed in this workflow

Connect to KNIME Business Hub via browser to explore the concept of spaces and teams, then understand how to connect to the KNIME Business Hub from the KNIME Analytics Platform

Upload your workflows from KNIME Analytics Platform to the Business Hub using Space Connector and Workflow Writer nodes

Step 2 : Write the Data Transform workflow to HubWrite the workflow to KNIME Hub SpaceExecute the upstream firstIn the Workflow Writer node, set the output location to write the workflow as:Write to : KNIME Hub SpaceFolder : Create a Deployment Folder to write your workflow on KNME Hub*Make the following changes in the Workflow sectionSelect the option to Overwrite if the workflow existsCheck the 'Use custom workflow name' option and name the workflow as'01_Data_Transformation_wf'*check box to create missing folder Step 1 : Save the workflow to the KNIME HubConnect to KNIME Business Hub on WebpageReceive your personal credentials for the KNIME Business Hub instance from the course trainersConnect to KNIME Business Hub from web browser:Open http://edu-hub.knime.com/ in your web browserlog in with your credentialsExplore the KNIME Business Hub UI:Explore your team page (check which spaces are visible to you, the team members, and team deployments)Explore your user space User## (Note that it is private, check for whom else it is visible)Connect to KNIME Business Hub from KNIME Analytics PlatformClick the "Open Preferences" button at the top-right cornerChoose the "KNIME Explorer" andIn the new window, click NewIn the new window, select KNIME Hub, provide the Hub instance URL, click OKClick Apply and CloseThe Hub mountpoint appeared in the KNIME ExplorerClose the "Preferences" window and click the "Home" tab in the top-left cornerScroll down to "knime-edu-hub" mountpoint and click "Sign in" and enter credentialsExplore how teams and spaces on the KNIME Business Hub in the web browser correspond to to teamsand spaces in the KNIME ExplorerConnect to KNIME Business Hub within the workflowUse Space Connector node to connect to your private space on the KNIME Business HubSet knime-edu-hub as the Hub mountpoint, and select the space (ExerciseSpace-User##) provided by yourcourse instructorConnect the Space System connection node from Space Connector node to the Workflow Writer node <h5>Summarize</h5> <h5>Data Processing</h5> <h5>Sample Data Extract</h5> Write Data Transform workflow to Hub Learning objective: In this exercise you'll connect to KNIME Business Hub and upload your workflow to KNIME Business Hub.Workflow description: This workflow showcases the important steps in connecting to KNIME Business Hub and uploading workflows to the Hub. Find below the two majortasks performed in this workflowConnect to KNIME Business Hub via browser to explore the concept of spaces and teams, then understand how to connect to the KNIME Business Hub from the KNIMEAnalytics PlatformUpload your workflows from KNIME Analytics Platform to the Business Hub using Space Connector and Workflow Writer nodesYou'll find the instructions to the exercises in the yellow annotations. Session 2 - Introduction to KNIME Business HubExercise 1: Connect to KNIME Business Hub Read ordersOct 20 forwardFilterrelevant cols Remove DuplicatesDate&Timeby time,restaurantNode 1560Node 1561Write Capturedworkflow"Price" Columnto Number" Table ID" Columnto NumberNode 1589 SummarizeTimestamp-Hour CSV Reader Column Filter DuplicateRow Filter String to Date&Time Sorter CaptureWorkflow Start CaptureWorkflow End Workflow Writer String To Number String To Number Space Connector Step 2 : Write the Data Transform workflow to HubWrite the workflow to KNIME Hub SpaceExecute the upstream firstIn the Workflow Writer node, set the output location to write the workflow as:Write to : KNIME Hub SpaceFolder : Create a Deployment Folder to write your workflow on KNME Hub*Make the following changes in the Workflow sectionSelect the option to Overwrite if the workflow existsCheck the 'Use custom workflow name' option and name the workflow as'01_Data_Transformation_wf'*check box to create missing folder Step 1 : Save the workflow to the KNIME HubConnect to KNIME Business Hub on WebpageReceive your personal credentials for the KNIME Business Hub instance from the course trainersConnect to KNIME Business Hub from web browser:Open http://edu-hub.knime.com/ in your web browserlog in with your credentialsExplore the KNIME Business Hub UI:Explore your team page (check which spaces are visible to you, the team members, and team deployments)Explore your user space User## (Note that it is private, check for whom else it is visible)Connect to KNIME Business Hub from KNIME Analytics PlatformClick the "Open Preferences" button at the top-right cornerChoose the "KNIME Explorer" andIn the new window, click NewIn the new window, select KNIME Hub, provide the Hub instance URL, click OKClick Apply and CloseThe Hub mountpoint appeared in the KNIME ExplorerClose the "Preferences" window and click the "Home" tab in the top-left cornerScroll down to "knime-edu-hub" mountpoint and click "Sign in" and enter credentialsExplore how teams and spaces on the KNIME Business Hub in the web browser correspond to to teamsand spaces in the KNIME ExplorerConnect to KNIME Business Hub within the workflowUse Space Connector node to connect to your private space on the KNIME Business HubSet knime-edu-hub as the Hub mountpoint, and select the space (ExerciseSpace-User##) provided by yourcourse instructorConnect the Space System connection node from Space Connector node to the Workflow Writer node <h5>Summarize</h5> <h5>Data Processing</h5> <h5>Sample Data Extract</h5> Write Data Transform workflow to Hub Learning objective: In this exercise you'll connect to KNIME Business Hub and upload your workflow to KNIME Business Hub.Workflow description: This workflow showcases the important steps in connecting to KNIME Business Hub and uploading workflows to the Hub. Find below the two majortasks performed in this workflowConnect to KNIME Business Hub via browser to explore the concept of spaces and teams, then understand how to connect to the KNIME Business Hub from the KNIMEAnalytics PlatformUpload your workflows from KNIME Analytics Platform to the Business Hub using Space Connector and Workflow Writer nodesYou'll find the instructions to the exercises in the yellow annotations. Session 2 - Introduction to KNIME Business HubExercise 1: Connect to KNIME Business Hub Read ordersOct 20 forwardFilterrelevant cols Remove DuplicatesDate&Timeby time,restaurantNode 1560Node 1561Write Capturedworkflow"Price" Columnto Number" Table ID" Columnto NumberNode 1589SummarizeTimestamp-Hour CSV Reader Column Filter DuplicateRow Filter String to Date&Time Sorter CaptureWorkflow Start CaptureWorkflow End Workflow Writer String To Number String To Number Space Connector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: maarit.widmann
Created at: 2022-11-04
On NodePit since: 2024-03-14
Last update: 2024-04-27
Created with KNIME version: v5.1.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!