Run the Interactive SQL application for quick verification of connectivity and to test query results without using a full application.

Before you begin

Role required: admin

Procedure

  1. In Windows, navigate to Start > Programs > ServiceNow ODBC > Interactive SQL (ODBC).
  2. Connect to the base instance by entering the following command and selecting the appropriate user credentials in the format without special characters: ID*password@DSNName. 
    CONNECT odbcuser*password@ServiceNow
    Connecting the SQL.
  3. Issue a SELECT SQL command. 
    SELECT NUMBER, short_description FROM incident;

    Make sure to include the semicolon at the end of your query statement. Otherwise, you are presented with a 'Cont>' prompt.

    Sample SQL Query.