This page explains how to set the value of a variable using the output of a database connector without using scripts or Java code.
You can initialize single valued items and multivalued items. The connector automatically populates the data structure of the variable.
Before you configure the database connector, define the pool-level variable to be initialized. If you do not define the variable first, you can define it from inside the wizard but only at the level when the connector is defined. This means that if you define the connector on a service task, which is recommended, the variable is only available in that service task.