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.