ServiceNow data source

ServiceNow is a platform used for CMDB, asset management, and enterprise service management.

The ServiceNow data source uses an API connection to bring ServiceNow data into Data Manager.

How do I connect ServiceNow to Data Manager?

1. Gather all of the Data Manager type information, including the data source name, short display name, and the data source type.

2. Gather the ServiceNow fields – this may require consultation with the ServiceNow subject matter expert (SME).

3. In Data Manager, add a new data source by selecting the tool you which to connect and configure with all the gathered information.

Each time this data source is fetched the data becomes raw data.

Data Manager fields

You need to specify the following information from Data Manager:

• Data source name – the name of the data source used to run, transform, map, cleanse, and import the data.

• Short display name – a unique name as a data source label.

• Data source type – what type of data the tool is providing. For example, Assets, CMDB, user location.

ServiceNow fields

• Authentication type – Basic or OAuth.

• API URL – instance URL, for example: https://<instance>.service-now.com

• Source table/view name – table or view in ServiceNow to retrieve records from.

• API limit – maximum number of records per call.

  • Default: 0 (no restriction)

  • Recommended: 1000 for heavily populated tables

• API fields – comma‑separated list of field names to return. None returns all fields.

• API query – encoded query string to filter results server‑side.

If using Basic Auth

• Username – for generating the auth token.

• Password – for generating the auth token.

• Basic authentication token – base‑64 encoded string generated after you provide username and password and select Generate.

If using OAuth

• Username

• Password

• Client secret – used to generate the authorization token.

• Client‑ID – identifies the OAuth client.

Authentication and authorization

The connector supports Basic and OAuth. The ServiceNow user must have:

• read‑only access to required tables/views

• rest_api_explorer role

Consult the ServiceNow SME to obtain the correct credentials and roles.

API call

The ServiceNow data source uses the Table API to access base tables or custom views.

Fields retrieved

Commonly consumed tables include:

• cmdb_ci_computer

• cmdb_ci_vm_instance

• cmdb_ci_server

• alm_hardware

The exact set of fields depends on:

• which table you call; and

• which API fields are specified (or None for all fields).

For environments where you want all ServiceNow data in a single view, you can use the Data Aggregator connector to merge multiple ServiceNow tables into one Data Manager data source.