---
sourceDocument: Xanadu API Reference
sourceDocumentLink: https://www.servicenow.com/docs/r/xanadu/api-reference

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Use Interactive SQL with ODBC

# Use Interactive SQL with ODBC {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Run the Interactive SQL application for quick verification of connectivity and to test query results without using a full application.

## Before you begin

Role required: admin

## Procedure

1. In Windows, navigate to StartProgramsServiceNow ODBCInteractive SQL (ODBC).
2. Connect to the base instance by entering the following command and selecting the appropriate user credentials in the format without special characters: ID\*password@DSNName.  

       CONNECT odbcuser*password@ServiceNow

3. Issue a `SELECT` SQL command.  

       SELECT NUMBER, short_description FROM incident;

   Make sure to include the semicolon at the end of your query statement. Otherwise, you are presented with a `'Cont>'` prompt.  
* **[Specify the maximum number of rows returned](https://www.servicenow.com/docs/P_WJzyxjzHdQPtsxpVb5tw)**   
  By 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 support](https://www.servicenow.com/docs/WdK3ViSzkdAe2eBqevqrwA)**   
  The ODBC driver embeds a third party SQL/ODBC engine from DataDirect, a division of Progress Software.

*[\>]: and then