如何在linux下运行kettle,linux 下安装并运行kettle 程序

1、建立用户

groupadd kettle

useradd -r -g kettle kettle

2、下载并解压安装包

unzip pdi-ce-7.1.0.0-12.zip

chown kettle.kettle data-integration -R

cd data-integration

chmod 755 *.sh

3、安装jdk

mkdir /usr/java

tar -zxvf jdk-8u181-linux-x64.tar -C /usr/java/

4、配置java环境变量

vi /etc/profile

export JAVA_HOME=/usr/java/jdk1.8.0_171

export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar

export PATH=$PATH:$JAVA_HOME/bin

5、安装mysql、oracle驱动

驱动有 ojdbc五、ojdbc六、mysql-connector-java

Orcale驱动下载地址：https://www.oracle.com/technetwork/cn/database/features/jdbc/index-093096-zhs.html

Mysql驱动下载地址：https://dev.mysql.com/downloads/connector/j/5.1.html

分别copy到如下目录中：

cp mysql-connector-java-5.1.36-bin.jar data-integration/lib/

cp ojdbc5.jar ojdbc6.jar data-integration /Data\ Service\ JDBC\ Driver/

####6、测试安装是否成功html

su - kettle

cd data-integration

./kitchen.sh #若出现帮助信息,证实安装成功

./spoon.sh & #启动

错误信息：

一、Could not load SWT library. Reasonsjava

java.lang.UnsatisfiedLinkError: Could not load SWT library. Reasons:

no swt-pi-gtk-4335 in java.library.path

no swt-pi-gtk in java.library.path

/home/proot/.swt/lib/linux/x86_64/libswt-pi-gtk-4335.so: libXtst.so.6: cannot open shared object file: No such file or directory

Can't load library: /home/proot/.swt/lib/linux/x86_64/libswt-pi-gtk.so

at org.eclipse.swt.internal.Library.loadLibrary(Unknown Source)

at org.eclipse.swt.internal.Library.loadLibrary(Unknown Source)

at org.eclipse.swt.internal.gtk.OS.(Unknown Source)

at org.eclipse.swt.internal.Converter.wcsToMbcs(Unknown Source)

at org.eclipse.swt.internal.Converter.wcsToMbcs(Unknown Source)

at org.eclipse.swt.widgets.Display.(Unknown Source)

at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:649)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)

说明没安装 SWT library ，须要安装 SWT 库mysql

yum -y install gtk2.i686 gtk2-engines.i686 PackageKit-gtk-module.i686 PackageKit-gtk-module.x86_64 libcanberra-gtk2.x86_64 libcanberra-gtk2.i686

二、No more handles [gtk_init_check()linux

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0

org.eclipse.swt.SWTError: No more handles [gtk_init_check() failed]

at org.eclipse.swt.SWT.error(Unknown Source)

at org.eclipse.swt.widgets.Display.createDisplay(Unknown Source)

at org.eclipse.swt.widgets.Display.create(Unknown Source)

at org.eclipse.swt.graphics.Device.(Unknown Source)

at org.eclipse.swt.widgets.Display.(Unknown Source)

at org.eclipse.swt.widgets.Display.(Unknown Source)

at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:649)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)

这个报错说明 centos 系统没有安装图形化界面web

yum -y install "GNOME Desktop"

7、配置资源库

已安装的数据库(本例为mysql)中sql

#建立用户

create user kettle;

#建立数据库

create database testdb;

#为用户受权资源库读写权限

grant all privileges on *.* to kettle@'%' IDENTIFIED by 'password';

flush privileges;

8、启动以后点击链接资源库

完成数据库信息填写，回到资源库信息界面，选择“正确的链接名”，并填写 ID和名称

点击“建立或更新”，弹出提示以下

数据库

点击“是”，会弹出设置管理员密码的窗口

centos

输入，此处使用password，肯定，弹出提示窗口以下

oracle

点击“是”，会生成新窗口，内容是SQL脚本

eclipse

点击“Execute”执行脚本，弹出SQL运行结果的窗口

点击“肯定”，关闭此窗口，而后点击“关闭”，关闭SQL提示的窗口

关闭SQL窗口以后，回到资源库信息的界面

击“肯定”，关闭资源库信息窗口，此时就到了链接资源库的界面

选择要链接的资源库“测试资源库”，输入管理员用户admin，密码password(刚刚设置的密码)，点击“OK”进行链接。

此时能够看一下左上角的信息

说明咱们此时链接了资源库“testdb1”