---
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


---

# Live Connect configuration on your ServiceNow instance

# Live Connect configuration on your ServiceNow instance {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Complete the three-step configuration that's required to enable Live Connect access.

Configuring Live Connect on your ServiceNow instance enables you to integrate your ServiceNow data with third-party BI tools and analytics platforms. You can connect to platforms such as Pyramid Analytics, Tableau, Power BI, DB Visualizer, or custom ODBC/JDBC clients to enhance your reporting
and data analysis capabilities.

## Before you begin

Confirm the following prerequisites are in place before starting:

* The Live Connect plugin is installed on your instance.
* You have consulted your network team to identify the IP address range for your ODBC/JDBC client machines.
* You have identified which ServiceNow tables must be accessible via the Live Connect.

Role required: admin

## Configuration steps

Complete the following procedures to configure Live Connect access on your instance:

1. [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.")
2. [Create Access Control Lists (ACLs) for Live Connect](https://servicenow-prod.fluidtopics.net/snYghOPltuehwEcdMSyv5Q "Configure table-level access control using the egress_sql and read operations to grant user accounts (personal and service accounts) query access to specific tables through Live Connect.")
3. [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.")

## After configuration

After completing all the procedures, your user account (personal or service account) can connect to your ServiceNow instance via ODBC or JDBC. You can then query tables for which access has been granted.

Additional considerations:

* You can assign roles to personal user accounts or create dedicated service accounts with different roles and access control settings to support different integrations or teams.  
  Note:  
  Service accounts are recommended for production reports and dashboards because they promote continuity. Personal accounts will break if the user loses access or leaves the organization.
* Access is not granted globally. A user account can query a table only if it has explicit read access. Access is granted through table-level ACLs (`egress_sql` and `read`) or through a role with read permissions.
* Live Connect supports both individual user accounts (via OAuth) and service accounts.
* Non-interactive (machine) service accounts can't complete MFA challenges. If you're using non-interactive service accounts, turn off MFA for those accounts. Personal accounts using OAuth aren't subject to this limitation.
* **[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.
* **[Create Access Control Lists (ACLs) for Live Connect](https://servicenow-prod.fluidtopics.net/snYghOPltuehwEcdMSyv5Q)**   
  Configure table-level access control using the egress_sql and read operations to grant user accounts (personal and service accounts) query access to specific tables through Live Connect.
* **[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.