Skip to content
Create data sources from other apps using ODBC driver › Additional integration resources › Web services › API implementation › API implementation and reference
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Test the ODBC driver

After configuring the ODBC driver, test that the driver can connect to the base instance as the ODBC user and can query data from a target table.

Before you begin

You must have administrator-level access for the Windows computer on which you want to test the ODBC driver.

About this task

To test the connection, run the ODBC Administrator program.

Procedure

  1. In Windows, navigate to Start > Programs > ServiceNow ODBC > ODBC Administrator.

    The ServiceNow ODBC data source is installed as a system data source.

  2. Select the System DSN tab, and then select the ServiceNow data source.

  3. Click Configure.

Image omitted: ServiceNowDataSource.png
ServiceNow system data source
  1. Click Test Connect in the ODBC driver Setup dialog box.
Image omitted: TestConnect.png
Test data source connection

  1. Enter the login credentials.

    These are the usual ServiceNow base system login credentials for the ODBC user you created.

Image omitted: DataSourceLogOn.png
Log on to data source

  1. Click OK to log in to the data source.

  2. Click OK again when the success message appears.

  3. Generate logs for debugging
    If you experience unexpected behavior when using the ODBC driver, you can enable debug logging and generate debug logs to help identify the issue.

  4. Test a query
    To verify that the user has the appropriate permissions to send requests to the instance using ODBC, run a query using Interactive SQL.
  5. ODBC troubleshooting
    Review these troubleshooting resources to resolve issues with the ODBC driver.

Parent Topic:Create data sources from other apps using ODBC driver

Related topics

Configure the ODBC driver