--- 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 --- # Explore # Getting started with ServiceNow Live Connect {#ariaid-title1} Release version: Australia Updated May 7, 2026 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read 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 the 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://servicenow-prod.fluidtopics.net/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} 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 checks access at the table, row, and field level for every query, following ServiceNow's secure-by-default approach. The Live Connect validates all ACLs in your instance record by record, which may result in longer response times. This is expected. If your use case does not require row and field-level checks, you can turn them off by assigning the sn_live_connect_privileged_mode role to the user account (personal or service account). Only users with the security_admin role can assign this role. Table-level ACL checks remain in effect and can't be turned off. * Authentication is required for all connections. {#getting-started-with-servicenow-sql-api__ul_hjs_yrd_m3c} Additionally, 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. ## 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 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} ## 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://servicenow-prod.fluidtopics.net/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://servicenow-prod.fluidtopics.net/S2OdTUWD~IddOVwqiwCTNg "This section guides you through the complete setup process for the ServiceNow Live Connect, covering both instance configuration and driver installation. You will configure your ServiceNow instance to enable Live Connect access, set up the necessary security controls, and install the appropriate drivers on your client machine.") * [Install Live Connect on your ServiceNow instance](https://servicenow-prod.fluidtopics.net/if_1PWNMECmKCOVELBqpEg "Install Live Connect to enable secure, read-only access to your instance data from external applications.") * [Use cases for Live Connect](https://servicenow-prod.fluidtopics.net/qC30QNs8vO031tViuAHFnw "Live Connect supports business intelligence (BI) reporting, ad-hoc data analysis, and custom report development.") * [Live Connect reference](https://servicenow-prod.fluidtopics.net/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://servicenow-prod.fluidtopics.net/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://servicenow-prod.fluidtopics.net/qC30QNs8vO031tViuAHFnw)** Live Connect supports business intelligence (BI) reporting, ad-hoc data analysis, and custom report development.