O'Reilly logo

Pentaho 3.2 Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required