SQL API Release Notes
Summarize
Summary of SQL API Release Notes
The ServiceNow® SQL API, introduced in the Australia release, allows RaptorDB Professional users to directly query their ServiceNow data using standard SQL-based BI tools without the need for data export or replication. This read-only API enhances data accessibility and analytics by enabling integration with popular BI platforms such as Power BI and DBvisualizer through ODBC and JDBC drivers.
Show less
Key Features
- Direct SQL querying of ServiceNow data with no external data replication required.
- Read-only access ensures your ServiceNow records cannot be unintentionally modified.
- Control access to specific tables to maintain data security and governance.
- Seamless integration with standard BI tools via ODBC and JDBC drivers downloadable from the ServiceNow Store.
- Ability to merge ServiceNow data with external datasets within BI platforms for comprehensive analysis.
- Targeted SQL queries reduce network overhead and improve performance by retrieving only necessary data.
Activation and Upgrade Information
SQL API requires activation of the server-side plugin (com.glide.rest.sqlapiserver) on a ServiceNow instance with RaptorDB Professional entitlement. While the client-side ODBC and JDBC drivers are freely downloadable, the server-side plugin must be enabled for connectivity. Customers migrating from the legacy SOAP-based ODBC client to the REST-based SQL API client need to perform specific configuration on both server and client sides.
Practical Considerations for ServiceNow Customers
- Ensure your instance has RaptorDB Professional to activate the SQL API plugin and leverage its capabilities.
- Download the latest SQL API ODBC and JDBC drivers from the ServiceNow Store to connect your BI tools.
- Use SQL API to simplify data analytics workflows by eliminating data duplication and leveraging real-time ServiceNow data.
- Maintain data integrity and security through read-only access and controlled table permissions.
- For setup and configuration, follow guidance on installing the SQL API plugin and configuring clients to ensure smooth integration.
The ServiceNow® SQL API enables RaptorDB Professional 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 Professional.
SQL API highlights for the Australia release
- Query your ServiceNow data directly without replicating it to external repositories or data warehouses.
- Access data using read-only operations to avoid 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 or JDBC-compatible tools directly with your ServiceNow data.
- Merge your ServiceNow data with external datasets in your 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 Professional 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 Store SQL API enables you to access your ServiceNow Store 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 Professional 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 Australia:
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.