kettle

kettle是一个开源的ETL构建工具

kettle中包含：作业和转换两种类型，文件的后缀名称分别为：.kjb,.ktr

使用Java代码执行kettle作业主要代码为:

runKjb(String fileName,Map<String,String> params){
    try {
        KettleEnvironment.init();
        JobMeta jobMeta = new JobMeta(kettleScriptPath + fileName,null);
        Job job= new Job(null, jobMeta);

        if (null != params) {
            Iterator<Map.Entry<String, String>> iterator = params.entrySet().iterator();
            while(iterator.hasNext()){
                Map.Entry<String, String> entry = iterator.next();
                job.setVariable(entry.getKey(),entry.getValue());
            }
        }

        job.start();
        job.waitUntilFinished();
       
        return job.getResult();

    } catch (KettleException e) {
       
        return e.getMessage();
    }
}

runKtr(String fileName, Map<String,String> params){
    try {
        KettleEnvironment.init();