The ServiceNow® SQL API enables RaptorDB Pro users to bring their Business Intelligence (BI) tools to ServiceNow. It provides an ODBC and JDBC driver to access your ServiceNow data from third-party client applications. Users can perform BI analytics on their ServiceNow data without mass data export. SQL API is only available with RaptorDB Pro.
ODBC Driver - The ODBC driver is primarily targeted for Windows users and enables common BI application, such as PowerBI, to query ServiceNow data in place. Both 32-bit version and 64-bit version are provided.
JDBC Driver - The JDBC driver enables Java-based applications and tools to query ServiceNow data in place using the standard JDBC API.
For more information, see the SQL API release notes in the ServiceNow product documentation.
Initial Release.
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 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 client side 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 on your ServiceNow instance section in the SQL API documentation.
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 in the SQL API documentation.
Required: RaptorDB Pro
Other Requirements:Java 17
ODBC or JDBC compliant client software with which to load the SQL API clients