How to add a new XML table to the ADT Mapper metadata in a format that accommodates GRLoader?

book

Article ID: 49943

calendar_today

Updated On:

Products

Advantage Data Transformer

Issue/Introduction

Summary:

I have read the Advantage Data Transformer Knowledge Document, TEC529012, about how to extend Federation Adapters by adding fields to an XML file definition. However, I need to add metadata for an entire new table that I've added to the CMDB database. How can I create the XML table metadata in ADT Mapper?

Solution:

You can define the new table in Mapper, but it needs more modification after that, so the steps will be

  1. DEFINE THE NEW XML TABLE METADATA IN MAPPER

  2. EXPORT THE NEW TABLE DEFINTION and EDIT IT

  3. DELETE THE TABLE DEFINITION IN MAPPER

  4. IMPORT THE MODIFIED TABLE DEFINITION INTO MAPPER

Details of these steps are shown below.

Before you begin, you may want create a folder for your extended table to distinguish it from the default metadata created by Install Federation Adapters. If so, right-click on the XML Server icon of the Data tab, and select Insert Folder. If not, you will use the existing CMDB_FederationAdapters folder.

  1. DEFINE THE NEW XML TABLE METADATA IN MAPPER

    Define your new xml table. Right-click and select Insert XML object.

    <Please see attached file for image>

    Figure 1

    Enter the name of your XML "table".

    Then select a path and filename for the default output file. In this example it is
    C:\Program Files\CA\Service Desk Manager\cmdb\data\userdata\MyNewTable.xml.

    <Please see attached file for image>

    Figure 2

    Click Finish.

    This puts you on the XML Object Definition screen.

    From here, follow the instructions in TEC529019 to add fields and attributes.

    <Please see attached file for image>

    Figure 3

    Click OK and the definition is done. However, the highest level must be GRLoader and that can't be changed in Mapper.

  2. EXPORT THE NEW TABLE DEFINTION and EDIT IT

    Export the metadata using Mapper File/Export. Then open the exported file for edit.

    This example uses UltraEdit-32 to view a standard Mapper export side-by-side with the one just created.

    <Please see attached file for image>

    Figure 4

    In the MyNewTable export, look for the "XMLComponent" tag. Just below it is the name of the XML Component.

    Change that name from MyNewTable to GRLoader. Be sure to change only the name of the XMLComponent and not the XMLObject.

    <Please see attached file for image>

    Figure 5

  3. DELETE THE TABLE DEFINITION IN MAPPER

    Go back to Mapper and delete the table you created before you exported it.

    <Please see attached file for image>

    Figure 6

  4. IMPORT THE MODIFIED TABLE DEFINITION INTO MAPPER

    In Mapper, select File > Import, and locate the xml file that you modified.

    <Please see attached file for image>

    Figure 7

    MyNewTable XML file has been added to a folder in the Data tab of Mapper.

    <Please see attached file for image>

    Figure 8

    Now the new table has the name MyNewTable, while the top Element is GRLoader.

    <Please see attached file for image>

    Figure 9

Environment

Release:
Component: DWM

Attachments

1558709793001000049943_sktwi1f5rjvs16rmc.gif get_app
1558709791245000049943_sktwi1f5rjvs16rmb.gif get_app
1558709789485000049943_sktwi1f5rjvs16rma.gif get_app
1558709787504000049943_sktwi1f5rjvs16rm9.gif get_app
1558709785465000049943_sktwi1f5rjvs16rm8.gif get_app
1558709783531000049943_sktwi1f5rjvs16rm7.gif get_app
1558709781575000049943_sktwi1f5rjvs16rm6.gif get_app
1558709779676000049943_sktwi1f5rjvs16rm5.gif get_app
1558709777856000049943_sktwi1f5rjvs16rm4.gif get_app