How to Add a New Mapping to the Integration

Add a New Mapping to the Integration

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

This example shows how to add a new TQL query and push-mapping to the integration for a CIT called Example. It consists of the following steps:

Step 1: Create a TQL Query

Go to Modeling > Modeling Studio > New > Query.

From the CI Types tab, add Example CIT to the query.

Right-click the Example Query Node and select Query Node Properties.

Go to the Element Layout tab.

Select Select attributes for layout.

In the Attributes condition drop down, select Specific Attributes, and add the new attributes that you want to map and push to Service Anywhere.

Click OK.

Save the query to Modeling > Modeling Studio > Resources > Queries > Root > Integration > Service Anywhere Push.

Step 2: Create a Push-Mapping

Go to Data Flow Management > Adapter Management > SAWPushAdapter.

Click Create new resource and select New Configuration File.

Type the a name for the file.

Select the SAWPushAdapter package.

Click OK.

Copy the following into the newly created XML file, replacing ExampleCI with the name of the relevant CI:

<integration 
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:noNamespaceSchemaLocation="../generic-push-adapter.xsd">
 <info>
  <source name="UCMDB" versions="10.0" vendor="HP"/>
  <target name="ServiceAnywhere" versions="1.0" vendor="HP"/>
 </info>
 <import>
  <scriptFile path="mappings.scripts.SAWPushFunctions"/>
 </import>
 <targetcis>
  <source_ci_type query-element-name="ExampleCI*">
   <target_ci_type name="ExampleCI">
     <variable name="externalId" datatype="STRING" 
      value="ExampleCI['external_id_obj']"/>
     <variable name="serviceName" datatype="STRING" 
      value="'CMDB_UDM_1_6'"/>
     <variable name="attributesHierarchy" datatype="STRING" 
      value="'model.instance'"/>
     <variable name="keysHierarchy" datatype="STRING" 
      value="'model'"/>
     <variable name="keyTag" datatype="STRING" value="'ID'"/>
     <variable name="keyVal" datatype="STRING" 
      value="ExampleCI['cmdb_id']"/>
     <variable name="retrieveRequestName" datatype="STRING" 
      value="'RetrieveExampleCI'"/>
     <variable name="createRequestName" datatype="STRING" 
      value="'CreateExampleCI'"/>
     <variable name="deleteRequestName" datatype="STRING" 
      value="'DeleteExampleCI'"/>
     <variable name="updateRequestName" datatype="STRING" 
      value="'UpdateExampleCI'"/>
     <target_mapping name="Name" datatype="STRING" 
      value="ExampleCI.attributeExists('name') ? 
      ((ExampleCI['name']==null)
      ?ExampleCI['display_label']:ExampleCI['name']) : 
      'MISSING'"/>
     <target_mapping name="Description" datatype="STRING" 
      value="ExampleCI.attributeExists('description') 
      ? ExampleCI['description'] : 'MISSING'"/>
     <target_mapping name="DisplayLabel"  datatype="STRING" 
      value="ExampleCI.attributeExists('display_label') 
      ? ExampleCI['display_label'] : 'MISSING'"/>
     <target_mapping name="GlobalId"  datatype="STRING" 
      value="ExampleCI.attributeExists('global_id') 
      ? ExampleCI['global_id'] : 'MISSING'"/>
    </target_ci_type>
  </source_ci_type>
 </targetcis>
</integration>

Click OK.

Step 3: Create a Job with the New TQL Query

Go to Data Flow Management > Integration Studio.

Create an Integration Point with Service Anywhere.

In the Integration Jobs tab, click New Integration Job .

Insert a job name in the Name field.

Click Add Query , and choose the newly created query.