Here is a list taken from the ServiceNow JDBCProbe wiki for setting up your connection string:

Each Database has its own connection string format. IBM DB2 Universal: .DB2DriverĬonnection String: The JDBC protocol uses a connection string to establish the authentication and other parameters to establish a connection between the client and the Database. For this example, I am using a MySQL database. This is specific to the type of Database you are calling into. I am going to use my MID Server, “DEB1” for these examples.ĭriver: You need to specific the JDBC Driver that will be used to make the JDBC call. Here is what my MID Server list looks like: Specify the name of the MID Server as it it shown in the MID Server list. MID Server: The JDBCProbe requires a MID Server for execution. 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.

Servicenow lansweeper integration