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.

To load or extract XML data:

• Determine the Transformation Schema
• Write a Transform
• Write the gpfdist Configuration
• Load the Data
• Transfer and Store the Data

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