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

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