鑷�宸辨�荤粨鐨凨ettle浣跨敤鏂规硶鍜屾垚鏋?- 鐧惧害鏂囧簱

鏂板缓

涓婁紶

棣栭〉

鍔╂墜

鏈�杩?/div>

璧勬枡搴?/div>

宸ュ叿

KETTLE

浣跨敤鑷�宸辨�荤粨鐨?/p>

Kettle

浣跨敤鏂规硶鍜屾垚鏋滆�存�?/p>

 

绠�浠?/p>

 

Kettle

鏄�涓�娆惧浗澶栧紑婧愮殑

ETL

宸ュ叿锛岀函

java

缂栧啓锛屽彲浠ュ湪

Window

銆?/p>

Linux

銆?/p>

Unix

涓婅繍琛岋紝缁胯壊鏃犻渶瀹夎�咃紝鏁版嵁鎶藉彇楂樻晥绋冲畾銆?/p>

 

 

Kettle 

涓�鏂囧悕绉板彨姘村６锛�

璇ラ」鐩�鐨勪富绋嬪簭鍛�

MATT 

甯屾湜鎶婂悇绉嶆暟鎹�鏀惧埌涓�涓?/p>

澹堕噷锛岀劧鍚庝互涓�绉嶆寚瀹氱殑鏍煎紡娴佸嚭銆?/p>

 

 

Kettle

杩欎釜

ETL

宸ュ叿闆嗭紝瀹冨厑璁镐綘绠＄悊鏉ヨ嚜涓嶅悓鏁版嵁搴撶殑鏁版嵁锛岄�氳繃鎻愪緵涓�

涓�鍥惧舰鍖栫殑鐢ㄦ埛鐜�澧冩潵鎻忚堪浣犳兂鍋氫粈涔堬紝鑰屼笉鏄�浣犳兂鎬庝箞鍋氥�?/p>

 

Kettle

涓�鏈変袱绉嶈剼鏈�鏂囦欢锛?/p>

transformation

鍜?/p>

job

锛?/p>

transformation

瀹屾垚閽堝�规�?/p>

鎹�鐨勫熀纭�杞�鎹�锛?/p>

job

鍒欏畬鎴愭暣涓�宸ヤ綔娴佺殑鎺у埗銆?/p>

 

Kettle

鍙�浠ュ�?/p>

http://kettle.pentaho.org/

缃戠珯涓嬭浇鍒般�?/p>

 

娉�锛�

ETL

锛屾槸鑻辨枃

 

Extract-Transform-Load 

鐨勭缉鍐欙紝鐢ㄦ潵鎻忚堪灏嗘暟鎹�浠庢潵婧愮�?/p>

缁忚繃钀冨彇锛?/p>

extract

锛夈�佽浆缃�锛�

transform

锛夈�佸姞杞斤紙

load

锛夎嚦鐩�鐨勭��鐨勮繃绋嬨�?/p>

ETL

涓�璇嶈緝甯哥敤鍦ㄦ暟鎹�浠撳簱锛屼絾鍏跺�硅薄骞朵笉闄愪簬鏁版嵁浠撳簱銆?/p>

 

涓嬭浇鍜屽畨瑁?/p>

 

棣栧厛锛岄渶瑕佷笅杞藉紑婧愬厤璐圭殑

pdi-ce

杞�浠跺帇缂╁寘锛屽綋鍓嶆渶鏂扮増鏈�涓�

5.20.0

銆?/p>

 

涓嬭浇缃戝潃锛?/p>

http://sourceforge.net/projects/pentaho/files/Data%20Integration/

 

 

鐒跺悗锛岃В鍘嬩笅杞界殑杞�浠跺帇缂╁寘锛�

pdi-ce-5.2.0.0-209.zip

锛岃В鍘嬪悗浼氬湪褰撳墠鐩�褰�

涓嬩笂浼犱竴涓�鐩�褰曪紝鍚嶄负

data-integration

銆?/p>

 

 

鐢变簬

Kettle

鏄�浣跨�?/p>

Java

寮�鍙戠殑锛屾墍浠ョ郴缁熺幆澧冮渶瑕佸畨瑁呭苟涓旈厤缃�濂�

JDK

銆?/p>

 

 

啪Kettle

鍙�浠ュ�?/p>

http://kettle.pentaho.org/

缃戠珯涓嬭浇

 

啪 

涓嬭浇

kettle

鍘嬬缉鍖咃紝鍥?/p>

kettle

涓虹豢鑹茶蒋浠讹紝瑙ｅ帇缂╁埌浠绘剰鏈�鍦拌矾寰勫嵆鍙�銆?/p>

 

杩愯��

Kettle 

 

杩涘叆鍒?/p>

Kettle

鐩�褰曪�?/p>

濡傛灉

Kettle

閮ㄧ讲鍦?/p>

windows

鐜�澧冧笅锛�

鍙屽嚮杩愯��

spoon.bat

鎴?/p>

Kettle.exe

鏂囦欢銆?/p>

Linux

鐢ㄦ埛闇�瑕佽繍琛?/p>

spoon.sh

鏂囦欢锛?/p>

杩涘叆鍒?/p>

Shell

鎻愮ず琛岀獥鍙ｏ紝

杩涘叆鍒拌В鍘嬬洰褰曚腑鎵ц�屼笅闈㈢殑鍛戒护锛�

 

# chmod +x spoon.sh 

# nohup ./spoon.sh & 

 

 

鍚庡彴杩愯�岃剼鏈�

 

杩欐牱灏卞彲浠ユ墦寮�閰嶇疆

Kettle

鑴氭湰鐨?/p>

UI

鐣岄潰銆?/p>