---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://www.servicenow.com/docs/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Parameters

# Parameters {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

The following parameters are available in a direct JDBC probe.
{#r_DirectJDBCProbeParameters__table_k4c_ywv_4y__entry__2}

| 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` {#r_DirectJDBCProbeParameters__ul_cxm_1xv_4y} |
[ ]

{#r_DirectJDBCProbeParameters__table_k4c_ywv_4y}  
**Example**

    com.microsoft.sqlserver.jdbc.SQLServerDriver

{#r_DirectJDBCProbeParameters__table_dtt_fwv_4y__entry__2}

| 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:<username/password>@<database>]` * Microsoft SQL Server: `[jdbc:sqlserver://localhost;user=MyUserName;password=*****;] ` * MySQL - `[jdbc:mysql://localhost/database?user=username%26password=passwd]` {#r_DirectJDBCProbeParameters__ul_u24_3wv_4y} |
[ ]

{#r_DirectJDBCProbeParameters__table_dtt_fwv_4y}  
**Example**

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

{#r_DirectJDBCProbeParameters__table_wvq_5vv_4y__entry__2}

| 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. |
[ ]

{#r_DirectJDBCProbeParameters__table_wvq_5vv_4y}  
Example

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

{#r_DirectJDBCProbeParameters__table_srm_4vv_4y__entry__2}

| 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. |
[ ]

{#r_DirectJDBCProbeParameters__table_srm_4vv_4y} {#r_DirectJDBCProbeParameters__table_c2c_z5v_4y__entry__2}

| 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>`. |
[ ]

{#r_DirectJDBCProbeParameters__table_c2c_z5v_4y} {#r_DirectJDBCProbeParameters__table_mfp_15v_4y__entry__2}

| 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_count element in the result element. |
[ ]

{#r_DirectJDBCProbeParameters__table_mfp_15v_4y} {#r_DirectJDBCProbeParameters__table_lw2_qtv_4y__entry__2}

| 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. |
[ ]

{#r_DirectJDBCProbeParameters__table_lw2_qtv_4y} {#r_DirectJDBCProbeParameters__table_sbn_ktv_4y__entry__2}

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

{#r_DirectJDBCProbeParameters__table_sbn_ktv_4y}  
Example

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

{#r_DirectJDBCProbeParameters__table_b3n_gtv_4y__entry__2}

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

{#r_DirectJDBCProbeParameters__table_b3n_gtv_4y}  
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
  {#r_DirectJDBCProbeParameters__ul_qhb_dsh_w4}
* The table name

{#r_DirectJDBCProbeParameters__ul_lyk_bsh_w4} Figure 1. Queue form
**Related tasks**   

* [JDBCProbe](https://www.servicenow.com/docs/4E7tkaBMmwGF4VBg9ZKK9A "A JDBC probe runs on the MID Server to query an external database via [JDBC] and returns results to ServiceNow.")