Example 1: Parsing XML data

Create a simple job that uses the Hierarchical Data stage and the XML Parser step to parse employee data, which is stored in one XML data file, into two flat files.

About this task

This basic parsing example uses the sample XML data file, departments.xml, and the sample schemas, Employee.xsd and Organization.xsd, to illustrate parsing source data from one XML file into two files. The departments.xml file contains information about the employees of one department in a company. In this example, you parse the XML data into two files. One file contains employee business information: employee name, date of hire, date of birth, gender, title, employee ID and department ID. The second file contains employee address information: employee ID, street, city, state, postal code, country, and address type.

To create the example, complete these tasks:

  1. Example 1: Creating the job
    Create the example job that includes one Hierarchical Data stage and two Sequential File stages.
  2. Example 1: Opening the Assembly Editor and viewing the issues
    For each Hierarchical Data stage, you open the Assembly Editor, which you use to define an XML transformation within the context of a job.
  3. Example 1: Importing the schemas for the examples
    Use the Schema Library Manager to import the example schemas into a library.
  4. Example 1: Configuring the Overview
    The Overview provides creation and modification information about the assembly and includes a Description field that you can modify.
  5. Example 1: Configuring the XML Parser step
    Configure the location of the XML source data and the schema that you want to use to parse it.
  6. Example 1: Configuring the Output step
    In the Output step, create mappings that define how to map source items in one data structure to target items in another data structure.
  7. Example 1: Viewing the output of the job
    After you run the parsing job, open the text files, and look at the output.
Parent topic: Examples of transforming XML data