...

Pan is a program that can execute transformations designed by Spoon in XML in Spoon when stored as a KTR file or in aa repository. database repository.

Usually transformations are scheduled in batch mode to be run
automatically at regular intervalsrun at regular intervals (via the PDI Enterprise Repository scheduler, or 3rd-party tools like Cron or Windows Task Scheduler).

Installation

The first step is the installation of Sun Microsystems Oracle Java Runtime Environment version 1.4
or higher. You can download a JRE for free at http://www.java.com/.7 or higher.

After this, you can simply unzip the zip-file: Kettle-3.0. PDI software: pdi-ce-VERSION.zip in a directory of your choice.
In the Kettle data-integration directory where you unzipped the file, you will find a number of files.

Under When using Unix-like environments (Solaris, Linux, OSX, ...) you will need to make the shell
scripts shell scripts executable. Execute these commands to make all shell scripts in the Kettle directory
executabledirectory executable:

cd Kettle
data-integration
chmod +x *.sh

Launching Pan

...

Pan can be run on any platform that has a version of the Java Runtime Environment version 1.5 7 or higher.

Command line options

...

If you have set environment variables KETTLE_REPOSITORY, KETTLE_USER, KETTLE_PASSWORD, you can prevent Pan from logging into the repository. For example instance, if you want to launch a transformation from an XML file.

...

Please make sure that you are positioned in the Kettle data-integration directory before running the samples
below. If you put these scripts into a batch file or shell script, simply do a change directory to
the installation directory:

If Kettle data-integration was installed on windows on the D:\ drive

D:

cd \Kettledata-integration

If Kettle data-integration was installed in the /product directory on a Unix system:

cd /product/Kettledata-integration/

Run a transformation from file

...

The best way to go at it is to test the command first at the dos DOS prompt.
Then  Then you can use the windows scheduler Windows Task Scheduler to launch this command.
Windows  Windows versions since Windows 2000 have a GUI for doing this accessible through the
control panelthe Control Panel. However it's also possible to use the command line to do this:

...