How to Create an XML Configuration File for a Relationship Type

To create an XML configuration file for a relationship type:

1. Log in to UCMDB with an administrator account.
2. Navigate to Data Flow Management > Adapter Management > ServiceManagerEnhancedAdapter9.41, and select the adapter.
3. Click the Create New Resource icon .
4. Select New Configuration File.
5. Enter the full file name: <AdapterID>/mappings/push/<filename>. For example, ServiceManagerEnhancedAdapter9.41/mappings/push/SM Cost CostCategory Ownership.xml.
6. Click OK to save to the new file. The new file appears in the list of configuration files.
7. Open the new file in the XML Editor of the Visual Mapping interface.

8. Copy the content from an existing mapping file to overwrite the content of the new file in the XML Editor pane, and update query name to the name of the query you created (Cost CostCategory Ownership Relations Push).

   <?xml version="1.0" encoding="UTF-8"?>
   <integration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../mappings_schema.xsd">
       <info>
           <source name="UCMDB"     version="10.20" vendor="HP"/>
           <target name="SM"       version="9.40"    vendor="HP"/>
       </info>
       <import>
           <scriptFile path="mappings.scripts.SMPushFunctions"/>
       </import>
       <!--
           Push Cost to Cost Category Relations. 
       -->
       <target_entities>
           <source_instance query-name="Cost CostCategory Ownership Relations Push" root-element-name="Root">            
               <target_entity name="Relationship">
                   <target_mapping name="RelationshipType" datatype="STRING" value="SMPushFunctions.getDisplayName(Root['element_type'],ClassModel)"/>
                   <target_mapping name="ParentCI" datatype="STRING" value="SMPushFunctions.getEndId(OutputCI.getExternalId().getEnd1Id())"/>
                   <target_mapping name="ChildCIs" datatype="STRING_LIST" value="[SMPushFunctions.getEndId(OutputCI.getExternalId().getEnd2Id())]"/>
               </target_entity>
           </source_instance>
       </target_entities>
   </integration>
   

9. Click the Save icon to save the new configuration file.

Now, you have added the new relationship type to the integration. Next, you need to add the new relationship query to a data push job, as shown in the following figure. For detailed steps, see How to Add a Custom Query to an Integration Job.