Words and Phrases
How to Map Each Relationship Type Query to an XSL Transformation File
Once you have created a query for a relationship type, you need to map the query to an XSL transformation file as described in the following steps.
Tip Out-of-the-box, there is a common XSL transformation file (common_relations.xslt), which is used for pushing all types of CI relationships. For this reason, you do not need to create a new XSL transformation file; instead, you only need to map the new relationship query to this existing XSLT file.
- Navigate to Data Flow Management > Adapter Management > ServiceManagerAdapter9.41 > Configuration Files.
- Click the
smSyncConfFile.xmlfile. - Add a query mapping entry by copying an existing one for relationship push. For example, copy the following query mapping entry.
<tql name="SM Layer2 Topology Relations Push*" xslFile="common_relations.xslt">
<request type="Create" name="CreateRelationship"/>
<request type="Update" name="UpdateRelationship"/>
<request type="Delete" name="DeleteRelationship"/>
</tql>
- Change the query name to the name of the query you created for the relationship type. For example, cost_costcategory_ownership_relation_push.
<tql name="cost_costcategory_ownership_relation_push" xslFile="common_relations.xslt">
<request type="Create" name="CreateRelationship"/>
<request type="Update" name="UpdateRelationship"/>
<request type="Delete" name="DeleteRelationship"/>
</tql>
- Click OK to save the 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 (see the following figure and How to Add Custom queries to Data Push Jobs).
Refer to the following screenshot to add a new relationship query to a data push job.
