You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2021/02/04 08:16:00 UTC

[GitHub] [incubator-dolphinscheduler] BoYiZhang opened a new issue #4676: [Question] How to use kettle ???

BoYiZhang opened a new issue #4676:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4676


   
   
   
   分布式调度与kettle的整合方案
   一、前期准备：
   	1、worker机器上必须都安装单机的kettle，目的支持kettle的pan、kitchen命令
   	2、如果连接oracle、mysql，必须将对应的驱动放到lib下面
   
   二、调度与kettle的整合
   	1、调度的shell组件 或 将命令放到shell脚本中都可以，考虑后续ktr文件上传太麻烦，将采用第二种方法
   		例子：/opt/kettle/data-integration/pan.sh -file=/home/etl/awh_test_start_end_param.ktr -param:startId=$1  -param:endId=$2
   	2、调用资源库中的转换
   	     避免安装linux的图形化，又能调用资源库中的转换
   	     方法：在windows机器上找到kettle生成的repositories.xml文件，一般在C:\Users\管理员用户名\.kettle
                  将该文件拷贝到linux安装kettle的linux的机器上，目录/root/.kettle/， 这样就可以使用windows机器上开发，linux上运行
   
   		例子：/opt/kettle/data-integration/pan.sh -rep=资源库名称 -user=用户名 -pass=密码 -dir=/study -trans=awh_testa -param:startId=1  -param:endId=9
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-dolphinscheduler] BoYiZhang closed issue #4676: [Question] How to use kettle ???

Posted by GitBox <gi...@apache.org>.
BoYiZhang closed issue #4676:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4676


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-dolphinscheduler] BoYiZhang closed issue #4676: [Question] How to use kettle ???

Posted by GitBox <gi...@apache.org>.
BoYiZhang closed issue #4676:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4676


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org