In this example, each <Customer> element contains more than one <Order> element which itself contains many child elements as shown below. Exult maps this XML into an Order table linked to its parent, the Customer table.
Example Source XML
Mapped as shown below (click for larger view):
XML Data imported into the database shown below.(click for larger view):
CUSTOMER |
ORDER |
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.