Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Test JDBC activity template inputs

Log in to subscribe to topics and get notified when content changes.

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: You can test input variables from any stage in the activity designer if you have provided enough information for Orchestration to contact the endpoint or host and return data. Typically, the Execution Command stage is the point at which your inputs are ready for testing.


  1. In the activity designer, proceed to the Execution Command stage.
  2. Define an appropriate MID Server, if requested.
    The test fails if the MID Server cannot be found or if it cannot connect to the target.
  3. 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.
    Figure 1. JDBC input test values
    JDBC input test values
  4. Filter the variable list with these controls:
    • All Inputs: Displays all input variables. This is the default view.
    • Mandatory Inputs: Displays only mandatory variables.
    • Inputs Without Defaults: Shows input variables that do not have assigned default values.
  5. Reset values as needed.
    • Reset default values: Replaces any test values set in this form with the default values, if they are present.
    • Clear values: Clears all values in the input variable list, even if default values exist.
  6. 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
  7. To map appropriate parameter values in the payload to variables in the Outputs stage automatically, select an auto-mapping option.
  8. Alternately, you can click Save for parsing rules to copy the entire payload to the parsing rules.
    This allows you to manually select values for the output variables directly from the payload. This action completely overwrites any previous payload that existed in the parsing rules.
  9. Click the X in the upper right corner of the window to close it.