Talendã®ãžã§ãèšèšãã¿ãŒã³ãšãã¹ããã©ã¯ãã£ã¹ïŒç¬¬2éšïŒ
 ååæ²èŒãããTalendã®ãžã§ãèšèšãã¿ãŒã³ãšãã¹ããã©ã¯ãã£ã¹ã®ç¬¬1éšã¯ãéåžžã«å¥œè©ãããã ããŸãããèªãã§ãã ãã£ãæ¹ãããããšãããããŸãããŸã èªãã§ããªãæ¹ã¯ããã²ãèªã¿ãã ããã第2éšã§ã¯ã第1éšã®å 容ãããšã«ãããã«è©³çްãªå 容ã解説ããŠãããŸãããŸããããã«é«åºŠãªå 容ã«ã€ããŠãããã€ãã玹ä»ããããšæããŸãã
ã¯ããã«
ç§ã¯ãTalendã®éçºã«é·å¹Žæºãã£ãŠããŸããããä»ã®éçºè ããžã§ããäœæããæ¹æ³ã«å¯ŸããŠåžžã«èå³ãæã£ãŠããŸããæ©èœãæ£ãã䜿çšããŠããããäžè¬çãªã¹ã¿ã€ã«ã䜿çšããŠãããããããšãç§ãç¥ããªãã¹ã¿ã€ã«ãªã®ããä»ã«ã¯ãªãåªãããœãªã¥ãŒã·ã§ã³ãéçºããŠãããããã£ã³ãã¹/ã³ã³ããŒãã³ãããŒã¿/ã¯ãŒã¯ãããŒãæã€æœè±¡çãªç¹æ§ã«èŠåŽããŠããã®ã§ã¯ãªãããçããã©ãã§ãããéèŠãªã®ã¯ãèšèšã®æå³ã«æ²¿ã£ãŠããŒã«ã䜿çšããããšã§ãããããããããã®ããã°ã§ãžã§ãèšèšã®ãã¿ãŒã³ãšãã®ãã¹ããã©ã¯ãã£ã¹ã解説ããŠããçç±ã§ããTalendã®æ©èœããã¹ãŠçè§£ããã ãã§ã¯ååã§ã¯ãªãããžã§ããäœæããæé©ãªæ¹æ³ãçè§£ããå¿ èŠãããããšç§ã¯èããŠããŸãã
è«ççã«ã¯ããããžãã¹ãŠãŒã¹ã±ãŒã¹ãã¯ããããTalendãžã§ãã®åºæ¬çãªæšé²èŠçŽ ã§ããå®éã«ã¯ãåãã¯ãŒã¯ãããŒã§ãããŸããŸãªããªãšãŒã·ã§ã³ããããŸãããã¯ãŒã¯ãããŒã«ãããŸããŸãªã¿ã€ããååšããŸãããã®ãããªããŠãŒã¹ã±ãŒã¹ãã®ã»ãšãã©ã¯ããããŒã¿ãœãŒã¹ããããŒã¿ãæœåºããŠåŠçãããã®ããŒã¿ã倿ããåŸãæçµçã«ã¯å¥ã®ã¿ãŒã²ããã«ããŒãããããšããæãã·ã³ãã«ãªåœ¢åŒã§è¡ãããããŒã¿çµ±åãžã§ãããšãã倧åæããã¹ã¿ãŒãããŸãããã®ç¹ã§ãETL/ELTã³ãŒãã¯ç§ãã¡ã®äœæ¥ã®æŽ»åæºã§ãããšèšããŸããããã¯ãTalendã§æ¥ã ã³ãŒãã£ã³ã°ã«åãçµãã§ããéçºè ã®çããããããåããªã®ã§ãããã§ã¯æ±ããŸããã第2éšã§ã¯ãçããã®èŠéãåºããå 容ãã玹ä»ããããšæããŸãã
Talendã®ææ°ãªãªãŒã¹ïŒv6.1.1ïŒã¯ããããŸã§ã§æé«ã®ããŒãžã§ã³ã ãšæããŸããããã°ããŒã¿ãSparkãæ©æ¢°åŠç¿ãUIã®ã¢ããã€ãŒãŒã·ã§ã³ãç¶ç¶çãªçµ±åãšå±éã®èªååïŒä»ã«ãå€åœ©ãªæ©èœãå®è£ ãããŠããŸãïŒã«ãããŠãã³ã³ããŒãã³ããæ°ãã«å ãããŸããã仿¥è²©å£²ãããŠããããŒã¿çµ±åãã¯ãããžãŒã®äžã§æãåªããå ç¢æ§ãšæ©èœæ§ãèªãããŒãžã§ã³ã§ããå°ã æåå³åãããããŸãããããŠãŒã¶ãŒã®çãããç§ãšåãè©äŸ¡ãããŠãã ãããšæããŸãããã²ããèªåã§å®æããŠã¿ãŠãã ããã
DIãããžã§ã¯ããæåãžãšå°ã3ã€ã®åºæ¬çæé
ã§ã¯ãå§ããŸããããæ€ åãç«ã€ã«ã¯ãèãå°ãªããšã3æ¬ã¯å¿ èŠã§ããããã¯ããœãããŠã§ã¢éçºã«ãåœãŠã¯ãŸããŸããããŒã¿çµ±åãããžã§ã¯ãã®äœæãšããªããªãŒãæåãããã«ã¯ã3ã€ã®åºæ¬çãªèŠçŽ ãååšããŸãã
- ãŠãŒã¹ã±ãŒã¹ - æç¢ºã«å®çŸ©ãããããžãã¹ããŒã¿/ã¯ãŒã¯ãããŒèŠä»¶
- ãã¯ãããžãŒ - ãœãªã¥ãŒã·ã§ã³ãæ§ç¯ãå±éãå®è¡ããããŒã«
- ææ³ - äžè¬çã«åæãããå®è¡æ¹æ³
äžèšã念é ã«ãæç¢ºã«å®çŸ©ããããéçºã¬ã€ãã©ã€ã³ãããã¥ã¡ã³ãïŒãã®ã·ãªãŒãºã®ç¬¬1éšãèªãã§ããã ããã§ããããïŒ ãããžã§ã¯ãçšã®ããã¥ã¡ã³ãã¯äœæãããŠããŸããïŒïŒã«æ²¿ã£ãŠãåæãšãªãæ¡ä»¶ãæ§ç¯ããŠãããŸãããã
åºæ¬çæéã®æ¡åŒµ
Talendã®ããžã§ãããããŠãŒã¹ã±ãŒã¹ãã¯ãŒã¯ãããŒå ã®ãã¯ãããžãŒã§ããã°ããžã§ãèšèšãã¿ãŒã³ã¯ãããæ§ç¯ãããã¹ããã©ã¯ãã£ã¹ã®ãææ³ãã§ãããã®ããã°ã®å å®¹ã§æãéèŠãªããšã¯ãäžè²«ããæ¹æ³ã§ãžã§ããäœæããããšããç¹ã§ãããããããè¯ãæ¹æ³ãèŠã€ããããããããŸãæ©èœããŠããã®ã§ããã°ããã®ãŸãŸé²ãã§ãã ããããã ããããã©ãŒãã³ã¹ãåå©çšæ§ãä¿å®æ§ã®åäžã«èŠæŠããŠããæ¹ããå€åãç¶ããèŠä»¶ã«åãããŠã³ãŒãã®ãªãã¡ã¯ã¿ãªã³ã°ãç¶ããŠããæ¹ã«ã¯ããããã®ãã¹ããã©ã¯ãã£ã¹ã圹ç«ã¡ãŸãã
ããã«æ€èšãã¹ã9ã€ã®ãã¹ããã©ã¯ãã£ã¹ïŒ
ãœãããŠã§ã¢éçºã©ã€ããµã€ã¯ã«ïŒSDLCïŒ
åäžé·è ã®Marcus Leminosæ°ãæäŸããçªçµããThe ProfitãïŒCNBCïŒã«ããã°ãã人ã補åãããã»ã¹ãã¯ãããããããžãã¹ã®æåŠãåãã3倧èŠçŽ ã§ããããã«ã¯ãç§ãåæããŸããSDLCããã»ã¹ã¯ããœãããŠã§ã¢éçºããŒã ã®èŠã§ãããã®ããã»ã¹ãé©åã«è¡ãããšãéåžžã«éèŠã§ããããããç¡èŠããã°ããããžã§ã¯ãã«æ·±å»ãªåœ±é¿ãåãŒãããããžã§ã¯ãã¯å€±æã«é¥ã£ãŠããŸããŸããTalendã®SDLCãã¹ããã©ã¯ãã£ã¹ã¬ã€ãã«ã¯ãTalendãéçºè ã«æäŸããç¶ç¶ççµ±åãšå±éã«é¢ããæŠå¿µãååã仿§ã詳现ãªèª¬æãèšèŒãããŠããŸããåã®ããã°èšäºã§ã玹ä»ãããéçºã¬ã€ãã©ã€ã³ãããã¥ã¡ã³ãã«SDLCãã¹ããã©ã¯ãã£ã¹ãåæ ããããšãããã¹ãŠã®ãœãããŠã§ã¢éçºããŒã ã«ãå§ãããŸãã
ã¯ãŒã¯ã¹ããŒã¹ã®ç®¡ç
Talend StudioãããŒãPC/ã¯ãŒã¯ã¹ããŒã·ã§ã³ã«ã€ã³ã¹ããŒã«ãããšïŒç®¡çè æš©éããããã®ãšããŸãïŒãããã©ã«ãã®[Workspace]ãã£ã¬ã¯ããªãããŒã«ã«ãã£ã¹ã¯ãã©ã€ãäžã«äœæãããŸããå€ãã®ãœãããŠã§ã¢ã€ã³ã¹ããŒã«ãšåæ§ã«ããã®ããã©ã«ããã£ã¬ã¯ããªã¯ãå®è¡å¯èœãã¡ã€ã«ãšåããã£ã¬ã¯ããªå ã«äœæãããŸããç§ã¯ãããã¯è¯ããã©ã¯ãã£ã¹ã ãšã¯æããŸããããªãã§ããããã
ãããžã§ã¯ããã¡ã€ã«ïŒãžã§ãããªããžããªã¡ã¿ããŒã¿ïŒã®ããŒã«ã«ã³ããŒã¯ããã®[Workspace]ã«æ ŒçŽãããŸãããããããœãŒã¹ã³ãŒã管çã·ã¹ãã ïŒSVNãGITïŒã«Talend Administration CenterïŒTACïŒãä»ããŠã¢ã¿ãããããšããããžã§ã¯ãããªãŒãã³ãŸãã¯ä¿åãããã³ã«åæãè¡ãããŸãããã®ãããªãã¡ã€ã«ã¯ãç°¡åã«èå¥ããã³ç®¡çã§ããå Žæã«æ ŒçŽãã¹ãã§ãããã£ã¹ã¯ïŒãŸãã¯å¥ã®ããŒã«ã«ãã©ã€ãïŒäžã«æ ŒçŽããã®ãããã§ãããã
ã¯ãŒã¯ã¹ããŒã¹ã¯ãTalend Studioã§æ¥ç¶ãäœæããéã«äœ¿çšãããŸããæ¥ç¶ã¯ããããŒã«ã«ããšããªã¢ãŒããã®ããããã§ãããã®2ã€ã®çžéç¹ã¯ããããŒã«ã«ãæ¥ç¶ãTACã§ç®¡çãããªãã®ã«å¯ŸããŠãããªã¢ãŒããæ¥ç¶ã¯TACã§ç®¡çãããããšããç¹ã§ããäžè¬çã«ããµãã¹ã¯ãªãã·ã§ã³ãŠãŒã¶ãŒã¯ããªã¢ãŒããæ¥ç¶ã®ã¿ã䜿çšããŸãã
ããŒã å šå¡ã䜿çšãããéçºã¬ã€ãã©ã€ã³ãããã¥ã¡ã³ãã§ãã£ã¬ã¯ããªæ§é ãæç¢ºã«å®çŸ©ããããšã§ãæé©ãªã³ã©ãã¬ãŒã·ã§ã³ãå®çŸã§ããŸããããã§éèŠãªã®ã¯ãããŒã ã®åæãåŸãŠãèŠç¯ã培åºããäžè²«æ§ãç¶æããããšã§ãã
åç §ãããžã§ã¯ã
çããã¯ãåç §ãããžã§ã¯ãã䜿çšããŠããŸãããåç §ãããžã§ã¯ãããåç¥ã§ãããããåç §ãããžã§ã¯ãã¯ãã·ã³ãã«ã§ããã«ããããããçç£æ§ãé«ããæ©èœãªã®ã§ããã䜿çšããŠããªããŠãŒã¶ãŒãæ°å€ãååšããŸããåå©çšå¯èœãªæ±çšã³ãŒããäœæããè€æ°ã®ãããžã§ã¯ãã§å ±æããããšã¯ãéçºè å ±éã®ããŒãºã§ããéçºè ã¯ããããžã§ã¯ããéå§ããéãã³ãŒãã®äžéšãã³ããŒããå¥ã®ïŒãŸãã¯åãïŒãããžã§ã¯ãããžã§ãã«è²Œãä»ããããšããäœæ¥ãããè¡ããŸãããŸãã¯ããããããžã§ã¯ãã®ãªããžã§ã¯ãããšã¯ã¹ããŒãããå¥ã®ãããžã§ã¯ãã«ã€ã³ããŒãããããšãããã§ãããããã€ãŠã¯ãç§ããã®æ¹æ³ã䜿çšããŠããŸããããã®ãããªæ¹æ³ã«åé¡ã¯ãªãã®ã§ããããå§ãã¯ããŸããããã®ããã»ã¹ã«ã¯ãä¿å®ã«ãããŠæ·±å»ãªåé¡ãçºçããå±éºãæœãã§ããŸããããã§ãå§ããªã®ããåç §ãããžã§ã¯ãã§ããç§ã¯ãåç §ãããžã§ã¯ããèŠã€ãããšãããšãŠãå¬ããã£ãããšãæ¶ããŠããŸãã
TACã䜿çšããŠãããžã§ã¯ããäœæããŠããæ¹ã¯ãã²ã£ãããšååšãã[Reference]ãã§ãã¯ããã¯ã¹ã«æ°ä»ãããããã¯äœã ããïŒããæã£ãããšãããã®ã§ã¯ãªãã§ããããããããžã§ã¯ããäœæãããã®ãã§ãã¯ããã¯ã¹ãéžæããŠãåç §ãããžã§ã¯ãããäœæãããšãä»ã®ãããžã§ã¯ãããå«ãããèšå®ãããªã³ã¯ãããããšãå¯èœã«ãªããŸãããåç §ãããžã§ã¯ããã§äœæããã³ãŒãã¯ããªã³ã¯ãããããžã§ã¯ãå ã§äœ¿çšã§ããããã«ãªãããïŒèªã¿åãå°çšïŒãåå©çšå¯èœæ§ãéåžžã«é«ãŸããŸãããã®ãããžã§ã¯ãã«ã¯ãå ±éã®ãªããžã§ã¯ããã³ãŒãããã¹ãŠæ ŒçŽãã¹ãã§ãã
Â
ãã ãããåç §ãããžã§ã¯ããã¯æå°éã«çããå¿ èŠããããŸãããã¹ããã©ã¯ãã£ã¹ã§ã¯ãåç §ãããžã§ã¯ãã®æ°ã¯1ã€ã«éå®ããŠãã ãããå Žåã«ãã£ãŠã¯ã2ã€ãŸãã¯3ã€ã§ãåé¡ãããŸãããæ³šæïŒãåç §ãããžã§ã¯ããã®æ°ãå€ããããšããã®å¹æãæãªãããŠããŸããåç §ãããžã§ã¯ãã§ã¯ãæ éãªç®¡çãéåžžã«éèŠã«ãªããŸãããã®çšéãšã«ãŒã«ããéçºã¬ã€ãã©ã€ã³ãããã¥ã¡ã³ãã«æèšããããŒã å šäœãé å®ããããšã«ãããæé©ãªã³ã©ãã¬ãŒã·ã§ã³ãå®çŸã§ããŸãã
ãªããžã§ã¯ãã®åœåèŠå
ãååãäœã ãšããã®ããã©ã®ãããªåã§åŒã°ããããšãèèã¯çŸããéŠãããšããæåãªå°è©ããããŸããã
ããã¯ãã£ãŠãããã¯ããåœåèŠåãã¯éèŠã§ããã©ã®éçºããŒã ãåœåèŠåã«é¢ããŠæ€èšãããã©ã¯ãã£ã¹ã確ç«ãã¹ãã§ããTalendãªããžã§ã¯ãã®ååãåœåã®ã¿ã€ãã³ã°ãåœåæ¹æ³ã«ããããããäžè²«æ§ãå¿ èŠäžå¯æ¬ ã§ããTalendã®ãªããžã§ã¯ãã®åœåèŠåããéçºã¬ã€ãã©ã€ã³ãããã¥ã¡ã³ãã«æèšããããŒã å šäœãé å®ããããšã§ãæé©ãªã³ã©ãã¬ãŒã·ã§ã³ãå®çŸã§ããŸãïŒæ¬¡ç¬¬ã«ãã¿ãŒã³ãèŠããŠããããšã«ãæ°ä»ãã§ããããïŒã
ãããžã§ã¯ããªããžããª
Talend StudioïŒEclipse IDEïŒIntegrated Development Environmentãç°¡åã«èšãã°ããžã§ããšãã£ã¿ãŒã§ãïŒã§ãžã§ããéããšãå·Šã®ããã«ã«ãããžã§ã¯ããªããžããªã衚瀺ãããŸããããã«ããããžã§ã¯ããªããžã§ã¯ããæ ŒçŽãããŠããŸããããã«ã¯ã極ããŠéèŠãªã»ã¯ã·ã§ã³ãããã€ãååšããŸãããã®1ã€ãjob Designsã»ã¯ã·ã§ã³ã§ãããv6.1.1ã§ã¯3ã€ã®ã¿ã€ãã®ãžã§ãïŒããŒã¿çµ±åãããããã¹ããªãŒãã³ã°ïŒãäœæã§ããããã«æ¡åŒµãããŸããããã以å€ã«ããç¥ã£ãŠããã¹ãéèŠãªã»ã¯ã·ã§ã³ããããŸãã
- ã³ã³ããã¹ãã°ã«ãŒã - çµã¿èŸŒã¿ã®ãžã§ãã³ã³ããã¹ã倿°ãäœæããã®ã§ã¯ãªãããªããžããªã®ã³ã³ããã¹ãã°ã«ãŒãå ã«äœæããŸããããã«ããããžã§ãå šäœã§åå©çšå¯èœã«ãªããŸãïŒåç §ãããžã§ã¯ãã«å«ããå Žåã¯ããããžã§ã¯ãå ã§ã䜿çšå¯èœïŒããã®ããã«ã¯ãã°ã«ãŒãã广çã«ç·šæããå¿ èŠããããŸããSBX/DEV/TEST/UAT/PRODã®ç°å¢ããšã«ã°ã«ãŒããäœæããã®ããã¹ããã©ã¯ãã£ã¹ã§ãããããã©ã«ããã®ã³ã³ããã¹ãã¯åé€ããŠãã ãããÂ
ãã®äŸã§ã¯ããSysENVTYPEããšããã³ã³ããã¹ã倿°ã远å ãããŠããŸãããã®å€æ°ã«ã¯ãéžæããç°å¢å ã®åçãªããã°ã©ãããªãã£ã§äœ¿çšããå€ãæ ŒçŽãããŠããŸããã€ãŸãããžã§ãå ã§ãã®å€æ°ã䜿çšããããšã«ãã£ãŠçŸåšã®å®è¡ç°å¢ãç¹å®ã§ãããããæ¡ä»¶ä»ãããžãã¯ã䜿çšããŠãããŒãããã°ã©ã ã§å€æŽããããšãå¯èœã«ãªããŸãã
Â
- ã¡ã¿ããŒã¿ - ã¡ã¿ããŒã¿ã¯ããŸããŸãªåœ¢æ ãåããŸããDBæ¥ç¶ãããŒãã«ã¹ããŒãããå€å²ã«ããããã©ãããã¡ã€ã«æ§é ïŒ.csvã.xmlã.jsonãªã©ïŒãããã¹ãп޻çšããŠãã ãããããã«ãåžžã«æçšãªæ±çšã¹ããŒãã¯ãããã«æžãåããªãã»ã©ããŸããŸãªçšéã«æŽ»çšã§ããŸãã
- ããã¥ã¡ã³ã - ãããžã§ã¯ãWikiãäœæããããŒã ã«å ¬éããŸãã圹ç«ã€æ å ±ãªã©ããããžã§ã¯ãã«é¢ããhtmlãã¡ã€ã«çŸ€ãäœæãããŸããç°¡åã«æäœã§ãããããæ°åããããããŸããã
ããŒã ã«åœ¹ç«ã€ãã¹ããã©ã¯ãã£ã¹ãããã€ããéçºã¬ã€ãã©ã€ã³ãããã¥ã¡ã³ãã«æ²èŒããé å®ããŸããå¿ èŠã«å¿ããŠèª¿æŽãå¿ èŠã§ããããã®äœæ¥ã«ã¯ããŒã å šå¡ãåå ããããã«ããŠãã ããã
ããŒãžã§ã³ç®¡çïŒãã©ã³ããšã¿ã°ä»ãïŒ
ãžã§ãã®ããããã£ã¿ãã«ã¯ãããŒãžã§ã³çªå·ã¹ããŒããšããŠããã¡ãžã£ãŒããšããã€ããŒããæå®ããå ŽæããããŸããããã«ãã¹ããŒã¿ã¹ãèšå®ããããšãå¯èœã§ãããdevelopmentãããtestãããproductionããšãã£ãå€ãããã©ã«ãã§èšå®ã§ããŸããèŠåïŒããã¯ãSVN/GITãªããžããªã§å ±åéçºããœãŒã¹ã³ãŒã管çïŒSCCïŒæ©èœãå©çšããªãåç¬ã®éçºè ïŒTOSïŒTalend Open StudioïŒåãã«èšèšãããŠããŸãããã®å Žåãå éšãžã§ãããããã£ãå€ãããã³ã«ããžã§ãã®å®å šãªã³ããŒãããŒã«ã«ã¯ãŒã¯ã¹ããŒã¹ã«äœæãããSCCã·ã¹ãã ãšåæããããšããç¹ã«æ³šæããŠãã ãããç§ã¯ãå éšããŒãžã§ã³ã10å以äžå€æŽããããžã§ããã³ããŒããããããžã§ã¯ããèŠãããšããããŸãããžã§ãã®ã³ããŒãã³ããŒãããŠå¢æ®ãããã¹ãŠãSCCãšåæãããŸãããã®çµæããããžã§ã¯ãã¯å·šå€§ã«ãªãããããžã§ã¯ãã®ãªãŒãã³ãšã¯ããŒãºæã«ããã©ãŒãã³ã¹ãå€§å¹ ã«äœäžããå¯èœæ§ããããŸãããã®ãããªçŸè±¡ãçºçããŠããå Žåã«ã¯ãææ°ããŒãžã§ã³ã®ã¿ããšã¯ã¹ããŒãããã³ã€ã³ããŒãããããšã§ã¯ãŒã¯ã¹ããŒã¹ãæ¶å»ããå¿ èŠããããŸããé¢åãªäœæ¥ã§ããããã䟡å€ã¯ãããŸãã
ææãµãã¹ã¯ãªãã·ã§ã³ç°å¢ã®ããŒãžã§ã³ç®¡çã§ã¯ãSCCãã€ãã£ãã®ãã©ã³ãããã³ã¿ã°æ©èœã䜿çšããããšããã¹ããã©ã¯ãã£ã¹ã§ããSCCã¯ä¿åãããžã§ãã®å·®åã®ã¿ãä¿æããããããããžã§ã¯ãããŒãžã§ã³ãªãªãŒã¹ã®æé©ãªç®¡çæ¹æ³ã§ããããã«ã¯ããžã§ãå±¥æŽã«å¿ èŠãªã¹ããŒã¹ãå€§å¹ ã«åæžãã广ããããŸããæ°åãæ¥ä»ãªã©ã䜿çšããããŒãžã§ã³ã¹ããŒããèãããéçºã¬ã€ãã©ã€ã³ãããã¥ã¡ã³ãã«èšèŒããããŒã å šäœãé å®ããŠãã ããã
ã¡ã¢ãªç®¡ç
ãžã§ãã®å®è¡ã§ã¯ãããŸããŸãªé ç®ãèããå¿ èŠããããŸããã©ã®çšåºŠã®ã¡ã¢ãªå®¹éãå¿ èŠã«ãªãããããŒã¿ãããŒã§èšå€§ãªæ°ã®è¡ãåŠçããããã«ã©ã ãtMapã®ã«ãã¯ã¢ããã®æ°ããžã§ããå®è¡ããããžã§ããµãŒããŒãã§ä»ã®ãžã§ããåæå®è¡ããããããžã§ããµãŒããŒãã«æèŒãããŠããã³ã¢ãRAMãtMapçµåã¯ã[Load Once]ãš[Row by row]ã®ã©ã¡ããèšå®ãããããžã§ãã§åãžã§ããåŒã³åºããã芪ãžã§ãã«åŒã³åºããããããã¹ãæ§é ã®æ°ãåãžã§ããå¥ã®JVMäžã§å®è¡ããããESBãžã§ããèšè¿°ããå Žåãäœæãããã«ãŒãã®æ°ã¯ããã€ãããã䞊ååŠçïŒäžãåç §ïŒã䜿çšãããããªã©ããããŸãããããã§ããããããã®ãããªé ç®ããã¹ãŠæ€èšããŠãã人ã¯ããªãã§ãããã
ããã©ã«ãèšå®ã¯ãèšå®å¯èœãªåºæ¬å€ã§ããã¡ã¢ãªå²ãåœãŠãªã©ããžã§ãã«ã¯ããã€ãã®ããã©ã«ãå€ãèšå®ãããŠããŸãããšããããããã©ã«ãå€ãåžžã«é©åã§ãããšã¯éãããå®éã«ã¯åé¡ã®åå ã«ãªãå¯èœæ§ãããã®ã§ãã[Use Case Job Design]ã[Operational Ecosystem]ã[Real Time JVM Thread Count]ãã¡ã¢ãªäœ¿çšéãæ±ºå®ããŸããã¡ã¢ãªäœ¿çšéã¯ç®¡çããå¿ èŠããããŸãã
 JVMã¡ã¢ãªèšå®ã¯ããããžã§ã¯ãã¬ãã«ãåã ã®ãžã§ãã§æå®ãå¯èœã§ãïŒäžèšåç §ïŒã
