SQL API Release Notes
Summarize
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 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 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.