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

Document ID : KB000049943
Last Modified Date : 14/02/2018
Show Technical Document Details

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.

    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.

    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.

    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.

    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.

    Figure 5

  3. DELETE THE TABLE DEFINITION IN MAPPER

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

    Figure 6

  4. IMPORT THE MODIFIED TABLE DEFINITION INTO MAPPER

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

    Figure 7

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

    Figure 8

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

    Figure 9