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. In Windows, navigate to Start > Programs > ServiceNow ODBC > Interactive SQL (ODBC). 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 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. Specify the maximum number of rows returnedBy default, ServiceNow only returns 100 rows of data with each iSQL query. If you need to return more rows of data, set the maxrows parameter for the iSQL session. SQL supportThe ODBC driver embeds a third party SQL/ODBC engine from DataDirect, a division of Progress Software.