Use Interactive SQL with ODBC

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • 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.