Pan Options and Syntax

Pan runs transformations, either from a PDI repository (database or enterprise) or a local file. The syntax for the shell script and batch file are shown below. All Pan options are the same for both.

Note: Windows systems use syntax with the forward slash (“/”) and colon (“:”). If spaces are present in the option values, use single quotes (“) and double quotes (“”) to keep spaces together, for example, "-param:MASTER_HOST=192.168.1.3" "-param:MASTER_PORT=8181"

pan.sh -option=value arg1 arg2

pan.bat /option: value arg1 arg2

For example:

sh pan.sh -rep=initech_pdi_repo -user=pgibbons -pass=lumburgh -trans=TPS_reports_2011

pan.bat /rep:initech_pdi_repo /user:pgibbons /pass:lumburgh /trans:TPS_reports_2011

Switch	Purpose
rep	Enterprise repository name.
user	Repository username.
pass	Repository password.
trans	The name of the transformation you want to launch.
dir	The repository directory that contains the transformation, including the leading slash.
file	If you are calling a local KTR file, this is the filename, including the path if it is not located in the local directory.
level	Set the logging level: Basic, Detailed, Debug, Rowlevel, Error, Nothing.
logfile	The logging file path to write to.
listdir	List the directories in the specified repository.
listtrans	List the transformations in the specified repository directory.
listrep	List the available repositories.
exprep	Export all repository objects to one XML file.
norep	Prevent Pan from logging into a repository. If you have set the KETTLE_REPOSITORY, KETTLE_USER, and KETTLE_PASSWORD environment variables, then this option will enable you to prevent Pan from logging into the specified repository, assuming you would like to execute a local KTR file instead.
safemode	Run in safe mode, which enables extra checking.
version	Show the version, revision, and build date.
param	Set a named parameter in a name=value format. For example: -param:Foo=bar
listparam	List information about the defined named parameters in the specified transformation.
metrics	Gather metrics during execution.
maxloglines	Set the maximum number of log lines that are kept internally by PDI. Set to 0 to keep all rows (default).
maxlogtimeout	Set the maximum age (in minutes) of a log line while being kept internally by PDI. Set to 0 to keep all rows indefinitely (default).