Referencing SQL Access objects from a Business Process

Reference an SQL Access from a Business Process by adding it to the Business Process and creating variables or parameters for the object.

If you haven't already created this object, see Creating SQL Access objects and Defining SQL Access objects.
  1. In the Business Process editor, under the Script section, click the Add button.
  2. Under the Task column, click Click to select task. In the selector window, type sql in the filter field to show only the SQL Access objects.
  3. Double-click the SQL Access object to be referenced.
  4. With the SQL Access object task highlighted, specify the value for its parameters in the Properties view. These values will correspond to the parameters set in the SQL Access editor.
  5. Click Click to Set Value in the first parameter.
    • If the parameter should be populated with an already existing variable or parameter, select that variable or parameter.
    • If the parameter is an output parameter and an existing variable doesn't exist, create a New Variable or New Parameter. In the (Parameters or Variables) area, type a Name for it, define its Type, and, if necessary, assign an Initial Value.
    • If hard coding a constant value into the parameter, click the String Literal tab and type your constant value into the field. (only for input parameters)
    Press Enter.

    Repeat this step for each parameter.

  6. With the SQL Access object task highlighted, use the Up and Down arrows to move it to the correct position in its sequence.
  7. In the Label column, type a label for this task.