JDBC type data source

A JDBC data source retrieves its data via a JDBC driver, usually type 4 network.

The JDBC connection is available either directly from the ServiceNow instance (a VPN setup required), or via a dedicated MID Server installed inside your firewall that can access the database port.

Note: JDBC calls from the MID Server are never encrypted. Limit the rights available to the MID Server user whenever making JDBC calls from a MID server.

JDBC data source supported database formats

JDBC data sources support several database formats and ports.

Table 1. Supported Database Formats
SQL Server Type Port
MySQL 3306
Microsoft SQL Server 1433
Oracle 1521
Note: Oracle DATE fields are loaded as ServiceNow datetime fields.

JDBC data source SQL statement requirements

JDBC queries that run SQL statements must specify a column name.

For example, this query specifies the column name ServerID.
SELECT DISTINCT 'server_name:' + CONVERT ( VARCHAR , lg .ResourceID ) AS 'ServerID' 
ON s .ResourceID  = lg .ResourceID
WhereType0  = 'Local' AND Category0  = 'SystemAccount'

SQL server integrated authentication for Windows

A JDBC data source can use the ID of for the Windows MID Server service user to authenticate with SQL Server.

The Use integrated authentication check box on the Data Source form determines if the JDBC data source uses the MID Server service user credentials. For this field to appear on the Data Source form, the integration must meet these criteria:

  • The MID Server must be running on a Windows computer with SQL Server.
  • The MID Server service must use the same credentials that SQL Server requires.
  • The data source Type is JDBC.
  • The data source Use MID Server check box is selected.
  • The data source Format is SQLServer.
Important: If integrated authentication is chosen, and you are integrating with Microsoft System Center Configuration Manager, the account running the MID Server service must have read rights on the SCCM database.
Figure 1. Data Source form