(Optional) Push CI Data from UCMDB to HPE APM

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Data push jobs copy or update CI or CI relationship records from the local UCMDB system to your HPE APM system.

To run a customized data push job, complete the following steps:

Log on to UCMDB as an administrator.

Navigate to Data Flow Management > Integration Studio.

UCMDB displays a list of existing integration points.

Select the integration point you created for HPE APM.

Select the default data push job APM Push.

Or, if the default data push job does not satisfy your needs, you may add a new data push job as follows:

Click the New Integration Job button in the right panel.
In the Name field, type a unique name for the job.

Click the Add Query button to add existing TQL queries to the job.

UCMDB creates a default data push job when creating the integration point for HPE APM. The following table lists the Topology Query Language (TQL) queries in the default data push job. If required, you may create, update, or remove TQL queries for the push job. You may also need to update the mapping.

Note To access these OOTB TQL queries for push, navigate to Modelling > Modeling Studio > Resources, select Queries from the drop-down list for the Resource Type field and then navigate to Root > Integration > APM Push.

TQL Query	Description
APM Location Push	Pushes Location CIs. Mapping XML: `pushMappingAPMLocation.xml`
APM Process Push	Pushes BusinessProcess CIs. Mapping XML: `pushMappingAPMProcess.xml`
APM Process Relation Clear Push	Clears old relations between processes in HPE APM. This TQL query synchronization must have been run BEFORE the 'APM Process Relation Push' TQL query synchronization. Mapping XML: `pushMappingAPMProcessRClear.xml`
APM Process Relation Push	Pushes relations between Processes (pushed by APM Process Push) to other business elements or to processes. BusinessProcess CIs must have been pushed before this TQL query synchronization in the ‘APM Process Push’ TQL query synchronization. Mapping XML: `pushMappingAPMProcessR.xml`
APM Server Push	Pushes Node CIs (Computers, Network Devices, etc.). Mapping XML: `pushMappingAPMServer.xml`
APM Server Relation Clear Push	Clears old relations between Servers in HPE APM. This TQL query synchronization must have been run BEFORE the 'APM Server Relation Push' TQL query synchronization. Mapping XML: `pushMappingAPMServerRClear.xml`
APM Server Relation Push	Pushes relations between Servers (pushed by APM Server Push) to other servers. Node CIs must have been pushed before this TQL query synchronization in the ‘APM Server Push’ TQL query synchronization. Mapping XML: `pushMappingAPMServerR.xml`
APM Application Push	Pushes BusinessApplication CIs. Location, BusinessProcess, and/or Node CIs must have been pushed before this TQL query synchronization. Mapping XML: `pushMappingAPMApplication.xml`
APM Application Relation Clear Push	Clears old relations (except for the downstream relations) between Applications in HPE APM. This TQL query synchronization must have been run BEFORE the 'APM Application Relation Push' TQL query synchronization. Mapping XML: `pushMappingAPMApplicationRClear.xml`
APM Application Relation Push	Pushes relations (except for the downstream relations) between Applications (pushed by APM Application Push) to other business elements or to nodes. BusinessApplication CIs must have been pushed before this TQL query synchronization in the ‘APM Application Push’ TQL query synchronization. Mapping XML: `pushMappingAPMApplicationR.xml`
APM Application Relation Clear Down Push	Clears old downstream relations between Applications in HPE APM. This TQL query synchronization must have been run BEFORE the 'APM Application Relation Down Push' TQL query synchronization. Mapping XML: `pushMappingAPMApplicationDownRClear.xml`
APM Application Relation Down Push	Pushes downstream relations between Applications (pushed by APM Application Push) to other business elements or to nodes. BusinessApplication CIs must have been pushed before this TQL query synchronization in the ‘APM Application Push’ TQL query synchronization. Mapping XML: `pushMappingAPMApplicationDownR.xml`

Select the Allow Deletion option for each query.

This allows deletion of synchronized data in HPE APM when data in UCMDB are deleted. Otherwise requests created in HPE APM as a result of synchronization remain even when their original data in UCMDB are deleted.

Note For scheduling configuration, see Schedule Data Push Jobs.
Click OK.
Save the integration point.

Run the job manually to see if the integration job works properly:

To push all the relevant data for the job, click the All Data Synchronization button (or Full Synchronization).
To push only the changes in the data since the job last executed, click the Changes Synchronization button (or Delta Synchronization).

The job is in Running status. Wait for the job to complete; click the Refresh button multiple times as needed until the job is completed.

You can also look at the Query tab as that gives a progress bar against the query it is running.

When the job is completed, the job status becomes one of the following depending on the results:

Succeeded
Passed with failures
Failed

Click the Statistics tab to view the results; if any errors occur, click the Query Status tab and Job Errors tab for more information. For more information about errors, see Troubleshooting and Limitations – APM Push Integration.