Icon

Callee_​DB_​Access

<p>A Callee workflow being called from "Caller Callee - Parallel Access to SQL Database" with a database</p>

URL: use parallel chunks to call a sub-workflow to access a database/SQL connection https://forum.knime.com/t/parallel-processing-of-multiple-excel-files-based-on-dynamic-sheet-names-from-list-files-folders-node-in-knime/84034/7?u=mlauber71

A Callee workflow being called from "Caller Workflow with parallel Access to SQL Database" with a database connection coming in

https://forum.knime.com/t/parallel-processing-of-multiple-excel-files-based-on-dynamic-sheet-names-from-list-files-folders-node-in-knime/84034/7?u=mlauber71

In order to get a Workflow Service Input / Output other than the table connection you have to:

  • drag the connection of the type you want from the previous node

  • until a transparent plus sign appears

  • then you search for the "Workflow Service Output"

  • when you click this it will change the type from table to the type you were just dragging along ....

THX to Linh for this insight ...

https://forum.knime.com/t/call-workflow-table-based-additional-table-input-ports-possible/83894/2?u=mlauber71

Workflow Input
Workflow Input
in case the chunk comeswith more than one line
Table Row to Variable Loop Start
Variable Loop End
DB Reader
Create File/Folder Variables
Excel Writer
Workflow Output
table name provided by theCaller workflow
DB Table Selector

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: marti
Created at: 2024-10-23
On NodePit since: 2024-10-28
Last update: 2026-09-10
Created with KNIME version: v5.12.0
Tags: Callee

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

Try NodePit Runner!