[Preferences] > [Talend] > [Run]
ããã«äœæ¥ãéå§ããŠåé¡ã解決ããŸããããã¡ã¢ãªç®¡çã¯èŠèœãšãããã¡ãªäœæ¥ã§ããããéçºãšéçšã®äž¡é¢ã§ãããŒã ã®ã¬ã€ãã©ã€ã³ã«èšèŒããŠé å®ããå¿ èŠããããŸãããã®ã·ãªãŒãºã®ç¬¬1éšããŸã èªãã§ããªãæ¹ã¯ããã²èªãã§ãã ããã
åçSQLæ§æ
å€ãã®ããŒã¿ããŒã¹å ¥åã³ã³ããŒãã³ãã§ã¯ãSQLæ§æã[Basic Settings]ã¿ãã§æ£ããæå®ããå¿ èŠããããŸãããã¡ãããtMyDBInputã³ã³ããŒãã³ãã«æ§æãçŽæ¥å ¥åããããšãã§ããŸããããžã§ãã芪ãžã§ããå¶åŸ¡ããããžãã¯ã«åºã¥ããŠãå®è¡æã«è€éãªSQLã¯ãšãªãŒãåçã«äœæããããšãèãããšããã¡ãã®æ¹ãç°¡åã§ããSQLã¯ãšãªãŒã®åºæ¬æ§æã«äœ¿çšãããã³ã³ããã¹ã倿°ããäœæããtMyDBInputã³ã³ããŒãã³ãã«å°éããåã®ãžã§ããããŒã§èšå®ããããŒãã³ãŒãã¯ãšãªãŒã®ä»£ããã«ã³ã³ããã¹ã倿°ã䜿çšããŸãã
ããšãã°ããã³ã³ããã¹ãã°ã«ãŒããããåç §ããããžã§ã¯ããªããžããªã«äœæãããSystemVARSããšããååãä»ãããšããŸããããã«ã¯ãåå©çšå¯èœãªå¹ åºã倿°ãå«ãŸããŠããŸããåçSQLã®ãã©ãã€ã ã«ã¯ã次ã®ãæååã倿°ãå®çŸ©ããåæå€ããnullããšããŸããã
ãã®å€æ°ãtJavaã³ã³ããŒãã³ãã«èšå®ããæ¬¡ã®ããã«ãtMyDBInputã¯ãšãªãŒãã£ãŒã«ãã«çµã¿èŸŒã¿ãŸãã
âSELECT â + Context.sqlCOLUMNS + Context.sqlFROM + Context.sqlWHERE
倿°å€ã®é£çµã§ã¯ãå€ã®åŸãã«ãã¹ããŒã¹ããå ¥åããããšã§èŠããããªããŸããããã«ãã现ããå¶åŸ¡ãå¿ èŠãªå Žåã«ã¯ããsqlSYNTAXã倿°ã䜿çšããSQLæ§æã®å¥ãé£çµããæ¡ä»¶ãå¶åŸ¡ããŠãContext.sqlSYNTAXãtMyDBInputã¯ãšãªãŒãã£ãŒã«ãã«å ¥åããŸããããŒã¿ããŒã¹ãã¹ãããèŠããšåçSQLã§ã¯ãããŸãããããžã§ãããèŠããšSQLã¯åçã«çæãããŸãã
以äžã®å 容ãã¹ãŠãã¬ã€ãã©ã€ã³ã«èšèŒããããŒã å šå¡ãé å®ããŠãã ããã
ãªãã·ã§ã³ã®äžŠåå
Talendã¯ãã³ãŒãã䞊ååããã¡ã«ããºã ãããã€ãæäŸããŠããŸããé©åãã€å¹ççã«äœ¿çšããCPUã³ã¢ãRAMãžã®åœ±é¿ããã£ãããšæ€èšããããšã«ãããåªããããã©ãŒãã³ã¹ãçºæ®ãããžã§ãèšèšãã¿ãŒã³ãçæã§ããŸããã§ã¯ããªãã·ã§ã³ãã玹ä»ããŸãããã
- å®è¡èšç» - è€æ°ã®ãžã§ã/ã¿ã¹ã¯ãTACãã䞊åå®è¡ããèšå®ãå¯èœã§ãã
- è€æ°ã®ãžã§ããã㌠- 1ã€ã®ãžã§ãå ã§è€æ°ã®ããŒã¿ãããŒãäœããåãã¹ã¬ãããå ±æããŸãããããŒéã«äŸåé¢ä¿ããªãå ŽåãçšãªãŠãŒã¹ã±ãŒã¹ã·ããªãªã®ããã®ææ³ãšãªããŸããäžè¬çã«ç§ã¯ãã®æ¹æ³ã䜿çšããããžã§ããåå¥ã«äœæããŸãã
- 芪/åãžã§ã - tRunJobã³ã³ããŒãã³ãå ã§åãžã§ããåŒã³åºããšãã[Use an independent process to run subjob]ããã¯ã¹ãéžæããããšã«ãããå¥ã®JVMããŒã/ã¹ã¬ããã確ç«ãããããã§åãžã§ããå®è¡ã§ããŸãããã ãããã¯ãå³å¯ã«èšããšäžŠååã§ã¯ãããŸããã
- ã³ã³ããŒãã³ã - tParallelizeã³ã³ããŒãã³ãã¯è€æ°ã®ããŒã¿ãããŒã«ãªã³ã¯ããŸããtPartitionerãtDepartitionerãtCollectorãtRecollectorã³ã³ããŒãã³ãã¯ãããŒã¿ãããŒã®äžŠåã¹ã¬ããã®æ°ãçŽæ¥å¶åŸ¡ããŸãã
- DBã³ã³ããŒãã³ã - ã»ãšãã©ã®DBå ¥åºåã³ã³ããŒãã³ãã¯ãç¹å®ã®SQLã¹ããŒãã¡ã³ãã§ã¹ã¬ããæ°ã®äžŠååãæå¹ã«ããé«åºŠãªèšå®ãå¯èœã§ããå€§å¹ ãªå¹çåãå¯èœã§ãããå€ã倧ãããããšé广ã§ãããã¹ããã©ã¯ãã£ã¹ãšããŠã¯ã2ïœ5ãæå®ããŠãã ããã
äžèšã®äžŠååææ³ãçµã¿åãããŠãã¹ãåããå Žåã«ããæ³šæãå¿ èŠã§ããã¡ã¢ãªäœ¿çšã¹ã¿ãã¯ãææ¡ãããžã§ãèšèšãã¿ãŒã³ã®å®è¡ãããŒã«çްå¿ã®æ³šæãæã£ãŠãã ããããã®äžŠååãªãã·ã§ã³ã¯ãé«åºŠãªæ©èœãšããŠTalend Platformã®ã¿ã§æäŸãããŠããŸãã䞊ååã®ã¬ã€ãã©ã€ã³ã¯ããã¥ã¡ã³ãããåé€ããŸããã...ãšããã®ã¯åè«ã§ãïŒ
Talendãžã§ããæåãããç§èš£
ãžã§ãèšèšãã¿ãŒã³ã®ãã¹ããã©ã¯ãã£ã¹ã¯ãTalendãžã§ããäœæããæåã®æ¹æ³ãæ€èšããéã®åèã«ãªãã¯ãã§ãããžã§ãã®äœæãæåãžãšå°ãåºæ¬ã¯ãã¬ã€ãã©ã€ã³ã®äœæãèŠç¯ãäžè²«æ§ã§ããå®è·µããããšæ±ºå®ããé å®ããŠãã ãããããŒã¿/ã¯ãŒã¯ãããŒã®ã³ãŒãã£ã³ã°ã§ã¯ã次ã®ç¹ãçæããŠãã ããã
ãè¡åããã¹ãŠã®æåã®éµã ïŒã- ãããã»ãã«ãœ
æåŸã«ãTalendãžã§ãã®äœæãæåãžãšå°ãç§èš£ãšããŠã泚æäºé ããŸãšããŸãã
- - tPreJobã³ã³ããŒãã³ããštPostJobã³ã³ããŒãã³ãã®äž¡æ¹ã䜿çšãã
- ãã£ã³ãã¹ãç ©éã«ããªããã³ã³ããŒãã³ããéå°ã«ã°ã«ãŒãåãããå°ãåºãã
- ã³ãŒããèŠãããã¬ã€ã¢ãŠããããäžããäžãžãå·Šããå³ãž
- ååã®ã³ãŒãã£ã³ã°ã§ããŸããããšæåŸ ããªã
- ã¡ã€ã³ã®ãžã§ãã«ãŒããç¹å®ããä¿®äºãå¶åŸ¡ãã
- ãšã©ãŒåŠçææ³ãç¡èŠããªã
- ã³ã³ããã¹ãã°ã«ãŒããå¹ åºãïŒDEV/QA/UAT/PRODïŒè³¢ã䜿ã
- 1ã€ã®ãžã§ãã¬ã€ã¢ãŠãã巚倧ã«ããªã
- å°ããªãžã§ãã¢ãžã¥ãŒã«ãäœæãã
- è€éã«ãããã·ã³ãã«ã«ãã
- æ±çšã¹ããŒããå¿ ã䜿çšããïŒåäžã«ã©ã ã®ã¹ããŒããäŸå€ãšããããšãå¯èœïŒ
- ãªããžã§ã¯ãã«ååãä»ãã
- å¿ èŠã«å¿ããŠïŒãããã§ã¯ãããïŒãžã§ãã¬ããã䜿çšãã
- tJavaFlexã³ã³ããŒãã³ãã®äœ¿ãããã«æ³šæãããtJavaãŸãã¯tJavaRowã§ååãªå Žåããã
- ãããžã§ã¯ãããã¥ã¡ã³ããäœæããŠå ¬éãã
- å®è¡æã¡ã¢ãªããŒãã®èšå®ãçç¥ããªã
ãŸãšã
ãããã ã£ãã§ããããããã®ã·ãªãŒãºã¯ãŸã ãŸã ç¶ããŸãã®ã§ãã©ãããæ¥œãã¿ã«ã次åã¯ããŠãŒã¹ã±ãŒã¹ã®ãµã³ãã«ãããå±ãããŸãããã®ããã°èšäºã§ã¯ã
åºæ¬çãªæŠå¿µãæ¡åŒµããããé«åºŠãªå 容ãããã€ãã玹ä»ããŸããããã²åèã«ããŠãã ãããçãããå®è·µããŠãããã¹ããã©ã¯ãã£ã¹ã«é¢ããã³ã¡ã³ãããå¯ããã ãããææçŸ©ãªãã£ã¹ã«ãã·ã§ã³ã«ãªãããšãæåŸ ããŠããŸããã§ã¯ã次ã®ããã°èšäºããæ¥œãã¿ã«ã
é¢é£ãªãœãŒã¹
Talend Open Studio for Data Integrationã®ç޹ä»
ãã®èšäºã§åãäžããŠãã補å
远å ã®é¢é£èšäº
- ããŒã¿ãµã€ããšã¯äœãïŒ
- ããŒã¿æœåºãšã¯ ããŒã¿æœåºã®ã¡ãªãããšã¿ã€ã
- Talendã®ãžã§ãèšèšãã¿ãŒã³ãšãã¹ããã©ã¯ãã£ã¹ïŒç¬¬4éšïŒ
- Talendã®ãžã§ãèšèšãã¿ãŒã³ãšãã¹ããã©ã¯ãã£ã¹ïŒç¬¬3éšïŒ
- ã¹ããªãŒãã³ã°ããŒã¿ãšã¯ïŒ
- ããŒã¿ç§»è¡ãšã¯ïŒ
- ããŒã¿ãããã³ã°ãšã¯ïŒ
- ããŒã¿ããŒã¹çµ±åãšã¯ïŒ
- ããŒã¿çµ±åãšã¯ïŒ ã€ã³ãã°ã¬ãŒã·ã§ã³ã®æŠèŠãšèª²é¡
- ããŒã¿ç§»è¡ïŒããŒã¿ãã€ã°ã¬ãŒã·ã§ã³ïŒãšã¯ïŒæŠç¥ãšãã¹ããã©ã¯ãã£ã¹
- Talendã®ãžã§ãèšèšãã¿ãŒã³ãšãã¹ããã©ã¯ãã£ã¹ïŒç¬¬1éšïŒ
- Informatica PowerCenteréçºè ã®èŠç¹ã§èããTalendã®æ©èœïŒ 第1éš