Scripting the JDBCProbe

[john_andersen]

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.

A 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. This works great for bringing bulk data from an external source into ServiceNow.

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. There is some pretty good ECC Queue — JDBC Probe documentation on the wiki. This can be cumbersome, however to build ECC Queue records with XML documents for the queries you wish to make. There is a much easier way...[Read More]