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


---

# Use cases

# Use cases for Live Connect {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  

Live Connect supports business intelligence (BI) reporting, ad-hoc data analysis, and custom report development.

The Live Connect is particularly useful for scenarios that require direct access to ServiceNow data from external tools and platforms. These use cases demonstrate how organizations use Live Connect to enhance their data analysis and reporting capabilities.

## Business intelligence and reporting {#common-use-cases-for-sql-api__section_h1f_4td_m3c}

Connect your preferred BI tools to create dashboards and reports that combine ServiceNow data with information from your other business systems. You can build comprehensive views that span multiple data sources without copying ServiceNow data to external systems.

This use case enables you to integrate standard BI platforms such as Pyramid Analytics, Tableau, Power BI, and other ODBC/JDBC-compatible tools directly with your ServiceNow data, eliminating the need for data export or replication.

## Ad-hoc data analysis {#common-use-cases-for-sql-api__section_i1f_4td_m3c}

Run exploratory queries to investigate trends, identify patterns, or troubleshoot issues with minimal impact on your ServiceNow instance's performance. No administrator intervention is required.

By writing targeted SQL queries, you can retrieve only the data you need. This reduces network overhead on data pipeline and data transformation, improving performance. The pass-through query support enables you to apply WHERE
clauses, perform aggregations, and join multiple ServiceNow tables in a single query.

## Custom report development {#common-use-cases-for-sql-api__section_j1f_4td_m3c}

Build specialized reports using your organization's standard reporting tools and frameworks. You can maintain control over report design and scheduling while accessing live ServiceNow data.

Live Connect supports read-only operations that avoid unintended modifications to your ServiceNow records. This ensures that your analytical work can't accidentally modify production data. This helps provide a secure environment for developing and executing custom reports.

## External data source integration {#common-use-cases-for-sql-api__section_k1f_4td_m3c}

Live Connect is designed with built-in limits to keep your ServiceNow instance running smoothly. You can use it to query specific data. Your client applications can combine this data and integrate it with other data sources, as long as you stay within these the Live
Connect query limits. For information on query limits, see [Usage limitations for Live Connect](https://servicenow-prod.fluidtopics.net/Oihh5fsw72FVYPfXqCYiKA "Live Connect imposes rate limits to ensure system stability and performance when querying ServiceNow data through ODBC and JDBC drivers.").