1、添加ODI驱动在ODI11G中需要将数据jdbc驱动拷贝到以下两个位置：$HOME（一般在windows的系统文件夹，如：C:\Users\Administrator\AppData\Roaming\odi\oracledi\）/.odi/oracledi/userlib-----用于statio的数据集成；ODI_HOME/oracledi/agent/drivers/----
1、添加ODI驱动
在ODI11G中需要将数据jdbc驱动拷贝到以下两个位置：
$HOME（一般在windows的系统文件夹，如：C:\Users\Administrator\AppData\Roaming\odi\oracledi\）/.odi/oracledi/userlib-----用于statio的数据集成；
ODI_HOME/oracledi/agent/drivers/----用于代理的数据集成；
王珂
2、添加自定义插件
首先将待添加的open tools jar包放到上述ODI驱动的位置下。
打开ODIstadio之后，在odi菜单项，选择添加或删除open tools
添加完成后：
附相关代码如下：
/**
*
*/
package com.dataonv.OpenTools;
import javax.swing.JOptionPane; /* Needed fZ喎?http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vciB0aGUgbWVzc2FnZSBib3ggdXNlZCBpbiB0aGlzIGV4YW1wbGUqLwoKaW1wb3J0IG9yYWNsZS5vZGkuc2RrLm9wZW50b29scy5JT3BlblRvb2w7IC8qIEFsbCBPcGVuIFRvb2wgY2xhc3NlcyBuZWVkIHRoZXNlIHRocmVlIGNsYXNzZXMgKi8KaW1wb3J0IG9yYWNsZS5vZGkuc2RrLm9wZW50b29scy5JT3BlblRvb2xQYXJhbWV0ZXI7CmltcG9ydCBvcmFjbGUub2RpLnNkay5vcGVudG9vbHMuT3BlblRvb2xBYnN0cmFjdDsKaW1wb3J0IG9yYWNsZS5vZGkuc2RrLm9wZW50b29scy5PcGVuVG9vbEV4ZWN1dGlvbkV4Y2VwdGlvbjsKaW1wb3J0IG9yYWNsZS5vZGkuc2RrLm9wZW50b29scy5PcGVuVG9vbFBhcmFtZXRlcjsgLyogVGhlIGNsYXNzIHVzZWQgZm9yIHBhcmFtZXRlcnMgKi8KCi8qKgogKiBAYXV0aG9yIEFkbWluaXN0cmF0b3IKICoKICovCnB1YmxpYyBjbGFzcyBTaW1wbGVNZXNzYWdlQm94IGV4dGVuZHMgT3BlblRvb2xBYnN0cmFjdCB7CiBwcml2YXRlIHN0YXRpYyBmaW5hbCBJT3BlblRvb2xQYXJhbWV0ZXJbXSBtUGFyYW1ldGVycyA9IG5ldyBJT3BlblRvb2xQYXJhbWV0ZXJbXSB7CiAgIG5ldyBPcGVuVG9vbFBhcmFtZXRlcigmcXVvdDstVEVYVCZxdW90OywgJnF1b3Q7TWVzc2FnZSB0ZXh0JnF1b3Q7LAogICAgICZxdW90O1RleHQgdG8gc2hvdyBpbiB0aGUgbWVzc2FnZWJveChNYW5kYXRvcnkpLiZxdW90OywgdHJ1ZSksCiAgIG5ldyBPcGVuVG9vbFBhcmFtZXRlcigmcXVvdDstVElUTEUmcXVvdDssICZxdW90O01lc3NhZ2Vib3ggdGl0bGUmcXVvdDssCiAgICAgJnF1b3Q7VGl0bGUgb2YgdGhlIG1lc3NhZ2Vib3guJnF1b3Q7LCBmYWxzZSkgfTsKCiBwdWJsaWMgSU9wZW5Ub29sUGFyYW1ldGVyW10gZ2V0UGFyYW1ldGVycygpIHsKICByZXR1cm4gbVBhcmFtZXRlcnM7CiB9CgogcHVibGljIFN0cmluZyBnZXREZXNjcmlwdGlvbigpIHsKICByZXR1cm4gJnF1b3Q7ta+z9rbUu7C/8iZxdW90OzsKIH0KCiBwdWJsaWMgU3RyaW5nIGdldFZlcnNpb24oKSB7CiAgcmV0dXJuICZxdW90O3YxLjAmcXVvdDs7CiB9CgogcHVibGljIFN0cmluZyBnZXRQcm92aWRlcigpIHsKICByZXR1cm4gJnF1b3Q7uavLvsP7s8YuJnF1b3Q7OwogfQoKIHB1YmxpYyBTdHJpbmcgZ2V0U3ludGF4KCkgewogIHJldHVybiAmcXVvdDtTaW1wbGVNZXNzYWdlQm94IFwmcXVvdDstVEVYVD0mbHQ7dGV4dCBtZXNzYWdlJmd0O1wmcXVvdDsgXCZxdW90Oy1USVRMRT0mbHQ7d2luZG93IHRpdGxlJmd0O1wmcXVvdDsmcXVvdDs7CiB9CgogcHVibGljIFN0cmluZyBnZXRJY29uKGludCBwSWNvblR5cGUpIHsKICBzd2l0Y2ggKHBJY29uVHlwZSkgewogIGNhc2UgSU9wZW5Ub29sLlNNQUxMX0lDT046CiAgIHJldHVybiAmcXVvdDsvY29tL2RhdGFvbnYvT3BlblRvb2xzL2hhaXNodTE2LmdpZiZxdW90OzsKICBjYXNlIElPcGVuVG9vbC5CSUdfSUNPTjoKICAgcmV0dXJuICZxdW90Oy9jb20vZGF0YW9udi9PcGVuVG9vbHMvaGFpc2h1MzIuZ2lmJnF1b3Q7OwogIGRlZmF1bHQ6CiAgIHJldHVybiAmcXVvdDsmcXVvdDs7CiAgfQogfQoKIHB1YmxpYyB2b2lkIGV4ZWN1dGUoKSB0aHJvd3MgT3BlblRvb2xFeGVjdXRpb25FeGNlcHRpb24gewogIHRyeSB7CiAgIGlmIChnZXRQYXJhbWV0ZXJWYWx1ZSgmcXVvdDstVElUTEUmcXVvdDspID09IG51bGwKICAgICA="| getParameterValue("-TITLE").equals("")) /*
* title was not
* filled in by
* user
*/
{
JOptionPane.showMessageDialog(null,
(String) getParameterValue("-TEXT"),
(String) "Message", JOptionPane.INFORMATION_MESSAGE);
} else {
JOptionPane.showMessageDialog(null,
(String) getParameterValue("-TEXT"),
(String) getParameterValue("-TITLE"),
JOptionPane.INFORMATION_MESSAGE);
}
}
/* Traps any exception and throw them as OpenToolExecutionException */
catch (IllegalArgumentException e) {
throw new OpenToolExecutionException(e);
}
}
}
代理启动命令：
1、linux：./agent.sh -PORT=20300 -NAME=agent_001 -PROTOCOL=http
2、windows：agent.bat "-PORT=20300" "-NAME=agent_001" "-PROTOCOL=http"
