ODBC driver installation requirements and supported software

  • Release version: Xanadu
  • Updated August 1, 2024
  • 2 minutes to read
    • 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 databases via standard SOAP web services over HTTPS. This document outlines the installation requirements, supported operating systems, necessary account permissions, software dependencies, and compatibility with reporting applications.

    Show full answer Show less

    Installation requirements

    • Active user: The user account in ServiceNow used for queries must exist and cannot use single sign-on. It must have the soapquery role if high security is enabled (glide.soap.strictsecurity).
    • Security settings: WS-Security for all SOAP requests (glide.soap.requirewssecurity) must not be enabled, as it blocks ODBC and MID Server connections. Use basic authentication instead.
    • Table access: The querying user must have read permissions on target tables, with proper ACLs and web service access enabled.
    • Dependencies: Java Runtime Environment (JRE) must be enabled on the instance. Java Development Kit (JDK) version 11 is required locally. Two JAR files—bcpkix-fips-1.0.3.jar and bc-fips-1.0.2.4.jar—must be downloaded from the ServiceNow Store and extracted locally.
    • Operating system support: Supported Windows versions include XP, Vista, 7, 8, 10, and Server editions from 2003 through 2022.
    • Hardware requirements: Minimum 1 GB RAM and at least 135 MB disk space for installation; additional 200 MB for cache files.
    • Installation account: The Windows account performing the installation must have local Administrator rights.
    • Networking: HTTPS connectivity on port 443 to the ServiceNow instance is required for communication.

    Supported software

    The ODBC driver supports integration with various reporting and database tools on Windows platforms, including:

    • Microsoft Excel: Versions 2007 through 2016.
    • Microsoft SQL Server: Versions 2008 through 2023.
    • Crystal Reports: Versions 2008 through 2013.
    • Tableau: Versions 8.1 through 9.0.
    • Informatica: Basic support only; recommended to thoroughly test before production use.

    Driver versions 1.0.13 and later support the broadest range of Windows OS and reporting applications. Earlier versions support fewer operating systems 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.
    Table 1. Installation 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:
    • Windows XP
    • Windows Server 2003
    • Windows Server 2008
    • Windows Server 2012
    • Windows Server 2016
    • Windows Server 2019
    • Windows Server 2022
    • Windows Vista
    • Windows 7
    • Windows 8
    • Windows 10
    Hardware
    • RAM: 1 GB minimum
    • Disk space: 135 MB for installation, 200 MB for writing cache files during usage
    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.
    Table 2. Supported software
    Driver Version Operating System Microsoft Excel Microsoft SQL Server Crystal Reports Tableau Informatica
    1.0.13 and later
    • Windows XP SP2
    • Windows Vista
    • Windows 7
    • Windows 8.x
    • Windows 10
    • Windows Server 2003
    • Windows Server 2008
    • Windows Server 2008 R2
    • Windows Server 2012
    • Windows Server 2012 R2
    • Windows Server 2016
    • Windows Server 2019
    • Windows Server 2022
    • 2007
    • 2010
    • 2013
    • 2016
    • 2008
    • 2012
    • 2014
    • 2019
    • 2022
    • 2023
    • 2008
    • 2011
    • 2013
    • 8.1
    • 8.2
    • 8.3
    • 9.0
    		 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
    • Windows XP SP2
    • Windows Vista
    • Windows 7
    • Windows 8.x
    • Windows Server 2003
    • Windows Server 2008
    • Windows Server 2008 R2
    • Windows Server 2012
    • Windows Server 2012 R2
    1.0.8 and earlier
    • Windows XP SP2
    • Windows Vista
    • Windows 7
    • Windows 8.x
    • Windows Server 2003
    • Windows Server 2008
    • Windows Server 2008 R2
    		 8.1