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