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"
Stellungnahme:Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn