Skip to content
Configure › Access your ServiceNow data using SQL API › Additional integration resources › Web services › API implementation › API implementation and reference
Release: Australia · Updated: 2026-03-15 · Official documentation · View source

Route SQL API calls to Read Replica

You can route SQL API calls to Read Replica to optimize the performance of your ServiceNow instance.

Before you begin

You must have a secondary database configured for your ServiceNow instance.

Role required: admin

About this task

Query routing takes the load off the primary database for SELECT queries that take numerous DB CPU cycles on the primary DB. For more information, see Introduction to ServiceNow Read Replica Databases.

Procedure

  1. Navigate to All > Secondary Database > Secondary Database Category.

  2. Select New to create secondary database category for ODBC/JDBC.

  3. In the Name field, enter odbc or jdbc.

    Don't change any other field on this page. If you must change the default values, first refer to this KB: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0824441

Image omitted: sql-api-read-replica.png
UI screen example for creating secondary database category.

  1. Select Map All Pools to map the database pools to this category.

  2. Select the database pools to be added.

    The selected pools appear under the Member Secondary Database Pools.

  3. Select Save.

Parent Topic:Configuring SQL API