Transforming XML Data

Transforming XML Data

The Greenplum Database data loader gpfdist provides transformation features to load XML data into a table and to write data from the Greenplum Database to XML files. The following diagram shows gpfdist performing an XML transform.

Figure 1. External Tables using XML Transformations

To load or extract XML data:

The first three steps comprise most of the development effort. The last two steps are straightforward and repeatable, suitable for production.