---
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 ODBC driver on a client machine

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

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read  
Configure the ODBC driver with your instance URL, BCFIPS JAR file paths, and authentication credentials to enable BI tools to access your ServiceNow data.

## Before you begin

Confirm that you have the following:

* 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).

{#configure-odbc-driver__ul_qh1_fpx_m3c}

Role required: administrator

## Procedure

1. From the Start menu, select and hold (or right-click) ServiceNow Live Connect - ODBC ManagerManagement Console, select Run as administrator, then navigate to ServicesServiceNow_ODBCService SettingsIP Parameters.
2. Edit the ServiceJVMClassPath parameter.  
3. Append the paths to the BCFIPS JAR files.  
   Separate each path with a semicolon. The JAR files are in the dependencies folder from the driver download (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.")).

   Example paths:

   \<Windows-machine-local-path\>\\\<folder-name\>\\bc-fips-2.0.0.jar;\<Windows-machine-local-path\>\\\<folder-name\>\\bcpkix-fips-2.0.7.jar;\<Windows-machine-local-path\>\\\<folder-name\>\\bcutil-fips-2.0.3.jar

   If you move the JAR files to a different location in the future, update the paths in the ServiceJVMClassPath parameter.
4. Do this only if you want to authenticate using OAuth.
   1. Open the DataSourceIPCustomProperties parameter.
   2. Update the value to set OAuth to True and provide OAuth client ID, client secret, token URL, access token, refresh token.  
      OAuth properties are 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.")

      For example, you can enter the value in this pattern: `url=https://<instance>.service-now.com;UseOAuth=True;`

   Warning:  
   If the OAuth client secret contains a semicolon, the ODBC driver can't parse the connection string correctly because semicolons are used as delimiters between key-value pairs. If your auto-generated client secret contains a semicolon, regenerate the client secret until you receive one without a semicolon, then use that secret in your ODBC configuration.
5. From the Start menu, select and hold (or right-click) ODBC Data Source Administrator (32-bit or 64-bit, matching your installed driver), then select Run as administrator.
6. In the System DSN tab, create a DSN or configure an existing DSN.
7. Enter the following connection settings:  
   {#configure-odbc-driver__table_uzk_qm1_n3c__entry__2}

   | Field | Description |
   |-|-|
   | Data Source Name | Unique identifier for this connection (for example, Instance1). |
   | Description | Optional description of the data source. |
   | Service Name | Name configured during installation (for example, ServiceNow_ODBC). |
   | Service Data Source | Service name configured during installation. |
   | Custom Properties | `url=https://<instance>.service-now.com`, where \<instance\> is your instance name. Enter connection properties as semicolon-separated key-value pairs. At minimum, include your instance URL: url=https:// \<instance\>.service-now.com. To connect using OAuth instead of a username and password add 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-odbc-driver__table_uzk_qm1_n3c}
8. Select Apply.
9. **Optional:** To verify the connection, select Test Connection and enter your user account credentials based on your authentication method:  
   * Basic authentication: Enter the username and password.
   * OAuth: OAuth credentials are used automatically from your earlier configuration.  
   A confirmation message appears if the connection is successful.
10. Select OK to save the configuration.

## Result

The ServiceNow
Live Connect ODBC driver is configured. You can connect ODBC-compatible applications such as Power BI or Excel to this data source to access your ServiceNow data.

*[\>]: and then