JDBCProbe

A JDBC probe runs on the MID Server to query an external database via [JDBC] and returns results to ServiceNowServiceNow.

About this task

Probes interact with the MID Server via the ECC Queue, therefore the response of a JDBC probe returns as an XML payload in an "input" ECC Queue record. By default, each response payload will contain up to 200 returned rows, this value can be modified by setting the probe parameter jdbcprobe_result_set_rows to the desired number.

Activating the Plugin

Contact Customer Support to activate the Integration - JDBC (com.snc.integration.jdbc) plugin.

Procedure

  1. Navigate to System Definition > Plugins.
  2. Right-click the plugin name on the list and select Activate/Upgrade.

    If the plugin depends on other plugins, these plugins and their activation status are listed.

  3. [Optional] Select the Load demo data check box.

    Some plugins include demo data—sample records that are designed to illustrate plugin features for common use cases. Loading demo data is a good policy when first activating the plugin on a development or test instance. You can load demo data after the plugin is activated by repeating this process and selecting the check box.

  4. Click Activate.