Connecting DB Visualizer to JDBC Driver

Connect the DB Visualizer database tool to your ServiceNow instance using the JDBC driver to query ServiceNow data.

Before you begin

Before you begin, ensure the following prerequisites are in place:

• The SQL API plugin is installed and configured on your ServiceNow instance.
• You have downloaded and configured the ServiceNow JDBC driver on your client machine.
• You have a Service Account with the sn_jdbc_rest_access role assigned.
• Access Control Lists (ACLs) are configured for the tables you need to query.
• IP filter criteria are configured to allow connections from your client machine.
• DB Visualizer is installed on your client machine.
• Java Runtime Environment (JDK 17 or later) is installed on your client machine.

Role required: admin

About this task

DB Visualizer is a database management and analysis tool that supports JDBC connections. By connecting DB Visualizer to your ServiceNow instance through the JDBC driver, you can query ServiceNow data, create visualizations, and perform ad-hoc analysis using industry-standard SQL commands.

This procedure enables you to establish a JDBC connection between DB Visualizer and ServiceNow, allowing you to access authorized tables and perform read-only queries on your ServiceNow data.

Procedure

1. Open DB Visualizer on your client machine.
2. Create a new database connection by selecting Database > Create Database Connection.
3. In the connection dialog, configure the driver settings.
   1. In the Driver field, select Generic or create a new driver.
   2. If creating a new driver, specify the path to the ServiceNow JDBC driver JAR file that you downloaded and configured on your client machine.
   3. Set the Driver Class to the ServiceNow JDBC driver class name.
4. Configure the connection properties.
   1. In the Database URL field, enter the JDBC connection string for your ServiceNow instance in the format: jdbc:servicenow://<instance_name>.service-now.com
      Replace <instance_name> with your actual ServiceNow instance name.
   2. In the Database Userid field, enter the User ID of your Service Account.
   3. In the Database Password field, enter the password for your Service Account.
5. Test the connection by selecting Test Connection or Connect.
   If the connection is successful, DB Visualizer displays a confirmation message and you can see the available ServiceNow tables in the database tree.
6. Save the connection configuration by selecting Apply or OK.

Result

You have successfully connected DB Visualizer to your ServiceNow instance using the JDBC driver. You can now query authorized ServiceNow tables using SQL commands in DB Visualizer. The connection respects all ServiceNow Access Control Lists (ACLs) and security policies configured for your Service Account.

You can now perform the following operations:

• Execute SELECT queries against authorized ServiceNow tables.
• Use WHERE clauses to filter data at the source.
• Perform aggregations such as COUNT, SUM, and AVG.
• Join multiple ServiceNow tables in a single query.
• Export query results for analysis or reporting.

Important:

All queries are read-only. You cannot perform INSERT, UPDATE, or DELETE operations through the SQL API. All queries are subject to the 500 queries per hour rate limit and respect the security and access controls configured for your Service Account.