Input node for making a SQL query and creating work items for each row.




Module name of the database driver to use.


Database connection string.

Use Custom Script

This specifies if the node should use a custom user provided script.

Script Path

If "Use Custom Script" is true, this is the path to search for the script.

Table Name

The SQL table name.

Force Regenerate Query

Regenerates the query based on the current parameters.

Extract All

This is used to decide if the node will generate a query using SELECT *.


This is used to decide if the node will generate a query using SELECT DISTINCT.


An integral limit for the LIMIT clause.


This is the number of columns.

Column Name

Column name.

Rename Column/Tag

Column alias.

PDG Value Index

This is used to determine the PDG value index.

PDG Data Type

This is used to determine the PDG data type.


If true, result will be sorted using the "Sort Index" and "Sort Type" parameters.

Sort Index

This is the index used when sorting the columns.

Sort Type

This is used to determine if the sorting should be ascendent or descendent.

Generated Query

Override Query

If true, the query will be defined by the "Query" parameter instead of generating one.


If "Override Query" is true, this is the SQL query to be executed.


Work Item Generation

Whether this node generates static or dynamic work items. You should generally leave this set to "Automatic" unless you know the node’s work items can be computed statically, or that they need to be generated dynamically.


This node always creates dynamic work items: it waits until the upstream work items are known, and generates new work items from the upstream work items.


This node always creates static work items: it creates the number of work items it thinks it needs based on the parameters (and any upstream static items) before the network runs.


If the input is static (a static processor, or a partitioner with only static inputs, or a mapper), this node generates static work items, otherwise it generates dynamic work items.

TOP nodes