Configurable Common Data Model mapping rules

In Integration Composer, Data Integration Services (DIS) naming attribute mappings are hardcoded. However, in IBM® Control Desk, you can configure mappings with a separate XML file, CDMMapping.xml. This file provides the mappings from Maximo® database attribute names to DIS naming attributes.

DIS naming attributes are used to generate the Naming and Reconciliation Service (NRS) integration identifiers. In the CDMMapping.xml file, mappings are defined for all naming attributes that can be used by DIS, regardless of whether they require cleansing.

The file is held in the following folder:

Maximo applications/maximo/properties/sccd

Mapping file structure

The mapping file uses the following structure:

<CDMClass class="ComputerSystem">

<MBOObject object="ASSET">
   <MBOClassification id="43210500" allUnder="true"/>
   ...
</MBOObject>

<MBOObject object="CI">
   <MBOClassification id="CI.COMPUTERSYSTEM"/>
   <MBOClassification id="CI.AIXCOMPUTERSYSTEM"/>
   <MBOClassification id="CI.HPUXCOMPUTERSYSTEM"/>
   ...

Where:

<CDMClass> defines a Common Data Model (CDM) class. Currently, ComputerSystem is the only supported value.
<MBOObject> tags are used to define a MBO object, for which an integration identifier can be generated under the CDM class. It can contain several <MBOClassification> tags.
<MBOClassification> tags are used to define specific classification IDs, under the MBO object, for which integration identifiers are generated. In this case, integration identifiers are generated for different computer systems. If no classification IDs are defined, integration identifiers are generated for all classifications.
The <MBOClassification> tag has an optional attribute, allUnder. If the value of this attribute is true, an integration identifier is generated for the classification specified and all child classifications.

When DeployedAsset is defined as the MBO object, using the statement <MBOClassification id="-ALL-"/> processes any valid classifications for that object type.

...
<CDMAttribute attribute="Manufacturer">
   <MBOAttribute object="ASSET" table="ASSET" attribute="MANUFACTURER" />
   <MBOAttribute object="CI" table="CISPEC" attribute="ALNVALUE" 
    assetattrid="COMPUTERSYSTEM_MANUFACTURER"/>
   <MBOAttribute object="ACTCI" table="ACTCISPEC" attribute="ALNVALUE" 
    assetattrid="COMPUTERSYSTEM_MANUFACTURER"/>
...

Where:

<CDMAttribute> tags are used to define CDM naming attributes. This tag can contain one or more <MBOAttribute> tags.
<MBOAttribute> tags define the MBO attributes that are mapped to the CDM naming attribute. The <MBOAttribute> tag has four attributes:
- object: The object to which this attribute belongs. This object is one of the MBO objects, ASSET or CI, defined for the CDM class
- table: The database table in which this attribute is stored.
- attribute: The column in the table in which this attribute is stored.
- assetattrid: If the table is a specification, this attribute is its assetsttrid, such as assetspec or cispec.

Feedback