Sezvaunoziva, SAP inopa huwandu hwakazara hwesoftware zvese zvekuchengetedza data rekutengesa uye nekugadzirisa iyi data mukuongorora uye kuzivisa masisitimu. Kunyanya, iyo SAP Bhizinesi Warehouse (SAP BW) chikuva chishandiso chekuchengetedza uye kuongorora data neyakakura hunyanzvi hunyanzvi. Nezvese zvakanakira chinangwa chayo, iyo SAP BW system ine imwe yakakosha drawback. Iyi ndiyo mari yakakwirira yekuchengetedza nekugadzirisa data, kunyanya kuoneka paunenge uchishandisa cloud-based SAP BW paHana.
Ko kana ukatanga kushandisa imwe isiri-SAP uye zviri nani iyo OpenSource chigadzirwa sekuchengetedza? Isu paX5 Retail Group takasarudza GreenPlum. Izvi, hongu, zvinogadzirisa nyaya yemutengo, asi panguva imwechete, nyaya dzinobva dzamuka dzakagadziriswa zvinenge nekusagadzikana pakushandisa SAP BW.
Kunyanya, nzira yekudzosa sei data kubva kune sosi masisitimu, ayo akanyanya SAP mhinduro?
HR Metrics yaive purojekiti yekutanga maive madikanwa kugadzirisa dambudziko iri. Chinangwa chedu chaive chekugadzira repository yeHR data uye kuvaka analytical reporting munzvimbo yekushanda nevashandi. Muchiitiko ichi, nheyo huru yedata ndeyeSAP HCM transactional system, umo vashandi vose, sangano uye mabasa emuhoro anoitwa.
Kutora data
MuSAP BW kune zvinyorwa zvinyorwa zvinyorwa zveSAP systems. Aya madonhwe anogona kuunganidza otomatiki data rinodiwa, kutarisa kutendeseka kwayo, uye kuona shanduko deltas. Heino, semuenzaniso, ndiyo yakajairwa data sosi yemaitiro evashandi 0EMPLOYEE_ATTR:
Mhedzisiro yekubvisa data kubva mairi kune mumwe mushandi:
Kana zvichidikanwa, dhiraivha yakadaro inogona kugadziridzwa kuti ienderane nezvinodiwa zvako kana yako wega inogona kugadzirwa.
Pfungwa yakatanga kubuda yaive mukana wekuishandisa zvakare. Zvinosuruvarisa, iri rakazova basa risingabviri. Mazhinji epfungwa anoitwa parutivi rweSAP BW, uye zvanga zvisingaite kuparadzanisa zvisinganzwisisike mudhiraivha panzvimbo kubva kuSAP BW.
Zvakava pachena kuti taizoda kuvandudza nzira yedu yekubvisa data kubva kuSAP systems.
Chimiro chekuchengetedza data muSAP HCM
Kuti tinzwisise zvinodikanwa zvemuchina wakadaro, isu chekutanga tinoda kuona kuti ndeipi data yatinoda.
Yakawanda data muSAP HCM inochengetwa mumatafura eSQL flat. Kubva pane iyi data, zvikumbiro zveSAP zvinoona zvimiro zvesangano, vashandi uye mamwe mashoko eHR kumushandisi. Semuenzaniso, izvi ndizvo zvinotaridzika sehurongwa hwesangano muSAP HCM:
Panyama, muti wakadaro unochengetwa mumatafura maviri - mu hrp1000 zvinhu uye mu hrp1001 kubatana pakati pezvinhu izvi.
Zvishandiso "Dhipatimendi 1" uye "Hofisi 1":
Ukama pakati pezvinhu:
Panogona kuve nenhamba huru yemhando mbiri dzezvinhu uye mhando dzekubatanidza pakati pavo. Kune ese ari maviri akajairwa kubatanidza pakati pezvinhu uye zvakagadziridzwa zvezvako chaizvo zvaunoda. Semuenzaniso, hukama hweB012 pakati pechikwata chesangano uye nzvimbo yenguva yakazara inoratidza mukuru wedhipatimendi.
Maneja anoratidza muSAP:
Kuchengeta mutafura yedatabase:
Data yevashandi inochengetwa mumatafura pa*. Semuenzaniso, data pamusoro pezviitiko zvevashandi kune mushandi inochengetwa patafura pa0000
Takasarudza kuti GreenPlum inotora "raw" data, i.e. ingodzikopa kubva kumatafura eSAP. Uye zvakananga muGreenPlum ivo vanozogadziriswa uye kushandurwa kuita zvinhu zvenyama (semuenzaniso, Dhipatimendi kana Mushandi) uye metrics (semuenzaniso, avhareji headcount).
Anenge matafura makumi manomwe akatsanangurwa, data kubva panofanira kuendeswa kuGreenPlum. Mushure mezvo takatanga kugadzira nzira yekufambisa iyi data.
SAP inopa nhamba yakakwana yekubatanidza nzira. Asi nzira iri nyore ndeyekuti kupinda kwakananga kune dhatabhesi kunorambidzwa nekuda kwezvirambidzo zverezinesi. Saka, kuyerera kwese kwekubatanidza kunofanirwa kuitwa padanho re server server.
Dambudziko rakatevera raive kushaikwa kwedata nezve zvakadzimwa zvinyorwa muSAP database. Paunodzima mutsara mu database, inobviswa mumuviri. Avo. kuumbwa kwekuchinja delta zvichienderana nenguva yekuchinja kwakanga kusingakwanisi.
Zvechokwadi, SAP HCM ine maitiro ekurekodha kuchinja kwedata. Semuenzaniso, kune inotevera kuendesa kune vanogamuchira masisitimu, kune shanduko inonongedza inorekodha chero shanduko uye pahwaro hweiyo Idoc inoumbwa (chinhu chekuendesa kune ekunze masisitimu).
Muenzaniso IDoc yekushandura infotype 0302 yemushandi ane nhamba yevashandi 1251445:
Kana kuchengetedza matanda e data shanduko muDBTABLOG tafura.
Muenzaniso welogi rekudzima rekodhi nekiyi QK53216375 kubva patafura yehrp1000:
Asi maitiro aya haawanikwe kune ese anodiwa data, uye mashandiro avo padanho reserver rekushandisa anogona kushandisa zviwanikwa zvakawanda. Naizvozvo, kugonesa zvakanyanya kutema matanda pamatafura ese anodiwa kunogona kutungamira kune kuoneka kuderera kwekuita kwesystem.
Dambudziko guru raitevera raive matafura akaunganidzwa. Nguva yekufungidzira uye data rekubhadhara muRDBMS shanduro yeSAP HCM inochengetwa seti yetafura inonzwisisika kune umwe neumwe mushandi pakuverenga kwega kwega. Aya matafura ane musoro anochengetwa sebhinari data mutafura pcl2.
Payroll Cluster:
Dhiyabhorosi kubva kumatafura akasanganiswa haigoni kuonekwa semurairo weSQL, asi inoda kushandiswa kweSAP HCM macros kana yakakosha basa modules. Saizvozvo, kumhanya kwekuverenga kwematafura akadaro kunenge kwakadzikira. Kune rimwe divi, masumbu akadaro anochengeta data inodiwa kamwe chete pamwedzi - yekupedzisira mubhadharo uye nguva yekufungidzira. Saka kumhanya munyaya iyi hakuna kunyanya kunetsa.
Kuongorora sarudzo dzekugadzira delta yekuchinja kwedata, isu takafunga kufunga nezve sarudzo yekuburitsa zvizere. Sarudzo yekuendesa gigabytes ye data isina kuchinjika pakati pemasisitimu zuva rega rega inogona kusataridzika zvakanaka. Nekudaro, iyo zvakare ine akati wandei mabhenefiti - hapana chikonzero chekuti mese muite delta padivi pechitubu uye kuita kunyudzwa kweiyo delta padivi rekugamuchira. Saizvozvowo, mari uye nguva yekushandisa inoderedzwa, uye kuvimbika kwekubatanidza kunowedzera. Panguva imwecheteyo, zvakatemwa kuti dzinenge shanduko dzese muSAP HR dzinoitika mukati memwedzi mitatu zuva risati rasvika. Saka, zvakasarudzwa kusarudza kurodha zuva nezuva kwakazara kwedata kubva kuSAP HR N mwedzi isati yasvika zuva razvino uye kurodha yakazara pamwedzi. Iyo N parameter inotsamira pane chaiyo tafura
uye kubva pa1 kusvika ku15.
Chirongwa chinotevera chakakurudzirwa kutorwa kwedata:
Iyo yekunze sisitimu inoburitsa chikumbiro uye inotumira kuSAP HCM, uko chikumbiro ichi chinotariswa kuzara kwedata uye mvumo yekuwana matafura. Kana cheki ichibudirira, SAP HCM inoshandisa purogiramu inounganidza data inodiwa uye inoendesa kune Fuse integration solution. Fuse inosarudza musoro unodiwa muKafka uye inoendesa iyo data ipapo. Tevere, iyo data kubva kuKafka inoendeswa kune Stage Area GP.
Muketani iyi, isu tinofarira nyaya yekubvisa data kubva kuSAP HCM. Ngatizvitarisei zvakadzama.
SAP HCM-FUSE yekudyidzana dhizaini.
Iyo yekunze system inosarudza nguva yekupedzisira yakabudirira chikumbiro kuSAP.
Iyo nzira inogona kutangwa netimer kana chimwe chiitiko, kusanganisira kuseta nguva yekumirira mhinduro nedata kubva kuSAP uye tanga chikumbiro chekudzokorora. Zvadaro inogadzira chikumbiro che delta uye inotumira kuSAP.
Iyo data yekukumbira inotumirwa kumutumbi mune json fomati.
Nzira http: POST.
Muenzaniso chikumbiro:
Basa reSAP rinotarisa chikumbiro chekukwana, kutevedzera ikozvino SAP chimiro, uye kuwanikwa kwemvumo yekuwana kune tafura yakakumbirwa.
Kana pane zvikanganiso, sevhisi inodzorera mhinduro nekodhi yakakodzera uye tsananguro. Kana kutonga kwakabudirira, inogadzira nzira yekumashure kugadzira sampuli, inogadzira uye inodzoreredza yakasarudzika chikamu id.
Kana paine chikanganiso, iyo yekunze system inonyora iyo mulog. Muchiitiko chemhinduro yakabudirira, inotumira id yechikamu uye zita retafura iyo chikumbiro chakaitwa.
Iyo yekunze sisitimu inonyoresa chikamu chazvino seyakavhurika. Kana paine mamwe masesheni etafura iyi, anovharwa neyambiro yakanyorwa.
Basa reSAP rekumashure rinogadzira cursor yakavakirwa pane yakatarwa paramita uye data packet yehukuru hwakatarwa. Saizi yeBatch ndiyo yakanyanya kuwanda yemarekodhi ayo maitiro anoverengwa kubva mudhatabhesi. Nekutadza, inofungidzirwa kuti yakaenzana ne 2000. Kana pane zvinyorwa zvakawanda mumuenzaniso wepadhesi kupfuura yakashandiswa saizi yepakiti, mushure mekutumira pepa rekutanga, bhuroka rinotevera rinoumbwa neyakafanana offset uye incremented packet number. Nhamba dzinowedzerwa ne1 uye dzinotumirwa zvakatevedzana.
Zvadaro, SAP inopfuudza pakiti sechipo kune web service yekunze system. Uye iyo system inoita zvidzoreso pane inouya packet. Chikamu chine id yakagamuchirwa inofanirwa kunyoreswa muhurongwa uye inofanirwa kunge iri munzvimbo yakavhurika. Kana iyo pasuru nhamba> 1, sisitimu inofanirwa kurekodha yakabudirira risiti yepakeji yapfuura (package_id-1).
Kana kutonga kwakabudirira, iyo yekunze system inoparadzanisa uye inochengetedza data retafura.
Pamusoro pezvo, kana mureza wekupedzisira uripo mupakeji uye kuteedzera kwakabudirira, iyo module yekubatanidza inoziviswa nezve kupedzwa kwakabudirira kwesesheni kugadzirisa uye module inovandudza mamiriro echikamu.
Muchiitiko chekutonga / kukanganisa kukanganisa, kukanganisa kwakanyorwa uye mapaketi emusangano uyu anorambwa nekunze system.
Saizvozvo, mune zvakapesana, kana iyo yekunze system ikadzosa chikanganiso, inodhindwa uye kutakura kwepaketi kunomira.
Kukumbira data padivi reSAP HΠ‘M, basa rekubatanidza rakaitwa. Iyo sevhisi inoshandiswa paICF framework (SAP Internet Communication Framework - ) Inokubvumira kuti ubvunze data kubva kuSAP HCM system uchishandisa matafura chaiwo. Paunenge uchigadzira chikumbiro che data, zvinokwanisika kutsanangura rondedzero yeminda chaiyo uye kusefa paramita kuitira kuti uwane iyo inodiwa data. Panguva imwecheteyo, kushandiswa kwebasa hakurevi chero pfungwa dzebhizimisi. Algorithms yekuverenga delta, query parameters, kutendeseka kutarisa, nezvimwe zvinoiswawo padivi rekunze system.
Iyi michina inobvumidza iwe kuunganidza uye kutumira ese anodiwa data mumaawa mashoma. Kumhanya uku kuri padanho rekugamuchirwa, saka isu tinofunga mhinduro iyi seyenguva pfupi, iyo yakaita kuti zvikwanise kuzadza kudiwa kwechishandiso chekubvisa pachirongwa.
Mumufananidzo wakanangwa, kugadzirisa dambudziko rekutora data, sarudzo dzekushandisa CDC masisitimu akadai seOracle Golden Gate kana ETL zvishandiso seSAP DS zviri kuongororwa.
Source: www.habr.com