Time for action—getting data from an XML file with information about countries

In this tutorial you will build an Excel file with basic information about countries. The source will be an XML file that you can download from the Packt website.

  1. If you work under Windows, open the kettle.properties file located in the C:/Documents and Settings/yourself/.kettle folder and add the following line:
    LABSOUTPUT=c:/pdi_files/output
    

    On the other hand, if you work under Linux (or similar), open the kettle. properties file located in the /home/yourself/.kettle folder and add the following line:

    LABSOUTPUT=/home/yourself/pdi_files/output
    
  2. Make sure that the directory specified in kettle.properties exists.
  3. Save the file.
  4. Restart Spoon.
  5. Create a new transformation. ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.