Use Interactive SQL with ODBC

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

  1. In Windows, navigate to Start > Programs > ServiceNow ODBC > Interactive SQL (ODBC).
  2. Enter the following command to connect to the base system instance. Select the appropriate user credentials in the format: ID*password@DSNName. The password cannot contain special characters.
    CONNECT odbcuser*password@ServiceNow
    Connecting the SQL
  3. Issue a SELECT SQL command, such as:
    SELECT NUMBER, short_description FROM incident;

    Make sure to include the semicolon at the end of your query statement. You will be presented with a 'Cont>' prompt otherwise.

    Sample SQL Query