Exporting XML data from BMC Helix CMDB

You can export your XML data from BMC Helix CMDB by using the CMDB_CI_XML_EXPORT.ktr transformation. This transformation takes data from different tables based on parent-child (one-to-many) relationships and populates in XML files with multilevel hierarchy maintaining the parent-child relationship. To retrieve valid data, the parent's instance ID is passed as a parameter from the child tables, which in turn provides the hierarchy of the parent-child relationship.

Related topics

Transferring-data-from-external-data-stores-to-BMC-Helix-CMDB


To export XML data from BMC Helix CMDB

Perform the following steps to export XML data from BMC Helix CMDB:

  1. Open the CMDB_CI_XML_EXPORT.ktr transformation.
  2. To modify the parent CI, double-click the parent CI step .
    1. In the Table input dialog box, modify the SQL query by providing information about the new parent CI.
    2. Click OK.
  3. To modify the child relationship, double-click the child CI step .
    1. In the Table input dialog box, modify the SQL query by providing information about the new child CI.
    2. Click OK.
  4. Run the job.
    For more information, see Running-a-transformation-job-in-Atrium-Integrator-Spoon.
  5. Double-click the Text file output step.
    The Text File Output dialog box appears.
  6. Verify the XML file as shown in the following figure:
    CMDB_CI_XML ktr.jpg




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*