Pentaho Repository

Pentaho Repository是Pentaho BI平台的核心组件之一，它是一个中央存储库，用于存储和管理Pentaho BI平台的所有元数据和配置信息。这些元数据包括报表、分析、数据集、数据源、转换等。Pentaho Repository还提供了一组API，可以用于访问和管理这些元数据。Pentaho Repository是一个基于数据库的存储库，支持多种数据库，如MySQL、PostgreSQL、Oracle等。在Pentaho BI平台中，Pentaho Repository是一个非常重要的组件，它为用户提供了一个集中式的管理和维护BI元数据的方式。

相关问题

kettle的java工具类

以下是一个使用Java编写的Kettle工具类示例：

import org.pentaho.di.core.KettleEnvironment;
import org.pentaho.di.core.database.DatabaseMeta;
import org.pentaho.di.core.exception.KettleDatabaseException;
import org.pentaho.di.core.exception.KettleException;
import org.pentaho.di.core.plugins.PluginRegistry;
import org.pentaho.di.job.Job;
import org.pentaho.di.job.JobMeta;
import org.pentaho.di.repository.Repository;
import org.pentaho.di.repository.RepositoryDirectoryInterface;
import org.pentaho.di.repository.RepositoryMeta;
import org.pentaho.di.repository.kdr.KettleDatabaseRepository;
import org.pentaho.di.repository.kdr.KettleDatabaseRepositoryMeta;
import org.pentaho.di.trans.Trans;
import org.pentaho.di.trans.TransMeta;

public class KettleUtil {

    public static void runTransformation(String transformationPath) throws KettleException {
        KettleEnvironment.init();
        TransMeta transMeta = new TransMeta(transformationPath);
        Trans trans = new Trans(transMeta);
        trans.execute(null);
        trans.waitUntilFinished();
        if (trans.getErrors() > 0) {
            throw new KettleException("Transformation failed!");
        }
    }

    public static void runJob(String jobPath) throws KettleException {
        KettleEnvironment.init();
        JobMeta jobMeta = new JobMeta(jobPath, null);
        Job job = new Job(null, jobMeta);
        job.start();
        job.waitUntilFinished();
        if (job.getErrors() > 0) {
            throw new KettleException("Job failed!");
        }
    }

    public static Repository connectToRepository(String repositoryName, String host, String port, String database,
                                                 String username, String password) throws KettleException {
        KettleEnvironment.init();
        Repository repository = new KettleDatabaseRepository();
        DatabaseMeta databaseMeta = new DatabaseMeta(repositoryName, "MYSQL", "Native", host, database, port, username, password);
        repository.init(databaseMeta);

        if (repository.connect(null)) {
            return repository;
        } else {
            throw new KettleException("Failed to connect to repository!");
        }
    }

    public static void runTransformationFromRepository(Repository repository, String transformationName, String directoryPath) throws KettleException {
        RepositoryDirectoryInterface directory = repository.findDirectory(directoryPath);
        TransMeta transMeta = repository.loadTransformation(transformationName, directory, null, true, null);
        Trans trans = new Trans(transMeta);
        trans.execute(null);
        trans.waitUntilFinished();
        if (trans.getErrors() > 0) {
            throw new KettleException("Transformation failed!");
        }
    }

    public static void runJobFromRepository(Repository repository, String jobName, String directoryPath) throws KettleException {
        RepositoryDirectoryInterface directory = repository.findDirectory(directoryPath);
        JobMeta jobMeta = repository.loadJob(jobName, directory, null, null);
        Job job = new Job(repository, jobMeta);
        job.start();
        job.waitUntilFinished();
        if (job.getErrors() > 0) {
            throw new KettleException("Job failed!");
        }
    }
}

请注意，此示例仅提供了一些基本方法，以运行转换和作业。你需要根据自己的需求进行适当的修改和扩展。

java 调用kettle job 传参_java调用kettle向job（任务）和transformation（转换）传递参数实例...

可以通过Java程序调用Kettle的API来向Job和Transformation传递参数。以下是一个示例代码：

import org.pentaho.di.core.KettleEnvironment;
import org.pentaho.di.core.exception.KettleException;
import org.pentaho.di.core.variables.Variables;
import org.pentaho.di.repository.Repository;
import org.pentaho.di.repository.RepositoryDirectoryInterface;
import org.pentaho.di.repository.kdr.KettleDatabaseRepository;
import org.pentaho.di.trans.Trans;
import org.pentaho.di.trans.TransMeta;
import org.pentaho.di.trans.TransParameterCodec;

import java.util.HashMap;
import java.util.Map;

public class KettleJobCaller {

    public static void main(String[] args) throws KettleException {
        KettleEnvironment.init();

        String repositoryName = "MyRepository";
        String username = "admin";
        String password = "password";
        String jobName = "MyJob";
        String transformationName = "MyTransformation";

        String[] parameters = new String[]{"param1=value1", "param2=value2"};

        Repository repository = new KettleDatabaseRepository();
        repository.init(repositoryName, username, password);
        RepositoryDirectoryInterface directory = repository.loadRepositoryDirectoryTree().findDirectory("/my/directory");

        Variables variables = new Variables();
        variables.setParameters(parameters);

        TransMeta transMeta = repository.loadTransformation(transformationName, directory, variables, null);
        Trans trans = new Trans(transMeta);
        trans.execute(null);

        String[] encodedParameters = TransParameterCodec.encodeParams(parameters);
        Map<String, String> paramMap = new HashMap<>();
        for (String encodedParameter : encodedParameters) {
            String[] split = encodedParameter.split("=");
            paramMap.put(split[0], split[1]);
        }

        JobMeta jobMeta = repository.loadJob(jobName, directory, variables, null);
        Job job = new Job(repository, jobMeta, variables);
        job.setVariables(variables);
        job.setParams(paramMap);
        job.start();
        job.waitUntilFinished();
    }
}

在上面的示例代码中，我们首先初始化Kettle的环境，然后指定仓库名称、用户名、密码、Job名称和Transformation名称。接下来，我们将要传递的参数存储在一个字符串数组中，并将它们传递给Transformation和Job。在传递参数时，我们需要使用变量来存储它们。

最后，我们使用Kettle的API来加载Transformation和Job，并将参数传递给它们。注意，我们需要使用TransParameterCodec来编码和解码参数。

这就是如何使用Java调用Kettle Job并传递参数的示例代码。