- Pentaho Data Integration Beginner's Guide（Second Edition）
- María Carina Roldán
- 306字
- 2021-07-23 15:46:55
Time for action – running the matches transformation from a terminal window
Let's suppose that the name of your transformation is matches.ktr. In order to run the transformation from a terminal, follow these instructions:
- Open a terminal window, and go to the directory where Kettle is installed. If your system is Windows, and supposing that Kettle is installed in
C:\pdi-ce, type:C:\pdi-ce>Pan.bat /file=c:\pdi_labs\matches.ktr europe_201210.txt
- On Unix, Linux, and other types of systems, supposing that Kettle is installed under
/home/your_dir/pdi-ce/, type:/home/your_dir/pdi-ce/pan.sh /file=/home/your_dir/pdi_labs/matches.ktr europe_201210.txt
- If your transformation is in another folder, modify the command accordingly.
- While the transformation runs you will be able to see the progress in the terminal:
- Check the output file. The contents of
europe_201210.txtshould be at the end of thematches.txtfile.
What just happened?
You executed a transformation with Pan, the program that runs transformations from terminal windows. As a part of the command you specified the full path of the transformation file and provided the name of the file to process, which was the only argument expected by the transformation. As a result, you got the same output as if you had run the transformation from Spoon: a small file appended to the global file.
When you are designing transformations, you run them with Spoon; you don't use Pan. Pan is mainly used as part of batch processes, for example, processes that run every night in a scheduled fashion.
Note
Appendix B, Pan and Kitchen – Launching Transformations and Jobs from the Command Line gives you all the details about using Pan.
Have a go hero – finding out system information
Create a transformation that writes to the log the following information:
- System date
- Information about Kettle: version, build version, and build date
- Name of the transformation you're running
Run the transformation both from Spoon and from a terminal window.