Setting ODBC properties

The following properties customize connectivity and optimize the query behavior of the ODBC driver.

ODBC Administrator Properties

These properties are specified in the ODBC Data Source Administrator for the DSN or in the Custom Properties field of the login dialog box.
Table 1. ODBC Administrator Properties
Property Name Description Default
BatchSize During fetching of results from the instance, this batch size configures the number of records to fetch for every request. Typically, the default is an optimal number for normal sized rows. If an error occurs during fetching of records that indicates this value should be lowered, you can modify it to optimize memory usage versus performance. 2000
url This is the ServiceNow instance URL or endpoint. It should indicate the URL to the ServiceNow instance you want to connect to. https://demo.service-now.com
EnablePassThrough During processing of aggregate functions, enabling pass through mode allows directly calling Aggregate Web Service for optimized and speedy response. Whenever possible, this mode should be left enabled. true
debug By default, debugging messages are not produced. Set debug to true when you operate the ODBC driver from the ISQL console window to write all HTTP-related network communication traffic to the console window. When using this option, set gzip to false so that data is not compressed. Otherwise, the data is unreadable. false
gzip By default, data sent over the network is compressed. Set gzip to false when using the debug parameter to write network communication to the ISQL console so that data is not compressed. true
timeout Specifies the socket inactivity timeout value in seconds. 175
retries Number of times to retry the failing request in the event of a socket timeout error. 0
mode

The query mode used to parse complex where clauses. You can configure the ODBC driver query mode to use either AND or OR operators.

While the OR operator provides the greatest compatibility with complex queries, the AND operator is usually more efficient and results in fewer database operations.

or

If you need to use more than one of these properties in your connection, concatenate the settings with a semicolon (;) delimiter. For example, the following string sets the URL to a specific instance and changes the batch size to 200 records.

url=https://demo1234.service-now.com;BatchSize=200

ODBC management console properties

You can access these properties from the ODBC Management Console available in the Windows Start menu at ServiceNow ODBC > Management Console.
Table 2. ODBC Management Console Properties
Property name Description Default
ServiceJVMOptions

(Services\Service Settings\IP Parameters)

JVM command line properties and option. For example, to change the maximum Java heap size, modify the -Xmx150m parameter. -Xms64m -Xmx150m
DataSourceIPProperties

(OpenAccess SDK 6.0 Manager\<installation location>\Services\ServiceNow_ODBC\Data Source Settings\ServiceNow\IP Parameters)

Global default of the instance URL for all ODBC connections. For more flexibility, you may also create new DSNs with default URL configurations. https://demo.service-now.com

Service JVM options

You can specify these values within the ServiceJVMOptions parameter in addition to standard JVM arguments such as -Xmx.
Table 3. Options
Option Description Default
-DLOG_FILE_NAME The location of the ODBC log file. This property is available starting with the ODBC driver 1.0.7.1 release. ${user.home}\AppData\Local\ServiceNow\odbc\logging\odbc.log
-DLOG_LEVEL The logging level used when writing to the ODBC log file. You can specify the logging level using Logback levels, such as TRACE, INFO, or ERROR. This property is available starting with the ODBC driver 1.0.8 release. INFO

Instance properties

An administrator can configure these properties by adding a property or modifying an existing one in the ServiceNow instance.
Table 4. Instance Properties
Property name Description Default
glide.db.max.aggregates The maximum number of rows returned by aggregate functions. 100000
glide.db.max_view_records The maximum number of rows returned by a database view. 10000