Use Interactive SQL with ODBC

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：1分

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

    始める前に

    Role required: admin

    手順

    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.