Loading

ODBC Driver

From ServiceNow Wiki
Home > Integrate > ODBC Driver > ODBC Driver
Jump to: navigation, search
Web Services

Contents

1 Overview

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. Because it uses the web services interface, platform-wide access control (ACL) is enforced and data security is in place.

Note
Note: The ServiceNow 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.


2 Downloading the ODBC Driver

The current release is 1.0.7.1 and is recommended for all versions of the ServiceNow platform. For more information, see the ODBC Release Notes.

The ODBC driver is available from these self-extracting executable files. See installing the ODBC driver for more information.

3 Working with ODBC

Follow these general steps to set up and use the ODBC driver:

  1. Install the ODBC driver or upgrade an existing ODBC installation.
  2. Configure the ODBC driver.
  3. Test the configuration.
  4. Use your applications with ODBC.
  5. Use the ODBC driver, following ODBC best practices.

Additionally, there is an ODBC quick start guide and video tutorial available.

For troubleshooting information, see the knowledge base articles troubleshooting ODBC driver issues and troubleshooting common ODBC error messages.

4 Using Client Applications with the ODBC Driver

See the following pages for examples of how to use the ODBC driver to create data sources from other applications.

5 Enhancements

5.1 Dublin

  • When export query strings become large enough to impact performance, the ODBC driver converts the data type from VARCHAR to the LONGVARCHAR data type.
  • The ODBC driver respects character limits set in the dictionary.
Was this article helpful?
Yes, I found what I needed
No, I need more assistance
Views
Personal tools