Effectual Systems Group, Inc. Community

Effectual Packaged Integration Enhancement for ITSM/UCMDB. The most comprehensive drop-in integration package available. Robust enough to support any use case and flexible enough to accommodate any customer enhancements.


About the Package

While an integrated UCMDB and ITSM has become a priority for many Micro Focus customers, it has proven difficult to actually achieve with the out-of-the-box (OOTB) UCMDB ITSM Integration Adapter package. The design of the OOTB package is just too generic to support real-world ITSM/SMA implementations. It oversimplifies essential information that you’ve spent time and effort accumulating, and must be heavily customized with narrowly-defined use cases in mind before being put into use. The package “works” at first glance, but over time it creates multiple sets of redundant data in each tool, jamming up the entire system.

Effectual’s PIE for IT Service Manager (ITSM) is a fully mature adapter which provides a much more robust series of jobs, reflecting the actual data and source being used. Effectual’s advances greatly increase data quality, performance, and the efficacy of ITSM and UCMDB as a single platform. You will immediately see more relevant data in ITSM, experience less confusion and fewer problems with UCMDB, and vastly reduce maintenance overhead immediately and permanently. With an additional service and support contract, we can also tailor our packages to your unique environment. You can move to testing and deployment in a matter of weeks. We make integration and automation accessible and easy to extend to even the largest, most confusing data sets.

Key Benefits

  • Transforms UCMDB and ITSM to work as a single platform
  • Delivers the absolute best possible data quality and performance
  • Radically accelerates time to value and saves thousands of consulting hours in integration design
  • Empowers decision makers by improving stakeholder confidence in data accuracy, timeliness, and actionability
  • Increases efficiency by reducing the time and cost of process overhead
  • Supports any use case
  • Prepares your organization for success with emerging technologies like AI and machine learning

Key Features

  • Ensures a single, synonymous data set with Effectual’s complete CIT & attribute mappings
  • Eliminates Unwanted CIs and unintended deletions reducing system bulk and ensuring data quality
  • No custom code or external apps to maintain
  • Allows prioritization of volatile CITs
  • Flexible to upgrade; will not break like brittle custom solutions
  • Seamlessly integrates with other PIE solutions allowing your organization to gain a competitive edge by pursuing advanced use cases

In-Depth Features

  • Granular TQL organization for both Push and Population of Data: PIE creates integration jobs pre-organized and populated with common TQLs representing each level. Each push and population TQL has been developed to execute on discrete sets of CITs, resulting in faster run times and moving only targeted CI data. Attribute mappings have been fully established between products, allowing for increased customization of attribute modification or preservation. For more granular updates to specific data, such as assets, the adapter includes push TQLs paired with specifically tailored WSDL objects on Service Manager, so any specific data elements that need to be changed will do so without affecting the rest of the record in SM.
  • Robust Attribute Mapping: Attributes are fully mapped between CI types in order to ensure that more data elements are visible on the Service Manager side after a push. Each mapping utilizes more absolute and specific element definitions wherever possible, enabling full bi-directional synchronization while avoiding the common reconciliation issues which result from using only a display label or logical.name. Since more data elements are pushed into each SM/SMA record, duplicate names are largely avoided. The resulting combined mapping then benefits reconciliation when the record or related records is populated back into UCMDB.
  • Automated Change Creation: By leveraging the existing SM ability to open unplanned changes through Discovery Event Manager rules, automated changes and incidents can be opened based on discovered data or changes between authorized or actual states.
  • ITSM Undiscoverable CI Population: The included SM .unl file includes modifications required for non-discoverable data synchronization with UCMDB. Once the appropriate changes have been made to Service Manager, the adapter will be capable of populating Assignment Groups, Contacts, Locations, Companies, Departments and IT Process Records as actual CITs in UCMDB. This enhanced capability eliminates the time and overhead required to call these records via API. It also makes them available for modeling and transfer into other systems in UCMDB. UCMDB ID is then used as the sole identifier for these records, removing the need for complicated scripts writing to multiple custom fields.
  • UCMDB Undiscoverable Data Push: Data from other systems, such as financial information from Asset Manager, can be pushed into SM (where appropriate) as actionable records. By pushing these synonymous CIs and data elements into SM/SMA, they can be used to drive other processes that are not otherwise covered by the standard OOTB UCMDB-SM/SMA integration.
  • IT Process Record Population: The SM/SMA Process Records (Change, Incident, Request For Change, Known Error, Interaction and Task) will be populated into UCMDB as actual CIs, complete with relationships to associated CIs/records from SM/SMA, as well as affected CIs, other IT Process Records, and any other present data (such as organizations or SM/SMA users). Additionally, these changes can be tracked through their entire lifecycle using the UCMDB History function.
  • Integration with other Effectual PIE solutions: Data types from other PIE solutions stored or created in UCMDB by other integrated programs are incorporated in each TQL. From ITAM financial data to UCMDB Browser-based perspectives and models, those data all get moved for consumption in SM/SMA.

To give us feedback on this package, discuss a service and support contract, or to find out more about our other PIE solutions, contact Effectual

Minimum Requirements

Please note that package is compatible with older versions as well. These extended system requirements are as follows:

The following versions of UCMDB: 

  • HP/HPE UCMDB 9.x, 10.x

  • Micro Focus UCMDB 11.x  

The following versions of Service Manager: 

  • HP Service Manager 7.x (Push only)

  • HP/HPE Service Manager 9.x

  • Micro Focus Service Manager 9.6

  • Micro Focus Service Management Automation Suite 


PIE for ITSM 1.2
3.4 MB
Apr 17, 2018
More info Less info
Product Compatibility
Universal CMDB
Version 10.40 · 10.22 · 10.33
Version 11.0
Service Management Automation (SMA) Suite
Version 2017.11
Version 2018.02
Release Notes

Package Includes:

  • 12 Common xslt mapping files to provide consistent attribute mapping across all of the out-of-the-box UCMDB CI Types 
  • Over 400 separate XSLT mapping files corresponding with every single out-of-the-box UCMDB CI Type, enabling full control over Integration Points pre-configured with Push and Population jobs to handle bi-directional dataflow for discoverable CIs and models 
  • All the files and population jobs needed to retrieve the various undiscoverable data from Service Manager for use in UCMDB
  • Integration points now come with pre-configured Population jobs to retrieve contact data, location data, and even IT Process Records like RFCs and Incidents 
  • A set of TQLs that follow UCMDB Browser modeling templates that will push user-driven models directly into SM

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox