此方案需要在资源库中进行,在本地库测试时需在步骤“目标表结构创建”中替换以下代码:
//本地连接
org.pentaho.di.core.database.DatabaseMeta dbmeta = getTransMeta().findDatabase("target");
//资源库连接
/**
org.pentaho.di.core.database.DatabaseMeta dbmeta = null;
java.util.List list = getTrans().getRepository().readDatabases();
if(list != null && !list.isEmpty())
{
for(int i=0;i<list.size();i++)
{
dbmeta = (org.pentaho.di.core.database.DatabaseMeta)list.get(i);
if("target".equalsIgnoreCase(dbmeta.getName()))
{
break;
}
}
}
*/