Learning Pentaho Data Integration 8 CE - Third Edition

Creating XML files

If you want to generate an XML file with a simple structure, you can do it with an XML output step.

Besides the basic information you provide in any output step (as, for example, file name and location), you have to provide names for Parent XML element and Row XML element. Then the step creates the XML file as follows:

1. It encloses each row between tags with the name you provided for Row XML element.
2. Finally, the step encloses the whole structure between tags with the name provided for Parent XML element.

For more complicated structures, you should use extra steps, in particular, the XML Join step. The basic idea is to create partial XML structures and start merging them together until you have the final structure.

As ...