JDBCProbe
A JDBC probe runs on the MID Server to query an external database via JDBC and returns results to ServiceNow.
Before you begin
Role required: admin
About this task
Probes interact with the MID Server through the ECC Queue. The JDBC probe response returns as an XML payload in an input ECC Queue record. By default, each response payload contains up to 200 rows. To change this limit, set the jdbcprobe_result_set_rows probe parameter to the desired number.
Contact Customer Service and Support to activate the Integration - JDBC (com.snc.integration.jdbc) plugin.
Procedure
Navigate to System Definition > Plugins.
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.
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.
Select Activate.
Direct JDBC Probe
A direct JDBC probe specifies all the parameters necessary in the outbound ECC Queue XML payload.- JDBC Probes via Data Source
JDBC probes are executed via a JDBC data source when an import is running against the data source. - Select * JDBC Probe short cut
Alternatively, you may specify a table_name parameter instead of a work element and the following query could be executed. - Parameters
The following parameters are available in a direct JDBC probe. - Using the Work Element
The work element encodes SQL statements to be executed by the probe.
Parent Topic:Supported integration interfaces