Data quality in the ServiceNow CMDB and foundational tables is a key to proper usage of various workflows on the platform.
IntegrationHub ETL (IH-ETL) is a UI based tool that offers an easy to use interface to Extract, Transform and Load data from third-party data sources into the CMDB and foundational tables.
IH-ETL uses Concurrent Import Sets, Robust Transform Engine (RTE), and Identification and Reconciliation Engine (IRE) to ensure:
- Efficient import of data
- Mapping of complex, hierarchical data sets to appropriate CI classes
- Support for non-CMDB tables (3.1 and Utah release)
IntegrationHub ETL (IH-ETL) is intended to be used by developers who are creating new integrations, as well as by CMDB Administrators who manage and fine-tune existing integrations. Some operation types supported in the UI require more advanced users (for example, creating a Script operation).
Feature highlights:
IH-ETL provides a wizard-style user experience that allows users to do the following:
- Import source data and integrate it into the CMDB.
- Preview third-party source data and prepare it for mapping to CMDB classes and attributes.
- Choose target classes in the CMDB to which to map source data, and add relationships among these classes.
- Preview sample integration results and schedule imports.
- Perform rollback if the results of the preview are not satisfactory.
- Map nested JSON payload quickly and easily
- Ability to Activate/Deactivate mappings to prevent a class from being populated during the integration run, while preserving all of its mapping configuration.
And now (3.1 and later) support for non-CMDB tables.
New
- Integration Hub ETL is now WCAG2.2 and WCAG2.2AA compliant. Improvements include removal of extra spaces between menu items, addition of required children to ARIA roles, fixes for accessibility warnings, and removal of unnecessary scroll bars. Integration Hub ETL now supports reflow, allowing content to be zoomed up to 400% in a browser without loss of content or functionality. Page layouts automatically transform into a vertical, stacked view at 400% zoom. This update benefits users with low vision and those working across varied devices and environments.
The following required plugins are automatically installed:
- Integration - Commons Components (com.snc.integration.common)
- Integration Studio API (com.glide.integration_studio)
Required roles:
Any user with a cmdb_inst_admin role can use the IH-ETL tool. For reference, the cmdb_inst_admin role is comprised of the following roles:
- import_admin
- itil_admin
- itil
- action_designer