Creating the deployed assets to IT assets mapping

The mapping provides expressions that specify what data to transform and how to transform the data for a property. These expressions are used when Integration Composer imports the data from the deployed assets tables into Assets.

Before you begin

Ensure that data sources are open for the source and target databases, using the Connection Information page in the Open Source Data Source and Open Target Data Source windows. Accept the defaults established during the last connection to the data source or updating the fields.

Procedure

  1. Sign in to Integration Composer and select  Create New Mapping.
  2. From the Source drop-down list of existing and available data sources, select Deployed Assets Source.
  3. From the Target drop-down list of existing and available data sources, select Assets Target.
  4. In the Mapping Name field, enter Deployed Assets to Assets as the mapping name, and click OK. Mapping names are case-sensitive.
  5. In the Integration Composer Mapping window, select the Import action.
  6. In the Import Mapping dialog box, select the AssetInitDPA75toAssets75.fsn mapping file and click Open.
  7. Modify the itemnum property for each class.
    1. In the tree view in the Target pane, select the class whose itemnum you want to modify.
    2. In the table view in the Target pane, scroll to the itemnum property.
    3. In the itemnum property row, double-click the cell in the Expression column. Integration Composer displays the selected expression in the Expression Builder dialog box.
  8. Modify the classstructureid property.
    1. In the tree view in the Target pane, select the class whose classstructureid you want to modify.
    2. In the table view in the Target pane, scroll to the classstructureid property.
    3. In the classstructureid property row, double-click the cell in the Expression column to display the selected expression in the Expression Builder dialog box
  9. Modify the status property.
    1. In the tree view in the Target pane, select the class whose status you want to change.
    2. In the table view in the Target pane, scroll to the status property.
    3. In the status property row, double-click the cell in the Expression column. In the Expression field, type the appropriate string literal for your status (including quotation marks). For example, “OPERATING”.
    4. Press Enter to save the expression.
  10. Modify asset specification properties, such as disk size, memory size, and processor speed, by mapping them to system specification attributes.
    1. In the tree view in the Target pane in the lower half of the window, select the class whose asset specification you want to change.
    2. In the table view in the Target pane, scroll to the asset specification property that you want to modify.
    3. In the asset specification property row, double-click the cell in the Expression column. In the Expression field, type the expression that you want to use for the asset specification property using the '<class>.<property>' format.
    4. Press Enter to save the expression.
  11. Check for Java parsing errors in the mapping in the Integration Composer Mapping window, by selecting the Show Errors action.
  12. Save the mapping, by selecting the Save action, and close the Mapping window.
Parent topic: Deployed assets to IT assets mapping

Feedback