How to Customize the Integration Data Model in UCMDB

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

Out-of-the-box CIs for DDMI integration can be extended in one of the following ways:

To add a new CI type to the DDMI Adapter:

In UCMDB, create the CI type that you want to add to the adapter, if it does not already exist. For details, see "Create a CI Type" in the HPE Universal CMDB Modeling Guide.
Go to the orm.xml file as follows: Data Flow Management > Adapter Management > DDMiAdapter > Configuration Files > orm.xml.
Map the new CI type by adding a new entity called generic_db_adapter.[CI type].
In the orm.xml file, ensure that the new CI type has the following mappings:
1. the data_note attribute is mapped to the NMID_StatusInAppliance column (this attribute is used for checking the CI's status).
2. the last_modified_time and create_time attributes are mapped to the Device_UpdatedDt and Device_FirstFoundDt columns.
For details, see "The orm.xml File" in the HPE Universal CMDB Developer Reference Guide.
Create queries to support the new CI types that you added. Make sure that all mapped attributes have been selected in the Advanced Layout settings:
1. In the Modeling Studio, right-click the node where you want to include the attribute.
2. Select Query Node Properties.
3. Click Advanced layout settings and select the new attribute.
For details about selecting attributes, see "Layout Settings Dialog Box" in the HPE Universal CMDB Modeling Guide. For limitations on creating this TQL query, see Troubleshooting and Limitations – DDMI Integration.
In UCMDB, navigate to Data Flow Management > Integration Studio.
Edit the DDMI integration point to support the new CI type by selecting it either for population or for federation.
If the new CI type is for population, edit the population job that you created in Define a population job (optional) to include the new TQL query.