JDBCProbe › Supported integration interfaces › Integration options › Integration with third-party applications and data sources › Integrations › Configure core features › Administer the ServiceNow AI Platform

Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Parameters

The following parameters are available in a direct JDBC probe.

Parameter	Description
jdbc_driver	Required. Java class name for the JDBC driver to use, the currently supported drivers are:- Oracle: `oracle.jdbc.OracleDriver` - Microsoft SQL Server: `com.microsoft.sqlserver.jdbc.SQLServerDriver` - MySQL: `com.mysql.jdbc.Driver`

Example

com.microsoft.sqlserver.jdbc.SQLServerDriver

Parameter Description

connection_string

Required. The JDBC connection string/URL for defining the connection usually contains information about the database server and name, the user ID, and password for connecting to the database. The syntax is vendor-specific. See the following links for reference:- Oracle: `[jdbc:oracle:thin:@]` - Microsoft SQL Server: `[jdbc:sqlserver://localhost;user=MyUserName;password=*****;]` - MySQL - `[jdbc:mysql://localhost/database?user=username%26password=passwd]`

Example

jdbc:sqlserver://xxx.service-now.com;
databaseName=SMS;
user=sms_user;
password=sms_password;

Parameter	Description
work	Required if not using the table_name parameter short cut. Parent element of an XML fragment describing the SQL command to execute.

Example

...
  <parameter name= "work" ><select table = "System_DATA" where = "InstanceKey=692" ><MachineID /><SMSID0 /></select></parameter>
  ...

Parameter	Description
query_timeout	Optional during SELECT. Number of seconds the JDBC driver waits for a `query (SELECT)` to complete. Zero means no timeout. If timeout is exceeded, the integration considers the JDBC result inaccessible and places it in an error state.

Parameter	Description
table_name	Optional (except required during `count_rows == true`).Alternate way of executing a `select ` query; instead of using the work* element. Equivalent to executing `select * from <table_name>`.

Parameter	Description
count_rows	Optional. Indicates whether a `select count()` query should return the number of rows (true/false). The result of the count is returned as a row_countelement in the result* element.

Parameter	Description
query	Optional. Type of query. Possible choices are "All Rows from Table" or "Specific SQL." If "Specific SQL", the sql_statement will be required to specify the SQL statement.

Parameter	Description
sql_statement	Optional. Use a specific SQL query. The presence of this element executes a direct query specified in the value attribute.

Example

...
  select * from any_table where id = 123
  ...

Parameter	Description
skip_sensor	Optional. Determines if Discovery attempts to process the ECC input from the JDBCProbe. Default = true

For example, to query a table using a direct JDBC probe, requires the following parameters:

JDBC driver class name
JDBC connection string
- Database server
- Database name
- User name
- User password
The table name

Parent Topic:JDBCProbe