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.
- Fixed
- Fixes related to conditional classes and their mappings (PRB1849679, PRB1843627)
- Security fixes
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