| Excerpt | ||
|---|---|---|
| ||
Execute Transformations in Batch Mode |
...
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 In the 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:
| Code Block |
|---|
cd Kettledata-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
...
This option runs the transformation defined in the XML file. (.ktr : Kettle Transformation)
...
Named parameters
| Code Block |
|---|
-param |
...
|
You can set the value of a named parameter. For , for example: " -param:MASTER_HOST=192.168.1.3" "-param:MASTER_PORT=8181"FOO=value
| Code Block |
|---|
-listparam
|
List the named parameters (their name, default value and description) that are defined in the specified transformation.
See also: [Named Parameters|EAI:Named Parameters].
Set the logging file
| Code Block |
|---|
-log=Logging Filename |
...
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
| Code Block |
|---|
D: cd \Kettledata-integration |
If Kettle data-integration was installed in the /product directory on a Unix system:
| Code Block |
|---|
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:
...