---
sourceDocument: Australia API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/api-reference

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Configure ServiceNow Live Connect JDBC driver on a client machine

# Configure ServiceNow
Live Connect JDBC driver on a client machine {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Configure the JDBC driver to connect to your ServiceNow instance and query your data.

## Before you begin

Verify the following:

* The ServiceNow Live Connect JDBC driver is downloaded. See [Download the Live Connect drivers on a client machine](https://servicenow-prod.fluidtopics.net/zrcCmJ7ebrtDneqvgC49sw "Download ODBC and JDBC drivers to enable third-party Business Intelligence tools and data analysis platforms to connect to your ServiceNow data.").
* JDK 17 is installed.
* A valid ServiceNow user account (personal or service account) with the required roles. See [Assign roles and create service accounts](https://servicenow-prod.fluidtopics.net/ZVR2lJNhFGgTW5wJ6vIQBw "Assign the sn_odbc_rest_access or sn_jdbc_rest_access role to users who need Live Connect access. You can assign these roles to personal user accounts or create dedicated non-interactive (Machine) service accounts.").
* The client machine IP address is included in the Live Connect IP filter criteria. See [Create IP filter criteria](https://servicenow-prod.fluidtopics.net/2NeON5IRnpWHYrWoIIkJrA "Define which IP addresses or IP ranges are permitted to connect to your ServiceNow instance via the Live Connect ODBC/JDBC driver.").
* Your ServiceNow instance URL and user account credentials (personal or service account).
* Your OAuth Application Registry configured if you plan to connect using OAuth instead of basic authentication. See [Enable OAuth for Live Connect](https://servicenow-prod.fluidtopics.net/jyVJbmELsxKzR0Tlj3BZfw "Configure OAuth as an additional authentication method for Live Connect connections. This adds OAuth alongside basic authentication without replacing it.").

Role required: administrator

## Procedure

1. Locate the ServiceNow JDBC driver JAR file on your client machine.  
   The file is typically named servicenow-jdbc-driver.jar.
2. Add the JDBC driver to your application's classpath or configure it in your BI tool's driver management section.  
   The method varies by application. Consult your BI tool documentation for instructions.
3. Configure the JDBC connection URL:  

       jdbc:servicenow://https://<instance-name>.service-now.com

   Example:

       jdbc:servicenow://https://exampleinstance.service-now.com

4. Select an authentication method and configure the driver properties.

   | Option | Description |
   | Method | Properties |
   | Basic Authentication | Set user to the user ID with the sn_jdbc_rest_access role and password to the user password. |
   | OAuth | Set useoauth to `true` and provide the OAuth properties described in [OAuth connection properties for ODBC and JDBC drivers](https://servicenow-prod.fluidtopics.net/sVc6NONQeE2Ozf3cfbstFA "Set these properties on the ODBC or JDBC driver to connect to Live Connect using OAuth instead of a username and password."). |
   |-|-|

   {#configure-jdbc-driver__choicetable_cry_fmy_hkc}
5. **Optional:** To verify the connection, test that the JDBC driver connects to your ServiceNow instance.  
   Most BI tools and database clients provide a Test Connection button.  
   A confirmation message appears if the connection is successful.

## Result

The JDBC driver is configured. Your BI tool or application can connect to ServiceNow and execute SQL queries against authorized tables.