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

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

Changes to site functionality will be made starting around 6am on January 21st (Pacific Time) and lasting approximately 6 hours.  The site may be intermittently unavailable.