Pentaho Kettle 使用笔记
上次更新: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
参考链接:
最近回复