上次更新:2021-11-12

软件官网

https://www.hitachivantara.com/en-us/home.html

下载软件

https://sourceforge.net/projects/pentaho/files/Pentaho-9.2/client-tools/pdi-ce-9.2.0.0-290.zip

JDBC 驱动

https://help.hitachivantara.com/Documentation/Pentaho/9.2/Setup/JDBC_drivers_reference

精简组件

classes/kettle-lifecycle-listeners.xml
classes/kettle-registry-extensions.xml
data-integration\ADDITIONAL-FILES
data-integration\Data Integration.app
data-integration\Data Service JDBC Driver
data-integration\plugins\pentaho-big-data-plugin
data-integration\system\karaf

设置环境变量

set CURRENT_DIR=%~dp0
set KETTLE_DIR=%CURRENT_DIR%data-integration
set KETTLE_HOME=%CURRENT_DIR%data-config
set PENTAHO_JAVA_HOME=%CURRENT_DIR%java-1.8
set PENTAHO_DI_JAVA_OPTIONS=-Xms1024m -Xmx1536m -Dfile.encoding=UTF-8

移除 kettle-registry-extensions.xml 后不会再加载 karaf 组件

set PENTAHO_KARAF_ROOT=%CURRENT_DIR%data-cache
set PENTAHO_DI_JAVA_OPTIONS=%PENTAHO_DI_JAVA_OPTIONS% -Dpentaho.karaf.root.copy.dest.folder="%PENTAHO_KARAF_ROOT%"
set PENTAHO_DI_JAVA_OPTIONS=%PENTAHO_DI_JAVA_OPTIONS% -Dpentaho.karaf.root.transient="false"

启动 Spoon

"%KETTLE_DIR%\Spoon.bat"

启动 Spoon Debug

set SPOON_CONSOLE=1
set SPOON_OPTIONS=/level:Debug
"%KETTLE_DIR%\Spoon.bat" %SPOON_OPTIONS% >> "%CURRENT_DIR%SpoonDebug.txt" 2>&1

参考链接:

  Improving startup time of Pentaho Data Integration