This documentation supports the 21.05 version of BMC Helix CMDB.To view an earlier version, select the version from the Product version menu

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*