Integration [477] - Executive Scorecard import Node, Service, Application and relevant Topology data from CMS (XS <- CMS)

  • KM01696003
  • 11-Jun-2018
  • 11-Jun-2018


Integration Catalog


Executive Scorecard import Node, Service, Application and relevant Topology data from CMS (XS <- CMS) - Catalog Id: 477


This out-of-the-box data integration imports Universal CMDB (UCMDB) data into Executive Scorecard. The data is then combined with other data sources, transformed, analyzed, and loaded as metrics on a series of Executive Scorecard tabs.

The UCMDB data includes Node, Service, Application and Topology of (Node -> Service, Node -> Application and Application -> Service) data. In Services both business services and infrastructure services data is queried.  When existing , the service data extracted from UCMDB is treaded as the master data of the services, consolidating the service entity from all other services.
At this phase, no other entities are fetched from UCMDB, but the specific query can be customized to be extended.



The data warehouse is the repository for key business data that supports queries, reports, and populates business analytics. The content of the data warehouse originates with external applications such as HP Universal CMDB. The data warehouse enables data integration and promotes data consolidation by using consistent data models regardless of the disparate data models among different data sources. The data warehouse software relies on common data models that support each phase of the Extract, Transform, and Load (ETL) process.
The ETL process is an end-to-end transfer of external source data through several staging layers and into the target layer of the data warehouse. The data warehouse uses the ETL process to extract, consolidate, and transform the source data into a meaningful target model that populates relevant business analytics.
The ETL process is delivered as an Integration Content Pack (I-CP), which is an independent software component that can be installed, updated, and managed independently from the underlying platform.
The extraction is done through querying the UCMDB interface for business services, infrastructure services, and combining the two result-sets into one. This unified service table is then streamed through the ETL process.


Leading Product:
IT Business Analytics

Secondary Product:
Universal CMDB



Content Reference Guides zip file can be found using the following link, Please unpack the zip and take the relevant Content Reference Guide:



Support Matrix

Universal CMDB
IT Business Analytics
SupportedSupported (see comments)Not Supported

Generated: 6/11/2018 4:41:41 AM