CentOS7非图形界面下部署使用Kettle9

1、将Kettle程序目录上传到服务器上

Kettle9.0下载地址：

链接: https://pan.baidu.com/s/14jEUQVqncCvqrZbR637bfw 提取码: yzdg

2、解决WARNING

#######################################################################
WARNING:  no libwebkitgtk-1.0 detected, some features will be unavailable
    Consider installing the package with apt-get or yum.
    e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
#######################################################################

如果要解决这个WARNING安装下面的依赖包，不安装也行，不安装暂时没发现其他问题。

依赖包下载地址：

链接: https://pan.baidu.com/s/1aE0gqVYKzL_q2aniUUu_mQ 提取码: nw9b

安装依赖包

yum install -y webkitgtk-2.4.9-3.el7.nux.x86_64.rpm

3、配置JDK1.8

可以将JDK设为全局的环境变量，也可以单独配置

vi spoon.sh

export JAVA_HOME="/usr/local/jdk/"

 4、执行转换

/usr/local/pdi-ce-9.0.0.0-423/pan.sh -file:/usr/local/pdi-ce-9.0.0.0-423/9.ktr -level:Debug -logfile:/usr/local/pdi-ce-9.0.0.0-423/9.log

参数说明：

Options:
  -rep            = Repository name
  -user           = Repository username
  -trustuser      = Repository username
  -pass           = Repository password
  -trans          = The name of the transformation to launch
  -dir            = The directory (dont forget the leading /)
  -file           = The filename (Transformation in XML) to launch
  -level          = The logging level (Basic, Detailed, Debug, Rowlevel, Error, Minimal, Nothing)
  -logfile        = The logging file to write to
  -listdir        = List the directories in the repository
  -listtrans      = List the transformations in the specified directory
  -listrep        = List the available repositories
  -exprep         = Export all repository objects to one XML file
  -norep          = Do not log into the repository
  -safemode       = Run in safe mode: with extra checking enabled
  -version        = show the version, revision and build date
  -param          = Set a named parameter <NAME>=<VALUE>. For example -param:FOO=bar
  -listparam      = List information concerning the defined named parameters in the specified transformation.
  -metrics        = Gather metrics during execution
  -maxloglines    = The maximum number of log lines that are kept internally by Kettle. Set to 0 to keep all rows (default)
  -maxlogtimeout  = The maximum age (in minutes) of a log line while being kept internally by Kettle. Set to 0 to keep all rows indefinitely (default)

5、执行JOB

/usr/local/pdi-ce-9.0.0.0-423/kitchen.sh -file:/usr/local/pdi-ce-9.0.0.0-423/1.kjb -level:Debug -logfile:/usr/local/pdi-ce-9.0.0.0-423/1.log

参数说明：

Options:
  -rep            = Repository name
  -user           = Repository username
  -trustuser      = !Kitchen.ComdLine.RepUsername!
  -pass           = Repository password
  -job            = The name of the job to launch
  -dir            = The directory (dont forget the leading /)
  -file           = The filename (Job XML) to launch
  -level          = The logging level (Basic, Detailed, Debug, Rowlevel, Error, Minimal, Nothing)
  -logfile        = The logging file to write to
  -listdir        = List the directories in the repository
  -listjobs       = List the jobs in the specified directory
  -listrep        = List the available repositories
  -norep          = Do not log into the repository
  -version        = show the version, revision and build date
  -param          = Set a named parameter <NAME>=<VALUE>. For example -param:FILE=customers.csv
  -listparam      = List information concerning the defined parameters in the specified job.
  -export         = Exports all linked resources of the specified job. The argument is the name of a ZIP file.
  -custom         = Set a custom plugin specific option as a String value in the job using <NAME>=<Value>, for example: -custom:COLOR=Red
  -maxloglines    = The maximum number of log lines that are kept internally by Kettle. Set to 0 to keep all rows (default)
  -maxlogtimeout  = The maximum age (in minutes) of a log line while being kept internally by Kettle. Set to 0 to keep all rows indefinitely (default)