Configuring SQL API

This section guides you through the complete setup process for the ServiceNow SQL API, covering both instance configuration and driver installation. You will configure your ServiceNow instance to enable SQL API access, set up the necessary security controls, and install the appropriate drivers on your client machine.

SQL API Configuration overview

The configuration process involves two main components:

1. ServiceNow Instance Setup

   Configure your ServiceNow instance by installing the SQL API plugin, creating a dedicated service account with the appropriate access roles, defining Access Control Lists (ACLs) to control data access, and establishing IP filtering policies for security.

   • Installing SQL API on Your ServiceNow Instance
   • Configuring SQL API on Your ServiceNow Instance
2. Driver Installation and Configuration

   Download the SQL API drivers from the ServiceNow Store and install either the ODBC driver on your Windows client machine or configure the JDBC driver in your preferred database client.

   • Downloading the SQL API Drivers on Client Machine
   • Installing ServiceNow SQL API ODBC Driver on Client Machine
   • Configuring ServiceNow SQL API ODBC Driver on Client Machine
   • Configuring ServiceNow SQL API - JDBC Driver on Client Machine

• Installing SQL API on Your ServiceNow Instance
  Installing the SQL API on your instance enables secure, read-only access to your instance data from external applications. By completing this task, you can integrate your data with third-party tools and analytics platforms, enhancing your reporting and data analysis capabilities.
• Configuring SQL API on Your ServiceNow Instance
  Overview of the three-step configuration process required to enable SQL API access including prerequisites and expected outcomes.
• Downloading the SQL API Drivers on Client Machine
  Download the ODBC and JDBC drivers from your ServiceNow instance to your client machine to enable SQL API connectivity.
• Installing ServiceNow SQL API ODBC Driver on Client Machine
  Install the ServiceNow ODBC driver on your Windows client machine to enable connectivity between your Business Intelligence tools and ServiceNow data through the SQL API.
• Configuring ServiceNow SQL API ODBC Driver on Client Machine
  Configure connection settings for the installed ODBC driver including server URL and authentication credentials to enable data access from BI tools to your ServiceNow instance.
• Configuring ServiceNow SQL API - JDBC Driver on Client Machine
  Configure the JDBC driver settings on your client machine to establish a connection to your ServiceNow instance and access data through the SQL API.