Skip to main content

About the ServiceNow collector

Important

This collector is currently in early preview and is intended for limited use. Before setting up this collector, please contact your Customer Success Director or Implementation team for guidance.

Use this collector to:

  • Directly harvest metadata from ServiceNow instances including system applications, application scopes, tables, fields, views, and Data Fabric tables

  • Catalog ServiceNow Data Fabric (ZeroCopy virtualized data integration) metadata

Important

The ServiceNow collector can be run in the Cloud or on-premise using Docker or Jar files.

Note

The latest version of the Collector is 2.308. To view the release notes for this version and all previous versions, please go here.

What is cataloged

The collector catalogs the following information.

Table 1.

Object

Information cataloged

ServiceNow Instance

Instance URL, Connection metadata

System Application

App Name, Vendor, Version, Active status, Short Description, Source Table

Application Scope

Scope Name, Scope Identifier, Vendor, Version, Active status, Source Table

Table

Table Name, Is Extendable, sys_updated_on (timestamp), Source Table, Parent Table (for table inheritance)

Data Fabric Table

Inherits all Table properties, Plus: Association with external DatabaseTable

View

Inherits all Table properties, Plus: View Definition (SQL definition including source tables and join conditions)

Field

Field Name, Column Label, Internal Type, Max Length, Reference Table (for reference fields), Mandatory, Is Primary (for Data Fabric fields), SQL Type (for Data Fabric fields)

View Table Mapping

Maps To Table, WHERE clause conditions, Is Left Join, Variable Prefix, Mapping Order



Relationships between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.

Table 2.

Resource page

Relationship

ServiceNow Instance

Contains Application Scopes, System Applications, Tables

System Application

Contained within Application Scope

Application Scope

Contains System Applications and Tables (via has scoped resource)

Table

Contained within Application Scope, Has Fields, May extend another Table (via extends table), May be extended by child Tables

Data Fabric Table

Inherits all Table relationships, Plus: Derived from external DatabaseTable (via prov:wasDerivedFrom)

View

Inherits all Table relationships, Has View Table Mappings

Field

Belongs to a Table (via has field), May reference another Field (for reference/foreign key fields)

View Table Mapping

Belongs to a View (via has view table mapping), Maps To Table (via maps to table), Selects data from Table



Lineage for ServiceNow

The following lineage information is collected by the ServiceNow collector.

Table 3.

Object

Lineage available

View

View Table Mappings show:

  • JOIN conditions and WHERE clauses

  • Tables from which the view selects data

  • Variable prefixes and mapping order

Table

Table inheritance lineage:

  • Parent table (via extends table relationship)

  • Child tables that extend this table

Field

Reference field lineage:

  • Fields in other tables that this field references

  • Indicates foreign key relationships

Data Fabric Table

External data source lineage:

  • External DatabaseTable from which data is virtualized (via prov:wasDerivedFrom)



ServiceNow version supported

  • The ServiceNow collector supports ServiceNow instances that expose the Table API. The collector has been tested with ServiceNow Zurich and Australia releases.

Authentication supported

  • The collector authenticates to ServiceNow using Basic Authentication (Username and Password).

In this section: