Pentaho Data Integration (iii) Pan

Website Link: http://wiki.pentaho.com/display/EAI/Pan+User+Documentation

Pan

A Pan is a program that can perform a transformation that is edited using spoon.

The decompression of PDI Software.zip has been pan.bat

command line using pan to execute transformation

The official website mainly introduces the commands under the Linux platform, I mainly introduce the commands under the Windows platform

Options option

Format/option: "Value"

Parameters parameters

Format "-param:name=value"

Repository Warehouse Select a Repository

Format/rep:repository Name

Set Repository user name

Format/user:username

Set Repository user password

Format/pass:password

Choose Repository's transformation

Format/trans:transformation Name

Set the directory for repository

Format/dir:directory

Execute transformation from File

Pan.bat/file: "/prd/customer dimension.ktr"/level:minimal

Execute transformation from Repository

Pan.bat/rep:"Production Repository" /trans:"update Customer Dimension" /user:matt /pass:somepassword123 "-param:database=database name"

Pentaho Data Integration (iii) Pan