Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Use interactive SQL with ODBC

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 ServiceNow ITSA Suite 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