Welcome to the Novixys Documentation Library, the authoritative source for information about Novixys products, resources and related technologies.
This is a simple example of a customer XML database which stores customer information for many customers. The example illustrates how Exult creates tables, columns and foreign key relationships in the simplest case.
In this example, each Customer element contains one or more Order elements which stores many fields of information about each order. The Order element is linked to the parent Customer element with foreign key relationships.
Exult treates CDATA sections just like text content within an element. In the following example, <Title> and <Description> elements contain CDATA sections. Content within the CDATA sections is treated like any other text content.
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.