Close
Thank you for your feedback.

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

Products > ServiceNow Platform > ODBC driver; Versions > Helsinki