Use cases for Live Connect

---
title: Use cases for Live Connect
description: Live Connect supports business intelligence \(BI\) reporting, ad-hoc data analysis, and custom report development.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/api-reference/web-services/common-use-cases-for-sql-api.html
release: australia
product: Web Services
classification: web-services
topic_type: concept
last_updated: "2026-09-10"
reading_time_minutes: 1
keywords: [use]
breadcrumb: [Explore, Access your ServiceNow data using Live Connect, Additional integration resources, Web services, API implementation, API implementation and reference]
---

# Use cases for Live Connect

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

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

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.

Supported platforms include Pyramid Analytics, Tableau, Power BI, and other ODBC/JDBC-compatible tools. These connect directly to your ServiceNow data without requiring data export or replication.

## Ad-hoc data analysis

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

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

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 the Live Connect query limits. For information on query limits, see [Usage limitations for Live Connect](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/usage-limitations.md).

**Parent Topic:**[Getting started with ServiceNow Live Connect](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/getting-started-with-servicenow-sql-api.md)