发表于 2009-1-5 19:48
| 
鑷富鐩戞帶宸ュ叿缁存姢鑱旈偊鏁版嵁
鍙戝竷: 2008-7-01 22:12 | 浣滆: admin | 鏌ョ湅: 6娆
鑷富鐩戞帶宸ュ叿缁存姢鑱旈偊鏁版嵁
鑾峰彇鍋ュ悍鐨勮仈閭︽暟鎹簱绯荤粺鐨勫鏂 绾у埆: 鍒濈骇 Farnaz Erfan涓撹亴杞欢宸ョ▼甯, IBM2005 骞 6 鏈 23 鏃ヤ簡瑙 IBM WebSphere Information Integrator 鐨勮嚜涓诲仴搴风洃鎺у姛鑳藉浣曞府鍔..
鑾峰彇鍋ュ悍鐨勮仈閭︽暟鎹簱绯荤粺鐨勫鏂
绾у埆: 鍒濈骇
Farnaz Erfan
涓撹亴杞欢宸ョ▼甯, IBM
2005 骞 6 鏈 23 鏃
浜嗚В IBM® WebSphere® Information Integrator 鐨勮嚜涓诲仴搴风洃鎺у姛鑳藉浣曞府鍔╂偍瑙ｅ喅鍦ㄨ仈閭︽暟鎹簱鐜涓淮鎶よ涔変竴鑷存ф椂闈复鐨勫洶闅俱傛湰鏂囬鍏堜粙缁嶈仈閭︽蹇碉紝鎺ヤ笅鏉ユ弿杩颁簡鍋ュ悍鐩戞帶鍔熻兘鐨勫伐浣滃師鐞嗐
绠浠
褰撲粖鐨勫簲鐢ㄧ▼搴忛渶瑕侀棰戜笌璁稿涓嶅悓婧愬拰涓嶅悓鏍煎紡鐨勪俊鎭浉缁撳悎銆傚洜姝わ紝搴旂敤绋嬪簭寮鍙戜汉鍛樺線寰闇瑕佽皟鐢ㄥぇ閲忎笉鍚 API 鍜屽崗璁潵妫绱㈡瘡涓簮涓殑淇℃伅锛岀劧鍚庡皢杩欎簺淇℃伅鍚堝苟鍒板簲鐢ㄧ▼搴忎腑銆
WebSphere Information Integrator 閫氳繃鎻愪緵涓涓埌寮傛瀯鏁版嵁婧愮殑瀹炴椂鐨勫熀浜 SQL 鐨勬帴鍙ｏ紝鍔犻熶簡杩欑被鍦烘櫙鐨勫簲鐢ㄧ▼搴忛儴缃诧紝寮傛瀯鏁版嵁婧愬寘鎷叧绯荤郴缁燂紙濡 DB2® Universal Database™ (DB2 UDB)銆丱racle 鍜 Sybase锛夊拰闈炲叧绯绘暟鎹簮锛堝鏂囨湰鏂囨。鍜岄潪缁撴瀯鍖栨暟鎹級锛屼互鍙婃柊鍏存妧鏈紙濡傞氳繃 Web Services 璁块棶鐨 XML 瀛樺偍搴撳拰鏁版嵁锛夈侷nformation Integrator 閫氳繃閫忔槑鍦扮鐞嗗叧绯诲拰闈炲叧绯绘暟鎹苟灏嗗叾涓璧峰紩鍏ュ崟涓櫄鎷熶綅缃紝鏉ユ弧瓒冲揩閫熻闂畬鍏ㄤ笉鍚岀殑鏁版嵁鐨勫競鍦洪渶姹傘傚浘 1 璇︾粏璇存槑浜 WebSphere Information Integrator 鐜锛
鍥 1. WebSphere Information Integrator 鎻愪緵鍗曚釜 SQL API 鏉ヨ闂笉鍚岀殑鍒嗗竷寮忔暟鎹
WebSphere Information Integrator 閫氳繃鍦ㄥ叾鑷韩鐨勭紪鐩腑瀛樺偍鑱旈偊鏁版嵁婧愮殑鍏冩暟鎹紝浠庤屽湪 DB2 UDB 鏁版嵁搴撳紩鎿庣殑涓婁笅鏂囦腑鏋勫缓鏁版嵁搴撹仈閭︺傚洜涓鸿仈閭︿腑鐨勬瘡涓暟鎹簮涓鐩村湪鑷富鎿嶄綔锛屾墍浠ョ淮鎸佽仈閭︽暟鎹簱涓庡畠鎵鑱旈偊鐨勬簮涔嬮棿鐨勪竴鑷存ф槸涓涓浉褰撳ぇ鐨勬寫鎴樸傛ā寮忓畾涔夊彉鏇淬佹湇鍔″櫒鍜岀綉缁滄晠闅滐紝浠ュ強瀵嗙爜杩囨湡绛変簨浠堕殢鏃跺彲鑳藉彂鐢熴傝繖浜涗簨浠朵腑鐨勬瘡涓绉嶉兘鍙兘浣挎暟鎹簮鍙樺緱涓嶅彲璁块棶鎴栦娇鍏跺仛杩囩殑缂栫洰涓嶅啀鏈夋晥锛岄氳繃鑱旈偊鏁版嵁搴撹闂繖浜涙暟鎹簮鐨勫簲鐢ㄧ▼搴忓彲鑳藉洜姝よ屼腑鏂
鍥犳锛屾娴嬫绫讳笉涓鑷存у拰鑷垜绠＄悊闆嗘垚鐜鐨勮嚜涓诲姛鑳藉彲浠ラ檷浣庢暟鎹鐞嗙殑澶嶆潅鎬с備笌鍏佽鐪熸铏氭嫙鍖栫殑鐜鐩哥粨鍚堬紝Information Integrator 鐨勮嚜鍔ㄥ寲鍙互浜や粯鑳藉鍒╃敤浜哄憳銆佽繃绋嬪拰淇℃伅涔嬮棿鐨勮祫婧愮殑闅忛渶搴斿彉瑙ｅ喅鏂规銆
鏈枃棣栧厛璇存槑浜嗚仈閭︽暟鎹簱绯荤粺鐨勫熀鏈師鐞嗭紝缁欏嚭浜嗗睍绀鸿绯荤粺鐨勫鏍锋у拰鍙墿灞曟х殑鍦烘櫙銆傜劧鍚庯紝鎴戜滑鏉ョ湅涓涓嬭仈閭︽暟鎹簱鍜屽畠鎵鑱旈偊鐨勬簮涔嬮棿鍑虹幇鐨勫疄鏃朵笉涓鑷存с傛渶鍚庢垜浠潵鐪嬩竴鐪嬭仈閭﹀仴搴风洃鎺э紝鍗冲湪 WebSphere Information Integrator V8.2 涓彁渚涚殑鏂扮殑鑷富鍔熻兘锛屽畠鏄湪 DB2 UDB Health Monitoring 缁勪欢涓疄鐜扮殑銆傝鍔熻兘璀﹀憡绯荤粺绠＄悊鍛樿仈閭︽暟鎹簱缂栫洰鍜岃仈閭︽暟鎹簮涔嬮棿瀛樺湪涓嶄竴鑷存э紝鎻愬嚭閲囧彇绾犻敊鎺柦鐨勫缓璁紝骞跺畾鏈熷彂閫佹晠闅滄帓闄ら氱煡銆
鑱旈偊绯荤粺鐨勫熀鏈師鐞
WebSphere Information Integrator 鑱旈偊绯荤粺鍖呮嫭浠ヤ笅缁勪欢锛
DB2 UDB 寮曟搸
鏃犻渶绉诲姩鍒颁腑蹇冧綅缃嵆鍙闂垎甯冨紡鏁版嵁鐨 Information Integrator 瀹炰緥
涓涓垨澶氫釜鏁版嵁婧
瀹㈡埛鏈猴紙鐢ㄦ埛鍜屽簲鐢ㄧ▼搴忥級
鑱旈偊绯荤粺鐨勫垱寤烘柟寮忔槸锛屽湪 DB2 UDB 寮曟搸涓婂畨瑁 Information Integrator锛岀劧鍚庡鍏惰繘琛岄厤缃互娉ㄥ唽涓涓垨澶氫釜寮傛瀯鏁版嵁婧愩傝仈閭︽暟鎹簱绯荤粺鐨勭敤鎴峰彲浠ュ瀛樺偍鍦ㄨ仈閭︾郴缁熶腑浠绘剰浣嶇疆鐨勬暟鎹繘琛屽垎甯冨紡鏌ヨ锛屼笉绠¤嚜宸辩殑浣嶇疆鍦ㄥ摢閲岋紝涔熶笉绠℃暟鎹簮浣跨敤鐨勬槸鍝 SQL 鏂硅█銆傚浘 2 璇存槑鑱旈偊绯荤粺鐨勬灦鏋勩
鍥 2. 鑱旈偊绯荤粺閰嶇疆鐨勬灦鏋
鑱旈偊绯荤粺涓庢瘡涓暟鎹簮閫氫俊鏄氳繃绉颁綔鍖呰鍣 鐨勮蒋浠舵ā鍧楄繘琛岀殑銆傚寘瑁呭櫒鍖呭惈鐗瑰畾鏁版嵁婧愮殑鐗瑰緛銆傚畠鎻愪緵浜嗚繙绋嬫暟鎹殑 DB2 鍏崇郴妯″瀷锛屽苟閫氳繃鍚戣繙绋嬫暟鎹簮鍙戦佸瓙鏌ヨ浠ュ府鍔╄仈閭﹀紩鎿庡疄鐜版煡璇㈠鐞嗐
鍦ㄨ仈閭︾郴缁熶腑锛屾湇鍔″櫒 琛ㄧず杩滅▼鏁版嵁婧愪笂鐨勪竴涓暟鎹泦鍚堛傚浜庡叧绯绘暟鎹簮鏉ヨ锛岃繖涓泦鍚堥氬父灏辨槸鏁版嵁搴撱傛湇鍔″櫒鏄氳繃 CREATE SERVER DDL 璇彞鍦ㄨ仈閭︾郴缁熶腑娉ㄥ唽鐨勩傝 DDL 灏嗕笌杩滅▼鏁版嵁闆嗗悎鏈夊叧鐨勪俊鎭瓨鍌ㄥ湪 Information Integrator 缂栫洰涓備緥濡傦紝鍒涘缓鏈嶅姟鍣ㄦ椂锛屾暟鎹簱鐨勫悕绉般佺被鍨嬪拰鐗堟湰锛堝 Oracle 8銆丼ybase 11.9锛夐兘浼氬湪 Information Integrator 缂栫洰涓敞鍐屻傛湇鍔″櫒瀹氫箟鐢ㄤ簬閫氳繃鎵璋撶殑鍒悕 浠庤繙绋嬫暟鎹簮璁块棶鏁版嵁銆
