Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Use Interactive SQL with ODBC

Log in to subscribe to topics and get notified when content changes.

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