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: The ServiceNow ODBC driver has these limitations:
2 Downloading the ODBC Driver
The current release is 220.127.116.11 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:
- Install the ODBC driver or upgrade an existing ODBC installation.
- Configure the ODBC driver.
- Test the configuration.
- Use your applications with ODBC.
- Use the ODBC driver, following ODBC best practices.
Additionally, there is an ODBC quick start guide and video tutorial available.
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.
- Using Interactive SQL (ODBC)
- Using ODBC Driver in SQL Server 2008
- Using the ODBC Driver in Excel 2010
- Using the ODBC Driver in Crystal Reports 2008
- 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.