Add a new mapping to the integration

This example shows how to add a new TQL query and push-mapping to the integration. It also shows how to push Locations from UCMDB to APM. It consists of the following steps:

• Step 1: Create a TQL Query

  1. Go to Modeling > Modeling Studio > New > Query.
  2. From the CI Types tab, add a Location to the query.
  3. Right-click the Location Query Node and select Query Node Properties.
  4. Rename the Element Name to Root.
  5. Go to the Element Layout tab.
  6. Select Select attributes for layout.

  7. In the Attributes condition drop down, select Specific Attributes, and add the Name attribute

  8. Click OK.

  9. Save the query to Root > Integration > APM Push > APM Location Push.

• Step 2: Create a Push-Mapping

  1. Go to Data Flow Management > Adapter Management > APMPushAdapter.
  2. Click the Create new resource button and select New Configuration File.
  3. Type the following Name: APMPushAdapter/mappings/pushMappingAPMLocation.xml.
  4. Select the APMPushAdapter package.
  5. Click OK.

  6. Copy the following into the newly created XML file:

     Example: <integration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      <info>
         <source name="UCMDB" versions="10.0" vendor="HP"/>
         <target name="APM" versions="2.0" vendor="HP"/>
       </info>
       <import>
         <scriptFile path="mappings.scripts.APMPushFunctions"/>
       </import>
       <targetcis>
         <source_instance_type query-name="APM Location Push" root-element-name="Root" >
           <target_ci_type name="request">
             <target_mapping name="uuid" datatype="STRING" value="Root['global_id']"/>
             <target_mapping name="requestType" datatype="STRING" value="'APM - Location'"/>
             <target_mapping name="description" datatype="STRING" value="Root['name']"/>
             <target_ci_type name="fields">
               <target_mapping name="REQ.DESCRIPTION" datatype="STRING" value="APMPushFunctions.subString(Root['name'],200)"/>
             </target_ci_type>
           </target_ci_type>
         </source_instance_type>
       </targetcis
     </integration>

     In the following line:

     <target_mapping name="requestType" datatype="STRING" value="'APM - Location'"/>

     The value is the request type name in APM. In this example, it is APM - Location.

  7. Click OK.

• Step 3: Create a Job with the New TQL Query

  1. Go to Data Flow Management > Integration Studio.
  2. Create an Integration Point with APM.
  3. In the Integration Jobs tab, click the New Integration Job button .
  4. Insert a job name in the Name field.
  5. Click the button, and choose the APM Location Push query.
  6. Click OK.

• Step 4: Run the Job

  1. Click on the job created in Step 3: Create a Job with the New TQL Query .
  2. Click the All Data Synchronization button (or Full Synchronization).
  3. Wait for the job to finish. You should click the Refresh button to see progress.
  4. Make sure that the status is Succeeded.

• Step 5: View the Results

  1. Log on to OpenText PPM.

  2. On the Open menu,

     • Click Application Portfolio > Search Entities, then in the Entities section, click Location. Or,
     • Click Search > Requests, then from the Request Type drop-down list, select APM - Location.

  3. Click Search.

     The Search Results page displays request search results.