Test JDBC activity template inputs

You can test the input parameters of a custom JDBC activity during its development without having to run the activity in a workflow context.

Before you begin

Create input variables and map them to fields in the Execution Command form or provide actual values for these fields. Role required: web_service_admin, activity_admin, activity_creator

About this task

This test executes only the input parameters against an endpoint and not the pre-processing or post-processing scripts. It is not necessary to check out the activity to test it.
Note: If you provide enough information for Orchestration to contact the endpoint or host and return data, you can test the input variables. You can test from any stage in the activity designer. Typically, the Execution Command stage is the point at which your inputs are ready for testing.

Procedure

  1. From the JDBC Execution Command, click Test Inputs.
    The list of input source variables appears. If you added default values for these variables, those values appear in the Substitute Value column. Mandatory variables are marked with a red star.
    Note: The test fails if the MID Server cannot be found or if it cannot connect to the target.
    Figure 1. JDBC input test values
    JDBC input test values
  2. Filter the variable list with these controls:
    • All Inputs: Displays all input variables. This control is the default view.
    • Mandatory Inputs: Displays only mandatory variables.
    • Inputs Without Defaults: Shows input variables that do not have assigned default values.
  3. Reset values as needed.
    • Reset default values: If values are present, this control replaces any test values set in this form with the default values.
    • Clear values: Clears all values in the input variable list, even if default values exist.
  4. When your test values are configured correctly, click OK.
    The system runs the values for all the inputs configured against the specified target and returns the resulting payload. The buttons in the Response form display different views of the payload. The entire payload appears in the Raw Output window.
    Figure 2. Response payload from inputs test
    Response payload from inputs test
  5. To map appropriate parameter values in the payload to variables in the Outputs stage automatically, select an auto-mapping option.

  6. Click the X in the upper right corner of the window to close it.