kettle脚本模板

来源：互联网发布：塞班软件下载5233 编辑：程序博客网时间：2024/06/05 14:22

概述：经常使用kettle进行etl脚本开发，总结命令行模式启动脚本如下：

1、执行Ktr脚本模版：

echo offclsset path=%path%;D:\data-integrationrem ------------------------------------------------------------------set ktr_file=脚本名称.ktrtitle %ktr_file% [%date% %time%]rem ------------------------------------------------------------------if not exist logs md logsset level="/level:Detailed"set file="/file:%cd%\%ktr_file%"set log="/logfile:%cd%\logs\%ktr_file%.%date:~0,4%%date:~5,2%%date:~8,2%.log"set param="/param:参数名称=参数值"call pan.bat %level% %file% %log%pause

2、执行Ktr脚本模版-资源库

echo offclsset path=%path%;D:\data-integrationrem ------------------------------------------------------------------set ktr_file=脚本名称title %ktr_file% [%date% %time%]rem ------------------------------------------------------------------if not exist logs md logsset level="/level:Detailed"set file="/trans:%ktr_file%" "/dir:目录"set log="/logfile:%cd%\logs\%ktr_file%.%date:~0,4%%date:~5,2%%date:~8,2%.log"set param="/param:参数名称=参数值"set r="/rep:etl_repository" "/user:admin" "/pass:admin"call pan.bat %r% %level% %file% %log% pause

3、执行Job脚本模版

echo offclsset path=%path%;D:\data-integrationrem ------------------------------------------------------------------set job_file=脚本名称.kjbtitle %job_file% [%date% %time%]rem ------------------------------------------------------------------if not exist logs md logsset level="/level:Detailed"set file="/file:%cd%\%job_file%"set log="/logfile:%cd%\logs\%job_file%.%date:~0,4%%date:~5,2%%date:~8,2%.log"set param="/param:参数名称=参数值"call Kitchen.bat %level% %file% %log% pause

4、执行Job脚本模版-资源库

@echo offclsrem ------------------------------------------------------------------set path=%path%;E:\dev\data-integration_4.1.0set job_file=脚本名称title %job_file% [%date% %time%]rem ------------------------------------------------------------------if not exist logs md logsif not exist output md outputset level="/level:Detailed"set file="/job:%job_file%"set log="/logfile:%cd%\logs\%job_file%.log"set param="/param:bsoft.param.ksrq=%ksrq%"set r="/rep:etl_res" "/user:admin" "/pass:admin"call Kitchen.bat %r% %level% %file% %log%

0 0