SQL API Release Notes

  • Release version: Zurich
  • Updated March 9, 2026
  • 2 minutes to read
  • Summarize
    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 SQL API Release Notes

    The ServiceNow® SQL API, introduced in the Zurich release, enables RaptorDB Pro users to directly query ServiceNow data using standard SQL queries through ODBC and JDBC drivers. This integration allows users to perform Business Intelligence (BI) analytics within their preferred BI tools without the need for data export or replication to external repositories or data warehouses. The SQL API supports read-only access to ensure data integrity and is designed for seamless integration with BI platforms such as Power BI and DBvisualizer.

    Show full answer Show less

    Key Features

    • Direct Data Access: Query ServiceNow data in real time without replicating it externally.
    • Read-Only Operations: Protect data by allowing only read access, preventing unintended changes.
    • Selective Table Access: Control access to specific tables to enforce data governance.
    • Integration with BI Tools: Use standard ODBC/JDBC drivers to connect popular BI platforms directly to ServiceNow data.
    • Data Merging: Combine ServiceNow data with third-party datasets in data lakes or analytical platforms for comprehensive analysis.
    • Optimized Queries: Retrieve targeted data to minimize network overhead and improve performance.

    Activation and Requirements

    The SQL API requires activation of the SQL API plugin (com.glide.rest.sqlapiserver) on a ServiceNow instance with an active RaptorDB Pro entitlement. While SQL API client drivers are available for free download from the ServiceNow Store, connection to the instance is only possible once the server-side plugin is enabled.

    Clients must install the SQL API ODBC and JDBC drivers on their machines to connect BI tools and analytics platforms to ServiceNow data. The plugin offers a unified installer for these server-side components.

    Upgrade and Migration

    ServiceNow customers previously using the SOAP-based ODBC client can migrate to the REST-based SQL API client by configuring both server and client sides accordingly, enhancing integration capabilities and performance.

    Related Products

    The SQL API is exclusively available with RaptorDB Pro, a licensed database that supports ServiceNow AI Platform generative AI, machine-scale data use cases, and advanced analytics workloads.

    The ServiceNow® SQL API enables RaptorDB Pro users to bring their Business Intelligence (BI) tools to ServiceNow. Users can perform BI analytics on their ServiceNow data without mass data export. SQL API is only available with RaptorDB Pro.

    SQL API highlights for the Zurich release

    • Query your ServiceNow data directly without replicating it to external repositories or data warehouses.
    • Access data using read-only operations to prevent unintended changes to your ServiceNow records. Allow access only to the desired tables.
    • Integrate standard BI platforms such as Power BI, DBvisualizer, and other ODBC/JDBC-compatible tools directly with your ServiceNow data.
    • Merge your ServiceNow data with third-party datasets in your data lakes and analytical platforms for comprehensive analysis.
    • Write targeted SQL queries to retrieve only the data you need, reducing network overhead on data pipeline and data transformation, and improving performance.

    For more information, see Access your ServiceNow data using SQL API.

    Important:
    SQL API is available in the ServiceNow Store. For details, see the "Activation information" section of these release notes.

    Important upgrade information for SQL API

    ServiceNow provided customers with a free SOAP‑based ODBC client. If you have an active RaptorDB Pro entitlement, you can migrate to the REST‑based SQL API client by completing the required configuration on both the server and client sides. For more information, see Configuring SQL API.

    SQL API features

    Access your ServiceNow data using SQL API
    The ServiceNow SQL API enables you to access your ServiceNow instance data through ODBC and JDBC drivers. Using SQL API, you can directly access your instance data from third-party BI tools and other data analysis applications without exporting or replicating your data. The ServiceNow SQL API plugin uses ServiceNow web services support for a query-only interface.

    Activation information

    SQL API is a ServiceNow feature that is available with the activation of SQL API plugin (com.glide.rest.sqlapiserver). The ServiceNow instance requires RaptorDB Pro entitlement to activate the SQL API server-side plugin. The SQL API drivers are freely available for download by anyone with a valid account to the ServiceNow Store. However, the SQL API client would not be able to connect to the ServiceNow instance until the server-side plugin is enabled. For more information, see Install SQL API plugin on your ServiceNow instance.

    Plugin information

    New plugin

    The following plugin is new in Zurich:

    SQL API (com.glide.rest.sqlapiserver): Unified installer for the ServiceNow ODBC and JDBC server‑side plugin. This plugin works with ServiceNow client‑side drivers to enable clients to query and retrieve data from a ServiceNow instance using ODBC and JDBC API standards. You can download and install the client‑side drivers on your client machines from the ServiceNow Store.

    Additional requirements

    You must download the SQL API ODBC and JDBC drivers on your client machine. These drivers enable your BI tools and data analysis platforms to connect to your ServiceNow data and run the SQL API queries. You can download the ODBC and JDBC drivers from ServiceNow store.