Concepts and Processes → Process Apps Overview → UCMDB Integration Process App → Setting up the UCMDB Integration
SBM On-Premise only
The UCMDB Integration process app enables you to populate data in the CMS Configuration Items table with items from your UCMDB system, such as servers, software, services, laptops, phones, or other CIs (configuration items).
You will enter credentials for your UCMDB system in an auxiliary table, and then define one or more Scheduler jobs in Application Administrator to run a ModScript that executes your TQL queries.
To set up the integration:
In SBM Configurator, open the Manage Services tab and ensure that the Notification Server is running. The Notification Server must be running in order to use the Scheduler feature in Application Administrator.
Edit your user account and ensure that you have Table privileges to modify the UCMDB Configuration and UCMDB Integration auxiliary tables.
In Application Administrator, navigate to the Manage Data page.
Select UCMDB Integration in the Table drop-down list, and edit the UCMDB record.
Enter the User Name and Password of a user account that can run TQL queries against your UCMDB system using a REST service call. Save your changes.
Select UCMDB Configuration in the Table drop-down list. The UCMDB record that is created when you promote the UCMDB Integration process app contains JSON data that maps a set of attributes in UCMDB to fields in the CMS Configuration Items table. Review the JSON that is provided and update it as needed.
In Application Administrator, navigate to the Scheduler page, and then add a new job.
Provide the following information:
Click Run Job Now to perform the initial import immediately, or wait for your scheduled job to run, and then view the Application Event log to confirm that the job finished successfully.
The initial import will create all the items that the TQL query returns, which can be substantial number of items, depending on the query. Therefore, consider running the job off-hours or when system usage will be low.
CIs from UCMDB are imported into the Configuration Items table and ready for use with the CMS application.
Copyright © 2012–2018 Serena Software, Inc., a Micro Focus company. All rights reserved.