Integrate > Micro Focus UCMDB > Using the ServiceManagerAdapter9.41 Adapter > Tailoring the Integration > Integration Tailoring Options > How to Map the CI Type's Query to an XSL Transformation File

How to Map the CI Type’s Query to an XSL Transformation File

The integration uses a configuration file called smSyncConfFile.xml to map each Universal CMDB query to an XSL transformation file. In order for custom queries to be part of the integration, you must add a mapping entry for each query in the configuration file.

The following steps illustrate mapping the query rdbmsData described in previous sections to the Service ManagerucmdbRDBMS web service.

Tip Wildcard support for query names in smSyncConfFile.xml

When adding a query name in the smSyncConfFile.xml file, you can use a wildcard (an asterisk) in the query name. This is helpful in the debugging phase when you may have updated an out-of-the-box query and saved it as several query names. For example, if you have saved the <Query_name> query to <Query_name>_1, and <Query_name>_2, you can specify the query name as <Query_name>* in the configuration file, and the integration will automatically use this mapping entry on all of the three queries.

Note Out-of-the-box, all query names in the smSyncConfFile.xml file are suffixed with a wildcard (an asterisk).

To map a query to an XSL transformation file:

  1. Log in to UCMDB as an administrator.
  2. Navigate to Data Flow Management > Adapter Management > ServiceManagerAdapter9.41 > Configuration Files.
  3. Click the smSyncConfFile.xml file.
  4. Add a query mapping element to the file by copying an existing one. A query mapping element uses the following format: 
    <tql name="Query" xslFile="XSL_File">
    <!-- Description of mapping -->
    <request type="Create" name="Create_web_service"/>
    <request type="Update" name="Update_web_service"/>
    <request type="Delete" name="Delete_web_service"/>
    </tql>

    Query is the name of the UCMDB query you created.

    XSL_File is the name of the XSL transformation file the integration will use to map Universal CMDB attributes to Service Manager web service fields.

    Create_web_service is the name of the Service Manager web service you want to the integration to use to create CIs from this query.

    Update_web_service is the name of the Service Manager web service you want to the integration to use to update CIs in this query.

    Delete_web_service is the name of the Service Manager web service you want to the integration to use to delete CIs from this query.

    See the following screenshot for an excerpt of smSynchConfFile.xml:

  5. Add or update query mapping elements for each query you want to add to the integration. For example, the following query creates a mapping between the rdbmsData query and the rdbms_push.xslt file. 
    <tql name="rdbmsData" xslFile="rdbms_push.xslt">
    <!-- this is database tql -->
    <request type="Create" name="CreateucmdbRDBMSRequest"/>
    <request type="Update" name="UpdateucmdbRDBMSRequest"/>
    <request type="Delete" name="DeleteucmdbRDBMSRequest"/>
    </tql>
  6. Save the configuration file.

    Note When you create/edit and then save a configuration file in Adapter Management, UCMDB automatically restarts the adapter with the new configuration file.