ããããSAP以å€ã®ãã§ããã°OpenSource補åãã¹ãã¬ãŒãžãšããŠäœ¿çšãå§ãããã©ããªãã§ãããããX5 RetailGroupã§ã¯GreenPlumãéžæããŸããããã¡ãããããã§ã³ã¹ãã®åé¡ã¯è§£æ±ºããŸãããåæã«ãSAP BWã䜿çšãããšãã»ãŒããã©ã«ãã§è§£æ±ºããããšããçåãããã«çºçããŸãã
ç¹ã«ãã»ãšãã©ãSAPãœãªã¥ãŒã·ã§ã³ã§ãããœãŒã¹ã·ã¹ãã ããããŒã¿ãååŸããæ¹æ³ã¯ïŒ
HR Metricsã¯ããã®åé¡ã«å¯ŸåŠããæåã®ãããžã§ã¯ãã§ãããç§ãã¡ã®ç®æšã¯ãHRããŒã¿çšã®ãŠã§ã¢ããŠã¹ãäœæããåŸæ¥å¡ãšã®äœæ¥ã®åéã§åæã¬ããŒããäœæããããšã§ããããã®å ŽåãããŒã¿ã®äž»ãªãœãŒã¹ã¯SAP HCMãã©ã³ã¶ã¯ã·ã§ã³ã·ã¹ãã ã§ããããã¹ãŠã®äººå¡ãçµç¹ãããã³çµŠäžã®æŽ»åãå®è¡ãããŸãã
ããŒã¿æœåº
SAPã·ã¹ãã çšã®SAPBWã«ã¯æšæºã®ããŒã¿æœåºæ©èœããããŸãããããã®ãšã¯ã¹ãã©ã¯ã¿ã¯ãå¿ èŠãªããŒã¿ãèªåçã«åéãããããã®æŽåæ§ã远跡ããå€æŽã®ãã«ã¿ã決å®ã§ããŸããããšãã°ãåŸæ¥å¡å±æ§ã®æšæºããŒã¿ãœãŒã¹ã¯æ¬¡ã®ãšããã§ãã0EMPLOYEE_ATTRïŒ
äžåºŠã«1人ã®åŸæ¥å¡ããã®ããŒã¿æœåºã®çµæïŒ
å¿ èŠã«å¿ããŠããã®ãããªæœåºæ©èœãç¬èªã®èŠä»¶ã«åãããŠå€æŽããããç¬èªã®æœåºæ©èœãäœæãããã§ããŸãã
æåã®ã¢ã€ãã¢ã¯ããããã®åå©çšã®å¯èœæ§ã«ã€ããŠçãŸããŸãããæ®å¿µãªãããããã¯äžå¯èœãªäœæ¥ã§ããããšãå€æããŸãããã»ãšãã©ã®ããžãã¯ã¯SAPBWåŽã§å®è£ ãããŠããããœãŒã¹ã®ãšã¯ã¹ãã©ã¯ã¿ãSAPBWããç°¡åã«åé¢ããããšã¯ã§ããŸããã§ããã
SAPã·ã¹ãã ããããŒã¿ãæœåºããããã®ã«ã¹ã¿ã ã¡ã«ããºã ãéçºããå¿ èŠãããããšãæããã«ãªããŸããã
SAPHCMã®ããŒã¿ã¹ãã¬ãŒãžæ§é
ãã®ãããªã¡ã«ããºã ã®èŠä»¶ãç解ããã«ã¯ãæåã«å¿ èŠãªããŒã¿ã®çš®é¡ã決å®ããå¿ èŠããããŸãã
SAP HCMã®ã»ãšãã©ã®ããŒã¿ã¯ããã©ãããªSQLããŒãã«ã«æ ŒçŽãããŸãããã®ããŒã¿ã«åºã¥ããŠãSAPã¢ããªã±ãŒã·ã§ã³ã¯ãçµç¹æ§é ãåŸæ¥å¡ãããã³ãã®ä»ã®HRæ å ±ããŠãŒã¶ãŒã«èŠèŠåããŸããããšãã°ãããã¯SAP HCMã§ã®çµç¹æ§é ã®å€èŠ³ã§ãã
ç©ççã«ã¯ããã®ãããªããªãŒã¯2ã€ã®ããŒãã«ïŒhrp1000ãªããžã§ã¯ããšhrp1001ïŒã«ãããã®ãªããžã§ã¯ãéã®ãªã³ã¯ã§æ ŒçŽãããŸãã
ãªããžã§ã¯ããDepartment1ããšãOffice1ãïŒ
ãªããžã§ã¯ãéã®é¢ä¿ïŒ
ãªããžã§ã¯ãã®ã¿ã€ããšãªããžã§ã¯ãéã®éä¿¡ã®ã¿ã€ãã®äž¡æ¹ãèšå€§ãªæ°ã«ãªãå¯èœæ§ããããŸãããªããžã§ã¯ãéã«ã¯æšæºã®ãªã³ã¯ããããç¹å®ã®ããŒãºã«åãããŠã«ã¹ã¿ãã€ãºãããŠããŸããããšãã°ãçµç¹åäœãšåžžå€è·ã®éã®æšæºçãªB012é¢ä¿ã¯ãéšéã®è²¬ä»»è ã瀺ããŸãã
SAPã§ã®ãããŒãžã£ãŒãããã³ã°ïŒ
DBããŒãã«ã®ã¹ãã¬ãŒãžïŒ
åŸæ¥å¡ããŒã¿ã¯pa *ããŒãã«ã«ä¿åãããŸããããšãã°ãåŸæ¥å¡ã®äººå¡é 眮ã«é¢ããããŒã¿ã¯pa0000ããŒãã«ã«ä¿åãããŸã
ãGreenPlumã¯ãçã®ãããŒã¿ãååŸããããšã決å®ããŸãããSAPããŒãã«ããããããã³ããŒããã ãã§ãããããŠããã§ã«GreenPlumã§çŽæ¥åŠçãããç©çãªããžã§ã¯ãïŒDepartmentãEmployeeãªã©ïŒãšã¡ããªãã¯ïŒå¹³å人æ°ãªã©ïŒã«å€æãããŸãã
çŽ70ã®ããŒãã«ãå®çŸ©ãããŠãããããããããŒã¿ãGreenPlumã«è»¢éããå¿ èŠããããŸãããã®åŸããã®ããŒã¿ã転éããæ¹æ³ãèãå§ããŸããã
SAPã¯ãããªãã®æ°ã®çµ±åã¡ã«ããºã ãæäŸããŠããŸãããã ããæãç°¡åãªæ¹æ³ã¯ãã©ã€ã»ã³ã¹ã®å¶éã«ãããããŒã¿ããŒã¹ãžã®çŽæ¥ã¢ã¯ã»ã¹ãçŠæ¢ãããŠããããšã§ãããããã£ãŠããã¹ãŠã®çµ±åãããŒã¯ãã¢ããªã±ãŒã·ã§ã³ãµãŒããŒã¬ãã«ã§å®è£ ããå¿ èŠããããŸãã
次ã®åé¡ã¯ãSAPããŒã¿ããŒã¹ã§åé€ãããã¬ã³ãŒãã«é¢ããããŒã¿ãäžè¶³ããŠããããšã§ãããããŒã¿ããŒã¹å ã®è¡ãåé€ããããšããã®è¡ã¯ç©ççã«åé€ãããŸããããããå€åã®æéã«ãããå€åã®ãã«ã¿ã®åœ¢æã¯äžå¯èœã§ããã
ãã¡ãããSAPHCMã«ã¯ããŒã¿å€æŽãã³ãããããããã®ã¡ã«ããºã ããããŸããããšãã°ããã®åŸã®ã·ã¹ãã ãžã®éä¿¡ã®ããã«ãåä¿¡è ã¯å€æŽãèšé²ããããã«åºã¥ããŠIdocïŒå€éšã·ã¹ãã ãžã®éä¿¡ã®ãªããžã§ã¯ãïŒã圢æãããå€æŽãã€ã³ã¿ãŒãæã£ãŠããŸãã
æ åœè çªå·1251445ã®åŸæ¥å¡ã®ã€ã³ãã©ã¿ã€ã0302ãå€æŽããããã®IDocã®äŸïŒ
ãŸãã¯ããŒãã«DBTABLOGã®ããŒã¿å€æŽãã°ãç¶æããŸãã
hrp1000ããŒãã«ããQK53216375ããŒã䜿çšããŠãšã³ããªãåé€ããããã®ãã°ã®äŸïŒ
ãã ãããããã®ã¡ã«ããºã ã¯å¿ èŠãªãã¹ãŠã®ããŒã¿ã«äœ¿çšã§ããããã§ã¯ãªããã¢ããªã±ãŒã·ã§ã³ãµãŒããŒã¬ãã«ã§ã®åŠçã¯å€ãã®ãªãœãŒã¹ãæ¶è²»ããå¯èœæ§ããããŸãããããã£ãŠãå¿ èŠãªãã¹ãŠã®ããŒãã«ã«ãã°ã倧éã«å«ãããšãã·ã¹ãã ããã©ãŒãã³ã¹ãèããäœäžããå¯èœæ§ããããŸãã
ã¯ã©ã¹ã¿ãŒåãããããŒãã«ã次ã®å€§ããªåé¡ã§ããã SAP HCMã®RDBMSããŒãžã§ã³ã®æéèŠç©ãããšçµŠäžããŒã¿ã¯ã絊äžããšã®åŸæ¥å¡ããšã®è«çããŒãã«ã®ã»ãããšããŠä¿åãããŸãããããã®è«çããŒãã«ã¯ããã€ããªããŒã¿ãšããŠpcl2ããŒãã«ã«æ ŒçŽãããŸãã
ãã€ããŒã«ã¯ã©ã¹ã¿ãŒïŒ
ã¯ã©ã¹ã¿ãŒåãããããŒãã«ã®ããŒã¿ã¯SQLã³ãã³ãã§èªã¿åãããšãã§ãããSAPHCMãã¯ããŸãã¯ç¹å¥ãªæ±çšã¢ãžã¥ãŒã«ã䜿çšããå¿ èŠããããŸãããããã£ãŠããã®ãããªããŒãã«ãèªã¿åãé床ã¯éåžžã«é ããªããŸããäžæ¹ããã®ãããªã¯ã©ã¹ã¿ãŒã«ã¯ãæã«1åã ãå¿ èŠãªããŒã¿ïŒæçµçãªçµŠäžãšæéã®èŠç©ããïŒãæ ŒçŽãããŸãããããã£ãŠããã®å Žåã®é床ã¯ããã»ã©éèŠã§ã¯ãããŸããã
ããŒã¿å€æŽã®ãã«ã¿ã®åœ¢æã䌎ããªãã·ã§ã³ãè©äŸ¡ããããã«ãå®å šãªã¢ã³ããŒãã䌎ããªãã·ã§ã³ãæ€èšããããšã«ããŸãããã®ã¬ãã€ãã®å€æŽãããŠããªãããŒã¿ãã·ã¹ãã éã§æ¯æ¥è»¢éãããªãã·ã§ã³ã¯ãèŠæ ãããããããŸããããã ããããã«ã¯ããã€ãã®å©ç¹ããããŸãããœãŒã¹åŽã§ã®ãã«ã¿ã®å®è£ ãšãã¬ã·ãŒããŒåŽã§ã®ãã®ãã«ã¿ã®åã蟌ã¿ã®å®è£ ã®äž¡æ¹ãå®è£ ããå¿ èŠã¯ãããŸããããããã£ãŠãã³ã¹ããšå®è£ æéãåæžãããçµ±åã®ä¿¡é Œæ§ãåäžããŸããåæã«ãSAP HRã®ã»ãšãã©ãã¹ãŠã®å€æŽã¯ãçŸåšã®æ¥ä»ã®3ãæåã®æéã«çºçããããšãå€æããŸããããããã£ãŠãçŸåšã®æ¥ä»ã®Nãæåã«SAP HRããã®ããŒã¿ã®æ¯æ¥ã®å®å šããŠã³ããŒããšãæ¯æã®å®å šããŠã³ããŒãã§åæ¢ããããšã決å®ãããŸããããã©ã¡ãŒã¿Nã¯ç¹å®ã®ããŒãã«ã«äŸåãã
ç¯å²ã¯1ã15ã§ãã
ããŒã¿æœåºã®ããã«ã次ã®ã¹ããŒã ãææ¡ãããŸããã
å€éšã·ã¹ãã ãèŠæ±ãçæããŠSAP HCMã«éä¿¡ããããã§ãã®èŠæ±ãããŒã¿ã®å®å šæ§ãšããŒãã«ãžã®ã¢ã¯ã»ã¹èš±å¯ã«ã€ããŠãã§ãã¯ãããŸãããã§ãã¯ãæåãããšãSAP HCMã¯ãå¿ èŠãªããŒã¿ãåéããŠFuseçµ±åãœãªã¥ãŒã·ã§ã³ã«è»¢éããããã°ã©ã ãå®è¡ããŸãã Fuseã¯ãKafkaã§å¿ èŠãªãããã¯ãå®çŸ©ããããã«ããŒã¿ãæž¡ããŸãã次ã«ãã«ãã«ããã®ããŒã¿ãã¹ããŒãžãšãªã¢GPã«è»¢éãããŸãã
ãã®ãã§ãŒã³ã®ç§ãã¡ã¯ãSAPHCMããããŒã¿ãæœåºããåé¡ã«é¢å¿ãæã£ãŠããŸãããã£ãšè©³ããèŠãŠãããŸãããã
SAPHCM-FUSEçžäºäœçšå³ã
å€éšã·ã¹ãã ã¯ãSAPãžã®æåŸã®æåããèŠæ±ã®æå»ã決å®ããŸãã
ãã®ããã»ã¹ã¯ãã¿ã€ããŒãŸãã¯ãã®ä»ã®ã€ãã³ãã«ãã£ãŠéå§ã§ããŸããããã«ã¯ãSAPããã®ããŒã¿ã«ããå¿çãåŸ æ©ããããã®ã¿ã€ã ã¢ãŠãããç¹°ãè¿ãããèŠæ±ã®éå§ãå«ãŸããŸãã次ã«ããã«ã¿ãªã¯ãšã¹ããçæããSAPã«éä¿¡ããŸãã
ãªã¯ãšã¹ãããŒã¿ã¯ãjson圢åŒã§æ¬æãšããŠæž¡ãããŸãã
httpïŒPOSTã¡ãœããã
ãµã³ãã«ãªã¯ãšã¹ãïŒ
SAPãµãŒãã¹ã¯ããªã¯ãšã¹ãã®å®å šæ§ãçŸåšã®SAPæ§é ãžã®æºæ ãããã³ãªã¯ãšã¹ããããããŒãã«ã«ã¢ã¯ã»ã¹ããããã®ã¢ã¯ã»ã¹èš±å¯ã®å¯çšæ§ããã§ãã¯ããŸãã
ãšã©ãŒãçºçããå ŽåããµãŒãã¹ã¯é©åãªã³ãŒããšèª¬æãå«ãå¿çãè¿ããŸããã³ã³ãããŒã«ãæåãããšãéžæãçæããããã®ããã¯ã°ã©ãŠã³ãããã»ã¹ãäœæãããäžæã®ã»ãã·ã§ã³IDãçæãããŠåæçã«è¿ãããŸãã
ãšã©ãŒãçºçããå Žåãå€éšã·ã¹ãã ããã°ã«èšé²ããŸããå¿çãæåããå Žåã¯ãã»ãã·ã§ã³IDãšèŠæ±ãè¡ãããããŒãã«ã®ååãéä¿¡ãããŸãã
å€éšã·ã¹ãã ã¯ãçŸåšã®ã»ãã·ã§ã³ããªãŒãã³ãšããŠç»é²ããŸãããã®ããŒãã«ã«ä»ã®ã»ãã·ã§ã³ãããå Žåã¯ãèŠåããã°ã«èšé²ãããŠéããããŸãã
SAPããã¯ã°ã©ãŠã³ããžã§ãã¯ãæå®ããããã©ã¡ãŒã¿ãšæå®ããããµã€ãºã®ããŒã¿ââãã±ããã«åŸã£ãŠã«ãŒãœã«ãçæããŸãããã±ãããµã€ãº-ããã»ã¹ãããŒã¿ããŒã¹ããèªã¿åãã¬ã³ãŒãã®æ倧æ°ãããã©ã«ãã§ã¯ã2000ãšæ³å®ãããŸãã䜿çšããããã±ãããµã€ãºãããå€ãã®ã¬ã³ãŒããããŒã¿ããŒã¹ãµã³ãã«ã«ããå Žåãæåã®ãã±ãããéä¿¡ãããåŸã察å¿ãããªãã»ãããšå¢åãã±ããçªå·ã§æ¬¡ã®ãããã¯ã圢æãããŸããçªå·ã¯1ãã€å¢å ããå³å¯ã«é çªã«éä¿¡ãããŸãã
次ã«ãSAPã¯ãã±ãããå ¥åãšããŠå€éšã·ã¹ãã WebãµãŒãã¹ã«æž¡ããŸãããããŠãããã¯çä¿¡ãã±ãããå¶åŸ¡ããã·ã¹ãã ã§ããåä¿¡ããIDã®ã»ãã·ã§ã³ã¯ã·ã¹ãã ã«ç»é²ãããŠããããªãŒãã³ç¶æ ã§ããå¿ èŠããããŸããããã±ãŒãžçªå·ã1ãã倧ããå Žåãã·ã¹ãã ã¯åã®ããã±ãŒãžïŒpackage_id-1ïŒã®æ£åžžãªåä¿¡ãèšé²ããå¿ èŠããããŸãã
å¶åŸ¡ãæåããå Žåãå€éšã·ã¹ãã ã¯ããŒãã«ããŒã¿ã解æããŠä¿åããŸãã
ããã«ãæçµãã©ã°ãããã±ãŒãžã«ååšããã·ãªã¢ã«åãæåããå Žåãçµ±åã¢ãžã¥ãŒã«ã¯ã»ãã·ã§ã³åŠçãæ£åžžã«å®äºããããšãéç¥ãããã¢ãžã¥ãŒã«ã¯ã»ãã·ã§ã³ã¹ããŒã¿ã¹ãæŽæ°ããŸãã
å¶åŸ¡/解æãšã©ãŒãçºçããå Žåããšã©ãŒã¯ãã°ã«èšé²ããããã®ã»ãã·ã§ã³ã®ãã±ããã¯å€éšã·ã¹ãã ã«ãã£ãŠæåŠãããŸãã
åæ§ã«ãéã®å Žåãå€éšã·ã¹ãã ããšã©ãŒãè¿ããšããã°ã«èšé²ããããã±ããã®éä¿¡ãåæ¢ãããŸãã
SAPHMåŽã§ããŒã¿ãèŠæ±ããããã®çµ±åãµãŒãã¹ãå®è£ ãããŸããããã®ãµãŒãã¹ã¯ãICFãã¬ãŒã ã¯ãŒã¯ïŒSAPã€ã³ã¿ãŒãããéä¿¡ãã¬ãŒã ã¯ãŒã¯-help.sap.com/viewer/6da7259a6c4b1014b7d5e759cc76fd22/7.01.22/en-US/488d6e0ea6ed72d5e10000000a42189c.htmlïŒã«å®è£ ãããŠããŸããããã«ãããç¹å®ã®ããŒãã«ã§SAPHCMã·ã¹ãã ããããŒã¿ãç §äŒã§ããŸããããŒã¿èŠæ±ãäœæãããšãã«ãå¿ èŠãªããŒã¿ãååŸããããã«ãç¹å®ã®ãã£ãŒã«ããšãã£ã«ã¿ãªã³ã°ãã©ã¡ãŒã¿ã®ãªã¹ããæå®ããããšãã§ããŸããåæã«ããµãŒãã¹ã®å®è£ ã¯ããžãã¹ããžãã¯ãæå³ãããã®ã§ã¯ãããŸããããã«ã¿ãèŠæ±ãã©ã¡ãŒã¿ãæŽåæ§å¶åŸ¡ãªã©ãèšç®ããããã®ã¢ã«ãŽãªãºã ããå€éšã·ã¹ãã åŽã«å®è£ ãããŠããŸãã
ãã®ã¡ã«ããºã ã«ãããå¿ èŠãªãã¹ãŠã®ããŒã¿ãæ°æéã§åéããŠè»¢éã§ããŸãããã®é床ã¯èš±å®¹ç¯å²å ã§ããããããã®ãœãªã¥ãŒã·ã§ã³ã¯äžæçãªãã®ãšèŠãªããããããžã§ã¯ãã§ã®æœåºããŒã«ã®å¿ èŠæ§ãã«ããŒããããšãã§ããŸããã
ããŒã¿æœåºã®åé¡ã解決ããããã®ã¿ãŒã²ããç»åã§ã¯ãOracle GoldenGateãªã©ã®CDCã·ã¹ãã ãŸãã¯SAPDSãªã©ã®ETLããŒã«ã䜿çšããããã®ãªãã·ã§ã³ãæ€èšãããŠããŸãã