How to Export UCMDB to XML

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)`

Prerequisite - General

Create a directory on the UCMDB data flow probe system to which the adapter will write the exported XML files.
In the Modeling Studio, create integration TQL queries for the data to be exported to XML. Ensure the queries return valid results.

Prerequisite - Create an integration point and integration job

In the Integration Studio, create a new integration point.

Provide a name and description for the integration point.
Under Integration Properties > Adapter, select UCMDB to XML adapter.
Under Adapter Properties > Export Directory type an absolute path of the directory on the probe system where the adapter should export the XML files to.
Under Adapter Properties > Data Flow Probe Name, select the name of the Data Flow Probe to be used.
Click the Test Connection button to ensure the adapter can validate the defined export directory.
Save the integration point.
Under Integration Jobs add a new integration job. Edit the job to add integration queries under the job's definition.

For details on integration points, see Integration Studio > Work with Data Push Jobs > Create an integration point in the HPE Universal CMDB Data Flow Management Guide.
Click OK to save the integration job.
Click the Save button to save the integration point.

Run the job

To run the job ad hoc, select the integration job and click the button. The job can also be configured to run on a schedule.
Check the defined export directory on the probe system for the exported XML data, to ensure the queries create valid XML files.

Note The XML files have time stamps in the format YYMMDDHHMMSSZZZ. If the integration query returns a large number of CIs, the export is by chunks of 1,000 CIs. Each chunk is a separate XML file, with the file for the last chunk having the string EOD (end of data) appended to it.