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=http2、windows：agent.bat -port=20300 -name=agent_001 -protocol=http