How to Work with Generic Adapter Mapping UI?

This end-to-end workflow walkthrough scenario describes how to integrate UCMDB with Service Manager in order to import the newly discovered 3D Printer CIs into Service Manager.

This workflow includes the following steps:

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

Step 3. Create the TQL query to see all the 3D Printer instances

Follow these steps to create the TQL query to see all the 3D Printer instances:

Go to the Modeling Studio, click New , and then click Query.
From the CI Types pane, locate the 3D Printer CI type, and then drag and drop the 3D Printer CI type into the Query Definition canvas.

Note To preview the query result, click the Preview button .
Right-click the 3D Printer query node, and then click Query Node Properties.
In the Query Node Properties window, make the following changes so that this TQL query can be used to push data to the Service Manager server.
1. Change the element name to Root to indicate the root of the TQL query.
2. In the Element Layout tab, select the Select attributes for layout option, add the Name and Global Id attributes to the Specific Attributes column.
  
  These attributes will be pushed to Service Manager. You can add other attributes if you want.

Step 5. Create the new CI Type and the mapping for the new CI Type in Service Manager

Follow these steps to create the new CI Type in Service Manager by using UCMDB’s Mapping Tool and to create a mapping for the new 3D Printer CI Type:

Right-click the newly created integration point, and then click Go to Adapter.

The ServiceManagerEnhancedAdapter9.x adapter opens in Adapter Management.
To create the mapping file, make sure the ServiceManagerEnhancedAdapter9-x adapter is selected, click New , and then click New Configuration File.
Enter the mapping file name in the Name field.
Note Include the full path in the Name field, for example:
```
ServiceManagerEnhancedAdapter9-x/mappings/push/SM 3D Printer Push.xml
```
Click OK, and then click Yes if you are prompted with the following message:

Do you want to open the configuration file with the new mapping tool editor?

The UI Mapping Tool opens.
Click Add New CI Type to External Class Model .
Fill in the needed information for the new CI Type, and then click OK.
Define the TQL query that provides the CIs need be pushed to Service Manager. To do this, click Add TQL Queries in the Local Query pane, and then select the previously created 3D Printers TQL query.
Select the Root node under the 3D Printers TQL query node in the Local Query pane, and then drag it onto the Integration node in the Visual Mapping pane.

This configuration indicates that the data source for this mapping is the 3D Printers TQL query rooted in the Root element.
Select the Service Manager entities that will be created as a result of the mapping process. To do this, drag the 3DPrinter type from the External Class Model pane onto the 3D Printer TQL query node in the Visual Mapping pane.
Drag the needed attributes of the Service Manager 3DPrinter type from the Attributes pane onto the 3DPrinter node in the Visual Mapping pane. In this case, the Type attribute and two mandatory attributes: CIIdentifier and UCMDBId.
Double click each of the three attributes and enter the values as follows:
- Type: ‘3dprinter’
  
  The Type attribute need be passed to Service Manager as a string. Don not miss the single quotes, which are needed to differentiate a string constant from a variable.
- UCMDBId: Use the Global Id attribute from UCMDB.
  
  To do this, drag the Global Id attribute from the Attributes pane onto the UCMDBId element in the Visual Mapping pane.
- CIIdentifier: Use the Name attribute from UCMDB and make a small customization.
  
  To do this, follow these steps:
  1. Double-click the CIIdentifier element in the Visual Mapping pane, and then type Root[. A drop-down box appears and shows the available attributes for the Root TQL query element of the 3D Printer CI Type.
  2. Select Root[‘name’].
  3. Continue type + ' - ucmdb imported'.
    
    The final value is Root['name'] + ' - ucmdb imported'.
  The following screen shot shows the result of the mapping process.
Click Save .