ODBC driver

The ServiceNow ODBC driver allows an ODBC client to connect to the ServiceNow platform for reporting.

The ServiceNow ODBC driver allows an ODBC client to connect to the ServiceNow platform for reporting. The 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 older than 1.0.7.3 of the ODBC Driver are no longer supported.