How to Push Data from UCMDB to BMC Remedyforce

1. Prerequisite - Set up protocol credentials

   Make sure that you have set up the Salesforce Rest Protocol. For credential information, see Supported Protocols.

2. Configure queries

   The CIs and relationships to be pushed to BMC Remedyforce have to be queried from UCMDB using TQL queries. Create integration type queries to query the CIs and relationships that have to be pushed to BMC Remedyforce.

   An example of such a query, RemedyforcePushSampleQuery, is included with this integration package, and can be viewed in the Modeling Studio.

   For details on viewing queries in the Modeling Studio, see the Modeling section of the UCMDB Help. For details about the push query, see UCMDB Help > Developer Reference > Creating Discovery and Integration Adapters > Developing Push Adapters > Build an Adapter Package.

   Note An attribute mapping is required for each CI that maps global_id of UCMDB to BMC Remedyforce as its unique ID. Below is an example:

   <target_attribute name="__ID__" datatype="String">
       <map type="direct" source_attribute="global_id"/>
   </target_attribute>

3. Create XML mapping files

   For every query created in the step above, create an XML mapping file with exactly the same name (case-sensitive) as the integration query.

   You can find a sample mapping file RemedyforcePushSampleMapping.xml through Data Flow Management > Adapter Management > Resources > Packages > Remedyforce_Push > Configuration Files > RemedyforcePushAdapter/mappings
   /RemedyforcePushSampleMapping.xml.

   For details on how to create your own mapping file, see UCMDB Help > Developer Reference > Creating Discovery and Integration Adapters > Developing Push Adapters > Create Mappings.

4. Advanced usage of the mapping

   In order to support more complex requirements of the mapping, you can embed dynamic business logic in the mapping file. Two new datatypes are defined to achieve the goal:

   • Evaluate an expression

     The datatype is eval. This mapping can evaluate a Python expression as a value of the target attribute. Below is an example:

     <target_attribute name="BMCServiceDesk__Name__c" datatype="eval">
     	<map type="constant" value=" 'Intel' if ('Intel' in 
     CI['TEL_COL_Vendor__c'])  else 'AMD' "/>
     </target_attribute>

     In this examle:

     CI is a build-in container. If the target CI attribute TEL_COL_Vendor__c contains string Intel, set the BMCServiceDesk__Name__c attribute value to Intel. Otherwise, set it to AMD.

   • Run a function

     The datatype is function.This mapping can run a customized function that contains the custom business logic. The return value of the function is the value of the target attribute. The value of the function is composed of a python module name and a function name with a dot. Below is an example:

     <target_attribute name="BMCServiceDesk__Name__c" datatype="function">
     	<map type="constant" value="my_module.set_name "/>
     </target_attribute>

     To create your own module, for example, my_module, do the folllowing:

     1. Go to Data Flow Management > Adapter Management > Resources > Packages > Remedyforce_Push > Scripts.
     2. Click the button and select New Jython Script.
     3. Type my_module in the Name field, and then click OK.

     4. Put the following code into my_module.py:

        #coding=utf-8
        import string
        import re
        

        import logger
        import modeling

        from appilog.common.system.types import ObjectStateHolder
        from appilog.common.system.types.vectors import ObjectStateHolderVector

        def set_name(CI):
            name = "AMD"
            if "Intel" in CI['TEL_COL_Vendor__c']:
        	name = "Intel++"
            return name

5. Create the integration point

   Define the integration point as follows:

   1. In UCMDB, go to Data Flow Management > Integration Studio.

   2. In the New Integration Point dialog box, enter a name and description for the integration point.

      Ensure the Is Integration Activated option is enabled.

   3. In the Adapter field, click the Select Adapter button.

   4. In the Select Adapter list, select Remedyforce Push Integration and click OK.

   5. In the Adapter Properties section, enter the following required properties:

      Field	Value
      Credentials ID	Select the credential entries you created in step 1 for the Salesforce Rest Protocol. For credential information, see Supported Protocols.
      Data Flow Probe	Select the name of the Data Flow Probe on which the integration will run.
      Additional Probes	This field is unavailable for this integration.

   6. Click Test connection to verify the connectivity, and click OK. If the connection fails, verify that the information provided is correct.

   7. Click OK to save the integration point.

   8. Add a new job definition to the integration point. Provide a name for the job definition and select the queries to use to synchronize data from UCMDB to BMC Remedyforce. Define a synchronization schedule if required.

      Note Jobs can also be run without a schedule.

   9. Save the job definition, and then the integration point.
   10. Click to run a full synchronization for each job at least once.