ODI中新增插件(OpenTools)介绍 - 数据库编程

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">vciB0aGUgbWVzc2FnZSBib3ggdXNlZCBpbiB0aGlzIGV4YW1wbGUqLwoKaW1wb3J0IG9yYWNsZS5vZGkuc2RrLm9wZW50b29scy5JT3BlblRvb2w7IC8qIEFsbCBPcGVuIFRvb2wgY2xhc3NlcyBuZWVkIHRoZXNlIHRocmVlIGNsYXNzZXMgKi8KaW1wb3J0IG9yYWNsZS5vZGkuc2RrLm9wZW50b29scy5JT3BlblRvb2xQYXJhbWV0ZXI7CmltcG9ydCBvcmFjbGUub2RpLnNkay5vcGVudG9vbHMuT3BlblRvb2xBYnN0cmFjdDsKaW1wb3J0IG9yYWNsZS5vZGkuc2RrLm9wZW50b29scy5PcGVuVG9vbEV4ZWN1dGlvbkV4Y2VwdGlvbjsKaW1wb3J0IG9yYWNsZS5vZGkuc2RrLm9wZW50b29scy5PcGVuVG9vbFBhcmFtZXRlcjsgLyogVGhlIGNsYXNzIHVzZWQgZm9yIHBhcmFtZXRlcnMgKi8KCi8qKgogKiBAYXV0aG9yIEFkbWluaXN0cmF0b3IKICoKICovCnB1YmxpYyBjbGFzcyBTaW1wbGVNZXNzYWdlQm94IGV4dGVuZHMgT3BlblRvb2xBYnN0cmFjdCB7CiBwcml2YXRlIHN0YXRpYyBmaW5hbCBJT3BlblRvb2xQYXJhbWV0ZXJbXSBtUGFyYW1ldGVycyA9IG5ldyBJT3BlblRvb2xQYXJhbWV0ZXJbXSB7CiAgIG5ldyBPcGVuVG9vbFBhcmFtZXRlcigmcXVvdDstVEVYVCZxdW90OywgJnF1b3Q7TWVzc2FnZSB0ZXh0JnF1b3Q7LAogICAgICZxdW90O1RleHQgdG8gc2hvdyBpbiB0aGUgbWVzc2FnZWJv

eChNYW5kYXRvcnkpLiZxdW90OywgdHJ1ZSksCiAgIG5ldyBPcGVuVG9vbFBhcmFtZXRlcigmcXVvdDstVElUTEUmcXVvdDssICZxdW90O01lc3NhZ2Vib3ggdGl0bGUmcXVvdDssCiAgICAgJnF1b3Q7VGl0bGUgb2YgdGhlIG1lc3NhZ2Vib3guJnF1b3Q7LCBmYWxzZSkgfTsKCiBwdWJsaWMgSU9wZW5Ub29sUGFyYW1ldGVyW10gZ2V0UGFyYW1ldGVycygpIHsKICByZXR1cm4gbVBhcmFtZXRlcnM7CiB9CgogcHVibGljIFN0cmluZyBnZXREZXNjcmlwdGlvbigpIHsKICByZXR1cm4gJnF1b3Q7ta+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_MESS

ODI中新增插件(OpenTools)介绍(一)