JDBCProbe API BasicsĮvery JDBCProbe API call will require some initial parameters and values. This script include creates an API for generating the XML payloads on the ECC Queue so that you don’t have to worry about how to represent SQL statements in XML. The plugin will create, among other things, a Script Include called “JDBCProbe”. It is a small plugin that can be enabled in a matter of seconds by ServiceNow. Just request the plugin for your instance via HI, or through your account representative. Unfortunately, what I am about to demonstrate does not come with a vanilla instance, but requires the “Integration – JDBC” plugin. This can be cumbersome, however to build ECC Queue records with XML documents for the queries you wish to make. There is some pretty good ECC Queue – JDBC Probe documentation on the wiki.

What if, however, you want a more transactional data pull…or even to set data in the external database using JDBC? There is a way to do this by creating XML payloads on the ECC queue. This works great for bringing bulk data from an external source into ServiceNow. There is a lesser known JDBC integration interface to ServiceNow than is generally published to the outside world, but it can make JDBC integrations go much smoother that traditionally supported in the ServiceNow product.Ī typical JDBC integration in ServiceNow is usually a data pull from a third party into ServiceNow through a one-time or scheduled JDBC pull using a Data Source record.

Lansweeper integration with servicenow