Pentaho Data Integration Beginner's Guide

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

In this section, you will build an Excel file with basic information about countries. The source will be an XML file that you can download from the book's website.

1. Open the kettle.properties file located in a folder named .kettle inside your home directory. If you work under Windows, that folder could be C:\Documents and Settings\<your_name>\ or C:\Users\<your_name>\ depending on the Windows version.
2. If you work under Linux (or similar) or Mac OS, the folder will most probably be /home/<your_name>/.

   Note

   Note that the .kettle folder is a system folder, and as such, may not display using the GUI file explorer on any OS. You can change the UI settings to display the folder, ...