Import org. pentaho. di. core. KettleEnvironment;
Import org. pentaho. di. core. database. DatabaseMeta;
Import org. pentaho. di. core. exception. KettleException;
Import org. pentaho. di. repository. Repository;
Import org. pentaho. di. repository. RepositoryDirectoryInterface;
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;
/**
* <P> Title: java calls the conversion in kettle4.2 Database Type database </p>
* <P> Description: </p>
* <P> Copyright: Copyright () 2012 </p>
* @ Author pilot
* @ Version
*/
Public class ExecRepositoryTrans {
Private static String transName = "Trans ";
Public static void main (String [] args ){
Try {
KettleEnvironment. init ();
KettleDatabaseRepository repository = new KettleDatabaseRepository ();
DatabaseMeta databaseMeta = new DatabaseMeta ("repository", "MSSQL", "Native", "192.169.0.146", "repository", "1433", "sa", "sa ");
KettleDatabaseRepositoryMeta kettleDatabaseMeta = new KettleDatabaseRepositoryMeta ("repository", "ERP", "Transformation description", databaseMeta );
Repository. init (kettleDatabaseMeta );
Repository. connect ("admin", "admin ");
RepositoryDirectoryInterface directory = repository. loadRepositoryDirectoryTree ();
TransMeta transformationMeta = (Repository) repository). loadTransformation (transName, directory, null, true, null );
Trans trans = new Trans (transformationMeta );
// Trans. setParameterValue (parameterName, parameterValue );
Trans.exe cute (null );
Trans. waitUntilFinished ();
If (trans. getErrors ()> 0 ){
System. out. println ("Error running transformation .");
} Else {
System. out. println ("Transformation run successfully .");
}
} Catch (KettleException e ){
E. printStackTrace (); www.2cto.com
}
}
}