XML Table Compare Overview


The XML table compare specification allows users to compare table data between two XML table files or between an XML table file and any other supported database type. The maximum number of files or tables allowed in a comparison is 100. The maximum number of fields allowed within a table is 990.

To create a trigger compare

  1. From the File menu, select New > General Data Compare. The connection wizard appears.
  2. From the Connector Type list, select XML as Table.

Note

The XML Table Compare specification tends to "see" only the uppermost hierarchical tags within an XML document. To ensure that table data is identified correctly, each table record should be nested within a set of table tags:

<record>
<firstname>Joe</firstname>
<lastname>Smith</lastname>
<address>25625 Millionaire Street</address>
<city>Calumet</city>
<state>Michigan</state>
<postalcode>49913</postalcode>
</record>

Note

An XML baseline file may contain high-level tags without matching fields in the test database table. If this occurs, return to the Connection Wizard and remove the non-matching fields. Change the first field of the XML file (typically used as the index key) to match a test field. Finally, select a valid field to be used as the new index key.

 

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