ODBC driver

The ServiceNow open database connectivity (ODBC) driver provides read-only access to the database associated with your ServiceNow instance.

The ODBC driver is compliant to version 3.52 of the Microsoft ODBC core API conformance. The ServiceNow ODBC driver uses the ServiceNow web services support for a query-only interface. The ODBC driver supports only SELECT statements or read-only functions, and does not modify your instance data. Because the ODBC driver uses the web services interface, platform-wide access control (ACL) is enforced and data security is in place.

Note:

The ODBC driver has these limitations:

  • The ODBC driver supports only SELECT statements or read-only functions, and does not modify your instance data.
  • There is no supported way to use the ODBC driver with a Java client application or with a Java JDBC-ODBC bridge.
  • There is a hardcoded limit of 512 characters when accessing views through ODBC. Because of this limitation, a maximum of 11 table sys_ids can be included in an ODBC view query. Anything over 11 tables results in an error.
Note: Versions of the ODBC driver older than 1.0.7.3 are no longer supported.