ODBC driver installation requirements and supported software
Summarize
Summarized using AI
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.
Summary of ODBC driver installation requirements and supported software
The ServiceNow ODBC driver enables Microsoft Windows users to query ServiceNow instances through standard SOAP web services over HTTPS. It requires specific configuration, user roles, and software dependencies to function properly. This guide outlines the essential installation requirements and supported operating systems and reporting applications to ensure successful deployment and use.
Show less
Installation requirements
- Active user: The user account used for queries must exist in the ServiceNow instance with appropriate permissions. Single sign-on accounts are not supported.
- User roles and permissions: If the instance enforces high security with the
glide.soap.strictsecuritysetting, the user must have thesoapqueryrole. Do not enable WS-Security for all SOAP requests viaglide.soap.requirewssecurity, as this blocks ODBC connections. Use basic authentication instead. - Table access: The querying user must have read access to the target tables, and these tables must allow web service interaction configured through application access settings.
- Dependencies: The driver requires two JAR files—
bcpkix-fips-1.0.3.jarandbc-fips-1.0.2.4.jar—which must be downloaded from the ServiceNow Store and extracted locally. - Java environment: Java Runtime Environment (JRE) must be enabled on the ServiceNow instance, and Java Development Kit (JDK) version 11 is required on the client machine.
- Operating systems: Supported Windows versions span from Windows XP through Windows 10, including Windows Server editions from 2003 through 2022, as well as Windows Vista and Windows 7/8.
- Hardware requirements: Minimum 1 GB RAM and 135 MB disk space for installation, plus 200 MB for cache files during operation.
- Installation account: The Windows account installing the driver must have local Administrator rights.
- Network connectivity: The driver requires HTTPS connectivity (port 443) to communicate securely with the ServiceNow instance.
- End User License Agreement: Users must comply with the license terms for the ServiceNow ODBC driver.
Supported software
The ODBC driver supports various reporting and data analysis applications on compatible Windows platforms:
- Microsoft Excel: Versions 2007 through 2016 are supported.
- Microsoft SQL Server: Versions from 2008 through 2023 are supported.
- Crystal Reports: Versions 2008, 2011, and 2013 are supported.
- Tableau: Versions 8.1 through 9.0 are supported.
- Informatica: Basic support only; suitable for simple operations. Thorough testing is recommended before production use.
Driver versions 1.0.13 and later support the widest range of operating systems and reporting tools. Earlier versions support fewer platforms and applications.
Install the ServiceNow ODBC driver on Microsoft Windows computers.
Installation requirements
Before installing the ODBC driver, ensure that your configuration meets these
requirements.
| Category | Requirement |
|---|---|
| Active user | The user record on the instance used to perform the queries. Note: The account
used to connect to the instance via the ODBC driver must be defined on the
instance. Accounts using single sign-on are not supported by the ODBC
driver. |
| The soap_query role | The user you use to query the database must have the soap_query role if the
instance uses the glide.soap.strict_security high security
setting. Warning: Do not enable WS-Security for all SOAP requests by
setting the glide.soap.require_ws_security system property.
It is incompatible with the ODBC driver. Enabling this setting blocks both ODBC
driver and MID Server connections. Instead, use basic
authentication. |
| Target Table ACLs | The user you use to query the database must have read access for the tables that you want to query. For example, a user with the itil role can read task tables, such as Incident. |
| Target Table Web Service Access | The table you want to query must allow web service interaction. You can enable web service interaction using the application access settings. |
| ODBC Driver Dependencies (2.0.1) | Download the ZIP files of bcpkix-fips-1.0.3.jar and bc-fips-1.0.2.4.jar mentioned in the dependencies file from ServiceNow® Store and extract the JARs to a local folder on your Windows machine. |
| Java Runtime Environment (JRE) | JRE must be enabled on your instance. |
| Java Development Kit (JDK) | version 11 |
| Operating System | The ServiceNow ODBC
driver supports installation on the following operating systems:
|
| Hardware |
|
| Account | The Windows account used for the installation must have local Administrator rights to install an ODBC driver. |
| Networking | During usage, the ODBC driver requires HTTPS (port 443) connectivity to the ServiceNow instance. The communication between the ODBC driver and the ServiceNow instance uses standard SOAP web services for normal mode. |
| End User License Agreement | Read the End User License Agreement for the ServiceNow ODBC driver. |
For more information, see Application access settings.
Supported software
The following table lists the operating systems and reporting applications compatible with
each version of the ODBC driver.
| Driver Version | Operating System | Microsoft Excel | Microsoft SQL Server | Crystal Reports | Tableau | Informatica |
|---|---|---|---|---|---|---|
| 1.0.13 and later |
|
|
|
|
|
The ODBC driver provides only basic support for Informatica. Use the ODBC driver with Informatica only for simple operations. Thoroughly test integrations with Informatica before using them in a production environment. |
| 1.0.9 - 1.0.12 |
|
|||||
| 1.0.8 and earlier |
|
8.1 |