ãåç¥ã®ãšãããSAP ã¯ãã©ã³ã¶ã¯ã·ã§ã³ ããŒã¿ã®ç®¡çãšãåæããã³ã¬ããŒã ã·ã¹ãã ã§ã®ãã®ããŒã¿ã®åŠçã®äž¡æ¹ãè¡ãããã®ãããããœãããŠã§ã¢ãæäŸããŠããŸãã ç¹ã«ãSAP Business Warehouse (SAP BW) ãã©ãããã©ãŒã ã¯ãåºç¯ãªæè¡æ©èœãåããããŒã¿ã®ä¿åãšåæã®ããã®ããŒã«ãããã§ãã SAP BW ã·ã¹ãã ã«ã¯å®¢èŠ³çãªå©ç¹ããã¹ãŠãããŸãããé倧ãªæ¬ ç¹ã XNUMX ã€ãããŸãã ããã¯ããŒã¿ã®ä¿åãšåŠçã«ãããã³ã¹ããé«ããç¹ã« Hana ã§ã¯ã©ãŠãããŒã¹ã® SAP BW ã䜿çšããå Žåã«é¡èã§ãã
SAP 以å€ã®ãã§ããã°ãªãŒãã³ãœãŒã¹è£œåãã¹ãã¬ãŒãžãšããŠäœ¿çšãå§ãããã©ããªãã§ãããã? ç§ãã¡ X5 Retail Group 㯠GreenPlum ãéžæããŸããã ãã¡ãããããã«ããã³ã¹ãã®åé¡ã¯è§£æ±ºãããŸãããåæã«ãSAP BW ã䜿çšããå Žåã¯ã»ãŒããã©ã«ãã§è§£æ±ºãããŠããåé¡ãããã«çºçããŸãã
ç¹ã«ããœãŒã¹ ã·ã¹ãã (䞻㫠SAP ãœãªã¥ãŒã·ã§ã³) ããããŒã¿ãååŸããã«ã¯ã©ãããã°ããã§ãããã?
HR Metrics ã¯ããã®åé¡ã解決ããå¿ èŠããã£ãæåã®ãããžã§ã¯ãã§ããã ç§ãã¡ã®ç®æšã¯ã人äºããŒã¿ã®ãªããžããªãäœæããåŸæ¥å¡ãšã®é£æºã®åéã§åæã¬ããŒããæ§ç¯ããããšã§ããã ãã®å ŽåãããŒã¿ã®äž»ãªãœãŒã¹ã¯ SAP HCM ãã©ã³ã¶ã¯ã·ã§ã³ ã·ã¹ãã ã§ããã人äºãçµç¹ã絊äžã®ãã¹ãŠã®æŽ»åããã®ã·ã¹ãã ã§å®è¡ãããŸãã
ããŒã¿æœåº
SAP BW ã«ã¯ãSAP ã·ã¹ãã çšã®æšæºããŒã¿æœåºããŒã«ããããŸãã ãããã®ãšã¯ã¹ãã©ã¯ã¿ãŒã¯ãå¿ èŠãªããŒã¿ãèªåçã«åéãããã®æŽåæ§ãç£èŠããå€æŽãã«ã¿ã決å®ã§ããŸãã ããšãã°ãåŸæ¥å¡å±æ§ 0EMPLOYEE_ATTR ã®æšæºããŒã¿ ãœãŒã¹ã¯æ¬¡ã®ãšããã§ãã
ãããã XNUMX 人ã®åŸæ¥å¡ã®ããŒã¿ãæœåºããçµæ:
å¿
èŠã«å¿ããŠããã®ãããªãšã¯ã¹ãã©ã¯ã¿ãŒãç¬èªã®èŠä»¶ã«åãããŠå€æŽããããç¬èªã®ãšã¯ã¹ãã©ã¯ã¿ãŒãäœæãããã§ããŸãã
æåã«æµ®ããã ã¢ã€ãã¢ã¯ãåå©çšã®å¯èœæ§ã§ããã æ®å¿µãªãããããã¯äžå¯èœãªäœæ¥ã§ããããšãå€æããŸããã ããžãã¯ã®ã»ãšãã©ã¯ SAP BW åŽã«å®è£ ãããŠããããœãŒã¹ã®ãšã¯ã¹ãã©ã¯ã¿ãŒã SAP BW ããç°¡åã«åé¢ããããšã¯ã§ããŸããã§ããã
SAP ã·ã¹ãã ããããŒã¿ãæœåºããããã®ç¬èªã®ã¡ã«ããºã ãéçºããå¿ èŠãããããšãæããã«ãªããŸããã
SAP HCM ã®ããŒã¿ ã¹ãã¬ãŒãžæ§é
ãã®ãããªã¡ã«ããºã ã®èŠä»¶ãç解ããã«ã¯ããŸãã©ã®ãããªããŒã¿ãå¿ èŠããå€æããå¿ èŠããããŸãã
SAP HCM ã®ã»ãšãã©ã®ããŒã¿ã¯ãã©ãã SQL ããŒãã«ã«ä¿åãããŸãã ãã®ããŒã¿ã«åºã¥ããŠãSAP ã¢ããªã±ãŒã·ã§ã³ã¯çµç¹æ§é ãåŸæ¥å¡ããã®ä»ã®äººäºæ å ±ããŠãŒã¶ãŒã«èŠèŠåããŸãã ããšãã°ãSAP HCM ã®çµç¹æ§é ã¯æ¬¡ã®ããã«ãªããŸãã
ç©ççã«ã¯ããã®ãããªããªãŒã¯ 1000 ã€ã®ããŒãã« (hrp1001 ãªããžã§ã¯ããš hrpXNUMX ãªããžã§ã¯ãéã®æ¥ç¶) ã«æ ŒçŽãããŸãã
ãªããžã§ã¯ããéšé 1ããšããªãã£ã¹ 1ã:
ãªããžã§ã¯ãéã®é¢ä¿:
ãªããžã§ã¯ãã®ã¿ã€ããšãããã®éã®æ¥ç¶ã®ã¿ã€ãã®äž¡æ¹ãèšå€§ãªæ°ååšããå¯èœæ§ããããŸãã ãªããžã§ã¯ãéã®æšæºæ¥ç¶ãšãç¬èªã®ããŒãºã«åãããŠã«ã¹ã¿ãã€ãºãããæ¥ç¶ã®äž¡æ¹ããããŸãã ããšãã°ãçµç¹åäœãšãã«ã¿ã€ã è·ã®éã®æšæºç㪠B012 é¢ä¿ã¯ãéšéã®è²¬ä»»è
ã瀺ããŸãã
SAP ã§ã®ãããŒãžã£ãŒã®è¡šç€º:
ããŒã¿ããŒã¹ããŒãã«å
ã®ã¹ãã¬ãŒãž:
åŸæ¥å¡ããŒã¿ã¯ pa* ããŒãã«ã«ä¿åãããŸãã ããšãã°ãåŸæ¥å¡ã®äººäºã€ãã³ãã«é¢ããããŒã¿ã¯ããŒãã« pa0000 ã«æ ŒçŽãããŸãã
ç§ãã¡ã¯ãGreenPlum ããçã®ãããŒã¿ãååŸããããšã決å®ããŸããã SAP ããŒãã«ããã³ããŒããã ãã§ãã ãããŠãGreenPlum ã§çŽæ¥åŠçãããç©ççãªãªããžã§ã¯ã (ããšãã°ãéšéãåŸæ¥å¡) ãææš (ããšãã°ãå¹³å人æ°) ã«å€æãããŸãã
çŽ 70 ã®ããŒãã«ãå®çŸ©ãããŠãããããããããŒã¿ã GreenPlum ã«è»¢éããå¿ èŠããããŸãã ãã®åŸããã®ããŒã¿ãéä¿¡ããæ¹æ³ãèæ¡ãå§ããŸããã
SAP ã¯ãããªãå€ãã®çµ±åã¡ã«ããºã ãæäŸããŠããŸãã ãã ããæãç°¡åãªæ¹æ³ã¯ãã©ã€ã»ã³ã¹å¶éã«ããããŒã¿ããŒã¹ãžã®çŽæ¥ã¢ã¯ã»ã¹ãçŠæ¢ãããŠããããšã§ãã ãããã£ãŠããã¹ãŠã®çµ±åãããŒã¯ã¢ããªã±ãŒã·ã§ã³ ãµãŒã㌠ã¬ãã«ã§å®è£
ããå¿
èŠããããŸãã
次ã®åé¡ã¯ãSAP ããŒã¿ããŒã¹å
ã®åé€ãããã¬ã³ãŒãã«é¢ããããŒã¿ã®æ¬ åŠã§ããã ããŒã¿ããŒã¹å
ã®è¡ãåé€ãããšããã®è¡ã¯ç©ççã«åé€ãããŸãã ãããã®ã å€åã®æéã«åºã¥ããŠå€åãã«ã¿ã圢æããããšã¯ã§ããŸããã§ããã
ãã¡ãããSAP HCM ã«ã¯ããŒã¿ã®å€æŽãèšé²ããã¡ã«ããºã ããããŸãã ããšãã°ããã®åŸã®åä¿¡åŽã·ã¹ãã ãžã®è»¢éã®ããã«ãå€æŽãèšé²ããå€æŽãã€ã³ã¿ããããããã«åºã¥ã㊠Idoc (å€éšã·ã¹ãã ãžã®è»¢éçšã®ãªããžã§ã¯ã) ã圢æãããŸãã
åŸæ¥å¡çªå· 0302 ã®åŸæ¥å¡ã®ã€ã³ãã©ã¿ã€ã 1251445 ãå€æŽããããã® IDoc ã®äŸ:
ãŸãã¯ãããŒã¿å€æŽã®ãã°ã DBTABLOG ããŒãã«ã«ä¿åããŸãã
hrp53216375 ããŒãã«ããã㌠QK1000 ã®ã¬ã³ãŒããåé€ãããã°ã®äŸ:
ãã ãããããã®ã¡ã«ããºã ã¯å¿
èŠãªãã¹ãŠã®ããŒã¿ã«å©çšã§ããããã§ã¯ãªããã¢ããªã±ãŒã·ã§ã³ ãµãŒã㌠ã¬ãã«ã§ã®åŠçã§ã¯å€§éã®ãªãœãŒã¹ãæ¶è²»ãããå¯èœæ§ããããŸãã ãããã£ãŠãå¿
èŠãªãã¹ãŠã®ããŒãã«ã§ãã°èšé²ã倧èŠæš¡ã«æå¹ã«ãããšãã·ã¹ãã ã®ããã©ãŒãã³ã¹ãèããäœäžããå¯èœæ§ããããŸãã
次ã®å€§ããªåé¡ã¯ãã¯ã©ã¹ã¿åãããããŒãã«ã§ããã RDBMS ããŒãžã§ã³ã® SAP HCM ã®æéèŠç©ãããã³çµŠäžããŒã¿ã¯ãèšç®ããšã«ååŸæ¥å¡ã®äžé£ã®è«çããŒãã«ãšããŠä¿åãããŸãã ãããã®è«çããŒãã«ã¯ãããŒãã« pcl2 ã«ãã€ã㪠ããŒã¿ãšããŠæ ŒçŽãããŸãã
絊äžã¯ã©ã¹ã¿:
ã¯ã©ã¹ã¿ãŒåããŒãã«ã®ããŒã¿ã¯ SQL ã³ãã³ããšèŠãªãããšãã§ããŸããããSAP HCM ãã¯ããŸãã¯ç¹å¥ãªæ©èœã¢ãžã¥ãŒã«ã䜿çšããå¿
èŠããããŸãã ãããã£ãŠããã®ãããªããŒãã«ã®èªã¿åãé床ã¯éåžžã«é
ããªããŸãã äžæ¹ããã®ãããªã¯ã©ã¹ã¿ãŒã«ã¯ãæçµçãªçµŠäžèšç®ãæéã®èŠç©ãããªã©ãæã« XNUMX åã ãå¿
èŠãªããŒã¿ãä¿åãããŸãã ãããã£ãŠããã®å Žåã®é床ã¯ããã»ã©éèŠã§ã¯ãããŸããã
ããŒã¿å€æŽã®ãã«ã¿ã圢æãããªãã·ã§ã³ãè©äŸ¡ããå®å
šãªã¢ã³ããŒãã®ãªãã·ã§ã³ãæ€èšããããšã«ããŸããã æ¯æ¥ã·ã¹ãã éã§ã®ã¬ãã€ãåäœã®å€æŽãããŠããªãããŒã¿ã転éãããšãããªãã·ã§ã³ã¯ãè¯ããã®ãšã¯æããªããããããŸããã ãã ããããã«ã¯å€ãã®å©ç¹ããããŸãããœãŒã¹åŽã§ã®ãã«ã¿ã®å®è£
ãšåä¿¡åŽã§ã®ãã®ãã«ã¿ã®åã蟌ã¿ã®äž¡æ¹ãå®è£
ããå¿
èŠããããŸããã ãããã£ãŠãã³ã¹ããšå®è£
æéãåæžãããçµ±åã®ä¿¡é Œæ§ãåäžããŸãã åæã«ãSAP HR ã®ã»ãšãã©ãã¹ãŠã®å€æŽã¯ãçŸåšã®æ¥ä»ãã XNUMX ãæ以å
ã«çºçããããšãå€æããŸããã ãããã£ãŠãçŸåšã®æ¥ä»ãã N ãæåã® SAP HR ããã®ããŒã¿ã®æ¯æ¥ã®å®å
šããŠã³ããŒããšãæ¯æã®å®å
šããŠã³ããŒããéžæããããšã決å®ãããŸããã N ãã©ã¡ãŒã¿ã¯ç¹å®ã®ããŒãã«ã«ãã£ãŠç°ãªããŸã
ç¯å²ã¯ 1 ïœ 15 ã§ãã
ããŒã¿æœåºã®ããã«æ¬¡ã®ã¹ããŒã ãææ¡ãããŸããã
å€éšã·ã¹ãã ã¯ãªã¯ãšã¹ããçæã㊠SAP HCM ã«éä¿¡ããããã§ãã®ãªã¯ãšã¹ãã®ããŒã¿ã®å®å
šæ§ãšããŒãã«ãžã®ã¢ã¯ã»ã¹æš©éããã§ãã¯ãããŸãã ãã§ãã¯ãæåãããšãSAP HCM ã¯å¿
èŠãªããŒã¿ãåéããããã Fuse çµ±åãœãªã¥ãŒã·ã§ã³ã«è»¢éããããã°ã©ã ãå®è¡ããŸãã Fuse 㯠Kafka ã§å¿
èŠãªãããã¯ã決å®ããããã«ããŒã¿ã転éããŸãã 次ã«Kafkaããã®ããŒã¿ãStage Area GPã«è»¢éããŸãã
ãã®ãã§ãŒã³ã§ã¯ãSAP HCM ããã®ããŒã¿æœåºã®åé¡ã«é¢å¿ããããŸãã ããã«è©³ããèŠãŠã¿ãŸãããã
SAP HCM-FUSE çžäºäœçšå³ã
å€éšã·ã¹ãã ã¯ãSAP ãžã®æåŸã«æåãããªã¯ãšã¹ãã®æå»ãå€æããŸãã
ãã®ããã»ã¹ã¯ãSAP ããã®ããŒã¿ã«ããå¿çãåŸ
æ©ããŠç¹°ãè¿ããªã¯ãšã¹ããéå§ããã¿ã€ã ã¢ãŠãã®èšå®ãªã©ãã¿ã€ããŒãŸãã¯ãã®ä»ã®ã€ãã³ãã«ãã£ãŠèµ·åã§ããŸãã 次ã«ããã«ã¿ãªã¯ãšã¹ããçæããSAP ã«éä¿¡ããŸãã
ãªã¯ãšã¹ãããŒã¿ã¯json圢åŒã§bodyã«éä¿¡ãããŸãã
ã¡ãœãã http: POSTã
ãªã¯ãšã¹ãã®äŸ:
SAP ãµãŒãã¹ã¯ããªã¯ãšã¹ãã®å®å
šæ§ãçŸåšã® SAP æ§é ãžã®æºæ ãããã³ãªã¯ãšã¹ããããããŒãã«ãžã®ã¢ã¯ã»ã¹èš±å¯ã®å¯çšæ§ãç£èŠããŸãã
ãšã©ãŒãçºçããå ŽåããµãŒãã¹ã¯é©åãªã³ãŒããšèª¬æãå«ãå¿çãè¿ããŸãã å¶åŸ¡ãæåãããšããµã³ãã«ãçæããããã¯ã°ã©ãŠã³ã ããã»ã¹ãäœæãããäžæã®ã»ãã·ã§ã³ ID ãçæãããŠåæçã«è¿ãããŸãã
ãšã©ãŒãçºçããå Žåãå€éšã·ã¹ãã ã¯ããããã°ã«èšé²ããŸãã å¿çãæåããå Žåãã»ãã·ã§ã³ ID ãšèŠæ±ãè¡ãããããŒãã«ã®ååãéä¿¡ãããŸãã
å€éšã·ã¹ãã ã¯ãçŸåšã®ã»ãã·ã§ã³ããªãŒãã³ãšããŠç»é²ããŸãã ãã®ããŒãã«ã«ä»ã®ã»ãã·ã§ã³ãããå Žåã¯ãèŠåããã°ã«èšé²ãããŠéããããŸãã
SAP ããã¯ã°ã©ãŠã³ã ãžã§ãã¯ãæå®ããããã©ã¡ãŒã¿ãšæå®ããããµã€ãºã®ããŒã¿ââ ãã±ããã«åºã¥ããŠã«ãŒãœã«ãçæããŸãã ããã ãµã€ãºã¯ãããã»ã¹ãããŒã¿ããŒã¹ããèªã¿åãã¬ã³ãŒãã®æ倧æ°ã§ãã ããã©ã«ãã§ã¯ããã㯠2000 ã§ãããšæ³å®ãããŸããããŒã¿ããŒã¹ ãµã³ãã«ã«äœ¿çšããããã±ãã ãµã€ãºããå€ãã®ã¬ã³ãŒããããå Žåãæåã®ãã±ããã®éä¿¡åŸã察å¿ãããªãã»ãããšã€ã³ã¯ãªã¡ã³ãããããã±ããçªå·ã䜿çšããŠæ¬¡ã®ãããã¯ã圢æãããŸãã æ°å€ã¯ 1 ãã€å¢åãããå³å¯ã«é çªã«éä¿¡ãããŸãã
次ã«ãSAP ã¯ãã±ãããå ¥åãšããŠå€éšã·ã¹ãã ã® Web ãµãŒãã¹ã«æž¡ããŸãã ãããŠãã·ã¹ãã ã¯åä¿¡ãã±ããã®å¶åŸ¡ãå®è¡ããŸãã åä¿¡ãã ID ã®ã»ãã·ã§ã³ãã·ã¹ãã ã«ç»é²ãããŠããããªãŒãã³ç¶æ ã§ããå¿ èŠããããŸãã ããã±ãŒãžçªå· > 1 ã®å Žåãã·ã¹ãã ã¯åã®ããã±ãŒãž (package_id-1) ã®æ£åžžãªåä¿¡ãèšé²ããå¿ èŠããããŸãã
å¶åŸ¡ãæåãããšãå€éšã·ã¹ãã ã¯ããŒãã« ããŒã¿ã解æããŠä¿åããŸãã
ããã«ãæçµãã©ã°ãããã±ãŒãžå ã«ååšããã·ãªã¢ã«åãæåããå Žåã¯ãçµ±åã¢ãžã¥ãŒã«ã«ã»ãã·ã§ã³åŠçãæ£åžžã«å®äºããããšãéç¥ãããã¢ãžã¥ãŒã«ã¯ã»ãã·ã§ã³ ã¹ããŒã¿ã¹ãæŽæ°ããŸãã
å¶åŸ¡/解æãšã©ãŒãçºçããå Žåããšã©ãŒããã°ã«èšé²ããããã®ã»ãã·ã§ã³ã®ãã±ããã¯å€éšã·ã¹ãã ã«ãã£ãŠæåŠãããŸãã
åæ§ã«ãéã®å Žåãå€éšã·ã¹ãã ããšã©ãŒãè¿ããšãããããã°ã«èšé²ããããã±ããéä¿¡ãåæ¢ããŸãã
SAP HСM åŽã§ããŒã¿ãèŠæ±ããããã«ãçµ±åãµãŒãã¹ãå®è£
ãããŸããã ãã®ãµãŒãã¹ã¯ãICF ãã¬ãŒã ã¯ãŒã¯ (SAP Internet Communication Framework -
ãã®ã¡ã«ããºã ã«ãããå¿
èŠãªããŒã¿ããã¹ãŠæ°æéã§åéããŠéä¿¡ã§ããŸãã ãã®é床ã¯èš±å®¹ç¯å²å
ã«ããããããã®ãœãªã¥ãŒã·ã§ã³ã¯ãããžã§ã¯ãã§ã®æœåºããŒã«ã®å¿
èŠæ§ãæºããããšãã§ããäžæçãªãœãªã¥ãŒã·ã§ã³ã§ãããšèããããŸãã
ç®æšãšããç¶æ³ã§ã¯ãããŒã¿æœåºã®åé¡ã解決ããããã«ãOracle Golden Gate ãªã©ã® CDC ã·ã¹ãã ã SAP DS ãªã©ã® ETL ããŒã«ã䜿çšãããªãã·ã§ã³ãæ€èšãããŠããŸãã
åºæïŒ habr.com