Integrate SQL API Drivers with Third Party BI Tools

  • Release version: Australia
  • Updated March 12, 2026
  • 2 minutes to read

    • Configure ServiceNow SQL API drivers to connect with third-party business intelligence and database tools for direct data access and analysis.

    After installing and configuring the SQL API drivers on your client machine, you can connect them to third-party business intelligence and database tools. This integration enables you to query ServiceNow data directly from your preferred analytics platforms without requiring data export or replication.

    The SQL API supports integration with a wide range of ODBC and JDBC-compatible tools, including Tableau, Power BI, Looker, DB Visualizer, and other standard BI platforms. By connecting these tools to your ServiceNow instance through the SQL API drivers, you can create dashboards, run ad-hoc queries, and perform comprehensive data analysis using live ServiceNow data.

    Note:

    Step-by-step instructions for third-party tools are illustrative — you must consult tool-specific documentation for latest updates.

    Prerequisites

    Before connecting third-party tools to the SQL API drivers, ensure that you have completed the following:

    • The SQL API plugin is installed on your ServiceNow instance.
    • The SQL API is configured on your instance, including Service Account creation, ACL configuration, and IP filter setup.
    • The appropriate SQL API driver (ODBC or JDBC) is downloaded and installed on your client machine.
    • The driver is configured with your instance URL, Service Account credentials, and connection parameters.
    • Your client machine's IP address is included in the SQL API IP filter configuration.
    • The Service Account has the necessary roles (sn_odbc_rest_access or sn_jdbc_rest_access) and table-level access permissions.

    General Connection Considerations

    When connecting third-party BI tools to ServiceNow SQL API drivers, keep the following considerations in mind:

    • All connections are read-only. Third-party tools cannot modify ServiceNow data through the SQL API.
    • Query performance depends on network connectivity, query complexity, and the amount of data being retrieved. Use WHERE clauses and column selection to optimize performance.
    • Security permissions are enforced at the ServiceNow level. The connected tool can only access tables and records permitted by the Service Account's roles and ACL configuration.
    • Monitor your SQL query rate to stay within the 500 queries per hour limitation.
    • Consider using Service Account-specific connections for different teams or projects to maintain granular access control.

    Supported BI Tools

    While Power BI Desktop and DB Visualizer are specifically documented examples, the SQL API drivers support any ODBC or JDBC-compatible application. Other commonly used tools include:

    • Tableau Desktop and Tableau Server
    • Looker and Looker Studio
    • Microsoft Excel (via ODBC connection)
    • SQL Server Management Studio
    • DBeaver and other universal database tools
    • Custom applications using ODBC or JDBC APIs

    Each tool has its own connection configuration interface, but the underlying connection parameters (instance URL, Service Account credentials, driver selection) remain consistent across all platforms.