--- sourceDocument: Australia API Reference sourceDocumentLink: https://www.servicenow.com/docs/r/australia/api-reference Release : - australia ft:locale : - en-US ft:publication_title : - Australia API Reference ft:clusterId : - crapiref bundleId : - crapiref workflow : - Creator --- # Explore # Getting started with ServiceNow Live Connect {#ariaid-title1} Release version: Australia Updated September 10, 2026 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete. ## Summary of Getting started with ServiceNow Live Connect ServiceNow Live Connect enables secure, read-only access to your ServiceNow instance data through standard ODBC and JDBC drivers. This allows direct integration with popular Business Intelligence (BI) and data analysis tools such as Power BI, Tableau, Pyramid Analytics, and others that support these database connectivity standards. The plugin supports query-only operations, primarily SELECT statements, enabling you to retrieve relevant data efficiently without replicating it externally. Show full answer Show less ## Key Features * **Optimized data transfer:** Compose targeted SQL queries to fetch only necessary data, reducing network load and improving performance. * **Direct BI tool connectivity:** Connect standard BI platforms directly to your ServiceNow data for seamless reporting and analysis. * **Read-only access with security enforcement:** Prevent unintended data changes by restricting operations to SELECT queries while enforcing ServiceNow's role-based access controls and ACLs at table, row, and field levels. * **Pass-through queries:** Support for filtering, aggregations (COUNT, SUM, AVG), and table joins (INNER and LEFT OUTER) processed on the ServiceNow side to enhance query efficiency. * **Multiple authentication methods:** Supports Basic Authentication over SSL/TLS, OAuth 2.0 (from Zurich Patch13 and Australia Patch6 onwards), and Client Certificate (mTLS) authentication for high-security environments. * **Security and access control:** Live Connect enforces ServiceNow's security model including ACLs and requires proper roles; privileged mode available to bypass some validations with appropriate permissions. ## Practical Considerations for ServiceNow Customers * Ensure your BI or data analysis tools support the authentication method and encryption configured in your ServiceNow instance (e.g., OAuth 2.0, mTLS, TLS 1.2+). * Assign necessary roles such as `snodbcrestaccess` or `snjdbcrestaccess` and for basic authentication, also `sncbasicauthapiaccess`. * Utilize Live Connect to avoid data duplication by querying your ServiceNow data directly rather than exporting it to external repositories. * Review and test supported SQL functions and query capabilities to build efficient reports and dashboards. * Plan for potential performance impacts due to row and field-level ACL validations; consider privileged mode if appropriate and authorized. ## What You Can Expect By leveraging Live Connect, you gain the ability to perform sophisticated, secure, and efficient data queries directly on your ServiceNow instance from your preferred BI tools. This integration supports comprehensive reporting, ad-hoc analysis, and custom report development without compromising data security or requiring data replication. The solution maintains strict adherence to your existing ServiceNow security policies while facilitating enhanced data-driven decision-making. The ServiceNow Live Connect provides data access to your ServiceNow instances through industry-standard ODBC and JDBC drivers, enabling direct connections from Business Intelligence (BI) tools and data analysis platforms. The ServiceNow Live Connect plugin uses ServiceNow web services support for a query-only interface. By default, the plugin supports only SELECT statements, allowing external applications to query authorized tables. It permits a limited set of additional SQL commands and enables you to compose more complex queries to retrieve only relevant data. ## What you can achieve with Live Connect {#getting-started-with-servicenow-sql-api__section_bjs_yrd_m3c} With the Live Connect, you can: * Optimize data transfer: Write targeted SQL queries to retrieve only the data you need, reducing network overhead for data pipeline and data transformation, and improving performance. * Connect your BI tools: Integrate standard BI platforms such as Pyramid Analytics, Power BI, Tableau, DBeaver, DBvisualizer, and other ODBC/JDBC-compatible tools directly with your ServiceNow data. * Query data securely: Access data through read-only operations that help avoid unintended modifications to your ServiceNow records. Allow access only to the desired tables. * Eliminate data duplication: Query your ServiceNow data directly without replicating it to external repositories or data warehouses. * Combine data sources: Merge your ServiceNow data with third-party datasets in your analytical platforms for comprehensive analysis. {#getting-started-with-servicenow-sql-api__ul_cjs_yrd_m3c} ## How Live Connect works {#getting-started-with-servicenow-sql-api__section_djs_yrd_m3c} When you connect your BI tool to your ServiceNow instance through Live Connect, you establish a standard database connection using ODBC or JDBC APIs. After connecting, you can write SQL queries to retrieve data from your ServiceNow tables and fields. The API processes your queries and returns results in standard tabular format, which your BI tool can then visualize, analyze, or export. ## Pass-through query support {#getting-started-with-servicenow-sql-api__section_ejs_yrd_m3c} Live Connect supports pass-through queries, meaning you can write SQL statements that run directly on your ServiceNow data. This enables you to: * Apply WHERE clauses to filter data at the source. * Perform aggregations (COUNT, SUM, AVG, etc.) on the ServiceNow side. * Join multiple ServiceNow tables in a single query. The query engine supports INNER and LEFT OUTER joins. * Limit result sets to reduce data transfer. {#getting-started-with-servicenow-sql-api__ul_fjs_yrd_m3c} By processing queries at the source, you reduce the amount of data transferred over the network and improve overall query performance. ## Supported SQL functions {#getting-started-with-servicenow-sql-api__section_sql_functions_support} Live Connect does not support the full ANSI SQL standard. The query engine supports a subset of SQL functions optimized for read-only data access and analysis. For a complete list of supported SQL functions with examples and usage guidelines, see [Supported SQL functions](https://www.servicenow.com/docs/tMSA2~ZeDCA19CbhuTm70w "Common SQL functions used in Live Connect for querying and analyzing incident data."). ## Security and access control {#getting-started-with-servicenow-sql-api__section_gjs_yrd_m3c} Live Connect is read-only by design. You can't perform INSERT, UPDATE, or DELETE operations through this interface. This helps prevent accidental modification of production data. Your current ServiceNow security model still applies when you access data using Live Connect. The API implements the ServiceNow ACL model, which means: * You can only access data that your ServiceNow role and permissions allow. * All identity and access management protocols are enforced at the API level. * Your queries follow table-level, row level, field level, and query level rules. * Live Connect validates ACLs at the table, row, and field level for every query. Record-by-record validation may result in longer response times. To disable row and field-level checks, assign the sn_live_connect_privileged_mode role to the user account. Only users with the security_admin role can assign this role. Table-level ACL checks remain in effect. * Authentication is required for all connections. {#getting-started-with-servicenow-sql-api__ul_hjs_yrd_m3c} ## Authentication methods {#getting-started-with-servicenow-sql-api__section_ll5_y41_hkc} Live Connect supports multiple authentication methods to meet various security requirements and conformance standards. Note: OAuth 2.0 support is available starting with Zurich Patch13 and Australia Patch6. {#getting-started-with-servicenow-sql-api__table_kkt_1p1_hkc__entry__2} | Authentication Encryption Method || Recommended use case | |-|-|-| | Basic Authentication | SSL/TLS (traffic only) | Legacy systems; non-regulated environments. | | OAuth 2.0 | TLS 1.2+ | Client credentials and authorization code flows. Provides token-based access without exposing credentials directly. | | Client Certificate (mTLS) | TLS 1.2+ with mutual authentication | Recommended for service-to-service integration and highest security requirements. Requires certificate management infrastructure. | [Table 1. Live Connect Authentication Methods] {#getting-started-with-servicenow-sql-api__table_kkt_1p1_hkc} Note: Personal user accounts connecting via basic authentication also require the snc_basic_auth_api_access role, in addition to sn_odbc_rest_access (ODBC) or sn_jdbc_rest_access (JDBC). ## Third-party client authentication requirements {#getting-started-with-servicenow-sql-api__section_nqr_cp1_hkc} Any third-party BI tool, database client, or application connecting to ServiceNow via Live Connect must support the same authentication and encryption methods as configured on your ServiceNow instance. Before integrating a third-party tool, verify the following: * Your selected authentication method (OAuth 2.0 or Client Certificates for FedRAMP conformance) * TLS 1.2 or higher encryption * Certificate validation (if using mTLS) * Token refresh mechanisms (if using OAuth) {#getting-started-with-servicenow-sql-api__ul_wd5_dp1_hkc}Consult your BI tool's documentation or contact your vendor to confirm compatibility before configuring Live Connect connections. ## What to explore next {#getting-started-with-servicenow-sql-api__section_zmm_2sd_m3c} To learn more about configuring and using Live Connect, see: * [Live Connect architecture](https://www.servicenow.com/docs/1CmobukOMKGa4qmxwgrW8Q "Live Connect provides secure, read-only access to ServiceNow data for external BI platforms via industry-standard database APIs, while maintaining all existing security policies and role-based restrictions.") * [Configuring Live Connect](https://www.servicenow.com/docs/S2OdTUWD~IddOVwqiwCTNg "Configure your ServiceNow instance to enable Live Connect access, set up security controls, and install the required drivers on your client machine.") * [Install Live Connect on your ServiceNow instance](https://www.servicenow.com/docs/if_1PWNMECmKCOVELBqpEg "Install Live Connect to enable secure, read-only access to your instance data from external applications.") * [Use cases for Live Connect](https://www.servicenow.com/docs/qC30QNs8vO031tViuAHFnw "Live Connect supports business intelligence (BI) reporting, ad-hoc data analysis, and custom report development.") * [Live Connect reference](https://www.servicenow.com/docs/lC7LDALfy8YMA9atXU60xA "This section provides details about Live Connect reference information like minimum requirements and usage limitations.") {#getting-started-with-servicenow-sql-api__ul_anm_2sd_m3c} * **[Live Connect architecture](https://www.servicenow.com/docs/1CmobukOMKGa4qmxwgrW8Q)** Live Connect provides secure, read-only access to ServiceNow data for external BI platforms via industry-standard database APIs, while maintaining all existing security policies and role-based restrictions. * **[Use cases for Live Connect](https://www.servicenow.com/docs/qC30QNs8vO031tViuAHFnw)** Live Connect supports business intelligence (BI) reporting, ad-hoc data analysis, and custom report development.