{"id":95021,"date":"2020-09-24T19:42:23","date_gmt":"2020-09-24T17:42:23","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh"},"modified":"2020-09-24T19:42:23","modified_gmt":"2020-09-24T17:42:23","slug":"ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh","title":{"rendered":"Ekstraktimi i t\u00eb dh\u00ebnave nga SAP HCM n\u00eb depo t\u00eb dh\u00ebnash non-SAP","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Si \u00ebsht\u00eb e njohur, kompania SAP ofron nj\u00eb gam\u00eb t\u00eb plot\u00eb t\u00eb softuer\u00ebve, si p\u00ebr menaxhimin e t\u00eb dh\u00ebnave transaksionale, ashtu edhe p\u00ebr p\u00ebrpunimin e k\u00ebtyre t\u00eb dh\u00ebnave n\u00eb sistemet e analiz\u00ebs dhe raportimit. N\u00eb ve\u00e7anti, platforma SAP Business Warehouse (SAP BW) \u00ebsht\u00eb nj\u00eb mjete p\u00ebr ruajtjen dhe analizimin e t\u00eb dh\u00ebnave, e cila ka mund\u00ebsi t\u00eb gjera teknike. Megjith\u00eb t\u00eb gjitha avantazheve t\u00eb saj objektive, sistemi SAP BW ka nj\u00eb disavantazh t\u00eb r\u00ebnd\u00ebsish\u00ebm. Kjo \u00ebsht\u00eb kostoja e lart\u00eb e ruajtjes dhe p\u00ebrpunimit t\u00eb t\u00eb dh\u00ebnave, e cila \u00ebsht\u00eb ve\u00e7an\u00ebrisht e dukshme gjat\u00eb p\u00ebrdorimit t\u00eb SAP BW on Hana n\u00eb re. <\/p>\n

Po \u00e7far\u00eb n\u00ebse t\u00eb fillojm\u00eb t\u00eb p\u00ebrdorim nj\u00eb produkt tjet\u00ebr p\u00ebr ruajtje, ndoshta non-SAP dhe idealisht nj\u00eb produkt OpenSource? Ne n\u00eb X5 Retail Group e kemi zgjedhur GreenPlum. Kjo sigurisht zgjidh problemin e kostos, por menj\u00ebher\u00eb lindin pyetje q\u00eb me p\u00ebrdorimin e SAP BW zgjidhen praktikisht nga vet\u00eb default-i.<\/p>\n

\"Ekstraktimi
\n<\/a><\/noindex>
\nVe\u00e7an\u00ebrisht, si do t\u00eb marrim t\u00eb dh\u00ebnat nga sistemet burim, t\u00eb cilat n\u00eb shumic\u00ebn e rasteve jan\u00eb zgjidhje SAP?<\/p>\n

\u00abHR-metrikat\u00bb ishte projekti i par\u00eb n\u00eb t\u00eb cilin duhej t\u00eb zgjidheshin k\u00ebto probleme. Q\u00ebllimi yn\u00eb ishte krijimi i nj\u00eb depo t\u00eb t\u00eb dh\u00ebnave HR dhe nd\u00ebrtimi i raportimit analitik n\u00eb lidhje me pun\u00ebn me punonj\u00ebsit. Burimi kryesor i t\u00eb dh\u00ebnave \u00ebsht\u00eb sistemi transaksional SAP HCM, i cili regjistron t\u00eb gjitha aktivitetet e pun\u00ebs, organizat\u00ebs dhe pagave. <\/p>\n

Ekstraktimi i t\u00eb dh\u00ebnave<\/h3>\n

\nN\u00eb SAP BW p\u00ebr sistemet SAP ekzistojn\u00eb ekstraktues standard t\u00eb t\u00eb dh\u00ebnave. K\u00ebta ekstraktues mund t\u00eb mbledhin automatikisht t\u00eb dh\u00ebnat e nevojshme, t\u00eb ndjekin integritetin e tyre dhe t\u00eb p\u00ebrcaktojn\u00eb delta t\u00eb ndryshimeve. Ja, p\u00ebr shembull, burimi standard i t\u00eb dh\u00ebnave p\u00ebr atributet e punonj\u00ebsve 0EMPLOYEE_ATTR:<\/p>\n

\"Ekstraktimi
\n
\nRezultati i ekstraktimit t\u00eb t\u00eb dh\u00ebnave nga ai p\u00ebr nj\u00eb punonj\u00ebs:<\/p>\n

\"Ekstraktimi
\n
\nN\u00ebse \u00ebsht\u00eb e nevojshme, ky ekstraktues mund t\u00eb modifikohet sipas k\u00ebrkesave t\u00eb veta ose mund t\u00eb krijohet nj\u00eb ekstraktues i vet\u00eb. <\/p>\n

Ideja p\u00ebr rip\u00ebrdorimin e tyre erdhi e para. Fatkeq\u00ebsisht, kjo u d\u00ebshmua t\u00eb ishte nj\u00eb detyr\u00eb e paarritshme. Shumica e logjik\u00ebs \u00ebsht\u00eb realizuar n\u00eb an\u00ebn e SAP BW, dhe nuk arrit\u00ebm t\u00eb ndanim pa dhembshuri ekstraktuesin n\u00eb burim nga SAP BW. <\/p>\n

Ka qen\u00eb e qart\u00eb se do t\u00eb nevojitej zhvillimi i nj\u00eb mekanizmi p\u00ebr nxjerrjen e t\u00eb dh\u00ebnave nga sistemet SAP. <\/p>\n

Struktura e ruajtjes s\u00eb t\u00eb dh\u00ebnave n\u00eb SAP HCM<\/h3>\n

\nP\u00ebr t\u00eb kuptuar k\u00ebrkesat p\u00ebr nj\u00eb mekaniz\u00ebm t\u00eb till\u00eb, fillimisht duhet t\u00eb p\u00ebrcaktojm\u00eb se cilat t\u00eb dh\u00ebna na nevojiten.<\/p>\n

Shumica e t\u00eb dh\u00ebnave n\u00eb SAP HCM ruhet n\u00eb tabela SQL t\u00eb sheshta. Bazuar n\u00eb k\u00ebto t\u00eb dh\u00ebna, aplikacionet SAP vizualizojn\u00eb p\u00ebr p\u00ebrdoruesin strukturat organizative, punonj\u00ebsit dhe informacione t\u00eb tjera HR. P\u00ebr shembull, ja si duket struktura organizative n\u00eb SAP HCM:<\/p>\n

\"Ekstraktimi
\n
\nFizikisht, kjo pem\u00eb ruhet n\u00eb dy tabela \u2014 n\u00eb hrp1000 objekti dhe n\u00eb hrp1001 lidhjet midis k\u00ebtyre objekteve. <\/p>\n

Objektet \"Departamenti 1\" dhe \"Menaxhimi 1\":<\/p>\n

\"Ekstraktimi
\n
\nLidhja midis objekteve:<\/p>\n

\"Ekstraktimi
\n
\nKa shum\u00eb lloje objektesh si dhe lloje lidhjesh midis tyre. Ekzistojn\u00eb lidhje standarde midis objekteve dhe t\u00eb personalizuara p\u00ebr nevojat specifike. P\u00ebr shembull, lidhja standarde B012 midis nj\u00eb nj\u00ebsie organizative dhe nj\u00eb pozite t\u00eb caktuar tregon p\u00ebr udh\u00ebheq\u00ebsin e nj\u00eb n\u00ebnshtet\u00ebsie.<\/p>\n

Paraqitja e udh\u00ebheq\u00ebsit n\u00eb SAP:<\/p>\n

\"Ekstraktimi
\n
\nRuajtja n\u00eb tabel\u00ebn e DB:<\/p>\n

\"Ekstraktimi
\n
\nT\u00eb dh\u00ebnat p\u00ebr punonj\u00ebsit ruhen n\u00eb tabela pa*. P.sh., t\u00eb dh\u00ebnat p\u00ebr ngjarjet kadrovike p\u00ebr punonj\u00ebsin ruhen n\u00eb tabel\u00ebn pa0000.<\/p>\n

\"Ekstraktimi
\n
\nNe vendos\u00ebm q\u00eb GreenPlum do t\u00eb merret me t\u00eb dh\u00ebna \"t\u00eb pap\u00ebrpunuara\", pra do t'i kopjoj\u00eb ato nga tabelat SAP. Dhe pastaj n\u00eb GreenPlum do t\u00eb p\u00ebrpunohen dhe konvertohen n\u00eb objekte fizike (p.sh., Departamenti ose Punonj\u00ebsi) dhe metrika (p.sh., numri mesatar i punonj\u00ebsve).<\/p>\n

U p\u00ebrcaktuan rreth 70 tabela, t\u00eb dh\u00ebnat nga t\u00eb cilat duhet t\u00eb d\u00ebrgohen n\u00eb GreenPlum. M\u00eb pas, ne filluam t\u00eb punojm\u00eb mbi m\u00ebnyr\u00ebn e transferimit t\u00eb k\u00ebtyre t\u00eb dh\u00ebnave.<\/p>\n

SAP ofron nj\u00eb num\u00ebr t\u00eb konsideruesh\u00ebm mekanizmash integrimi. Por m\u00ebnyra m\u00eb e thjesht\u00eb \u2013 qasja direkte n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave \u00ebsht\u00eb e ndaluar p\u00ebr shkak t\u00eb kufizimeve t\u00eb licenc\u00ebs. K\u00ebshtu, t\u00eb gjitha fluxet e integrimit duhet t\u00eb ken\u00eb vendosje n\u00eb nivelin serverit<\/a> e aplikacioneve.
\nProblemi tjet\u00ebr ishte mungesa e t\u00eb dh\u00ebnave p\u00ebr regjistrat e fshir\u00eb n\u00eb DB SAP. Kur nj\u00eb rresht fshihet n\u00eb DB, ai fshihet fizikisht. Pra, formimi i diferenc\u00ebs s\u00eb ndryshimeve sipas koh\u00ebs s\u00eb ndryshimit nuk ishte i mundur.<\/p>\n

Sigurisht, n\u00eb SAP HCM ka mekanizma p\u00ebr regjistrimin e ndryshimeve t\u00eb t\u00eb dh\u00ebnave. P\u00ebr shembull, p\u00ebr transferimin n\u00eb sistemet e marr\u00ebsve, ekzistojn\u00eb tregues ndryshimesh (change pointer), t\u00eb cil\u00ebt regjistrojn\u00eb \u00e7do ndryshim dhe n\u00eb baz\u00eb t\u00eb t\u00eb cil\u00ebve formohen IDoc (objekti p\u00ebr transferim n\u00eb sisteme t\u00eb jashtme).<\/p>\n

Shembulli i IDoc p\u00ebr ndryshimin e infotypes 0302 p\u00ebr punonj\u00ebsin me numrin e regjistrimit 1251445:<\/p>\n

\"Ekstraktimi
\n
\nOse mbajtja e logjeve t\u00eb ndryshimeve t\u00eb t\u00eb dh\u00ebnave n\u00eb tabel\u00ebn DBTABLOG.<\/p>\n

Shembulli i logut t\u00eb fshirjes s\u00eb nj\u00eb shenimi me \u00e7el\u00ebsin QK53216375 nga tabela hrp1000:<\/p>\n

\"Ekstraktimi
\n
\nPor k\u00ebta mekanizma nuk jan\u00eb t\u00eb disponuesh\u00ebm p\u00ebr t\u00eb gjitha t\u00eb dh\u00ebnat e nevojshme dhe procesimi i tyre n\u00eb nivelin e serverit t\u00eb aplikacioneve mund t\u00eb konsumoj\u00eb shum\u00eb burime. Prandaj, aktivizimi masiv i logimit p\u00ebr t\u00eb gjitha tabelat e nevojshme mund t\u00eb \u00e7oj\u00eb n\u00eb nj\u00eb degradim t\u00eb duksh\u00ebm t\u00eb performanc\u00ebs s\u00eb sistemit. <\/p>\n

Problemi tjet\u00ebr serioz ishin tabelat klaster. T\u00eb dh\u00ebnat e vler\u00ebsimeve t\u00eb koh\u00ebs dhe llogaritjes s\u00eb pag\u00ebs n\u00eb versionin RDBMS t\u00eb SAP HCM ruhen si nj\u00eb set tabelash logjike p\u00ebr secilin punonj\u00ebs p\u00ebr \u00e7do llogaritje. K\u00ebto tabela logjike ruhet n\u00eb form\u00ebn e t\u00eb dh\u00ebnave binare n\u00eb tabel\u00ebn pcl2.<\/p>\n

Klasteri i llogaritjes s\u00eb pag\u00ebs:<\/p>\n

\"Ekstraktimi
\n
\nT\u00eb dh\u00ebnat nga tabelat e grupeve nuk mund t\u00eb lexohen me komand\u00ebn SQL, prandaj k\u00ebrkohet p\u00ebrdorimi i makro-komandave SAP HCM ose moduleve funksionale speciale. Si rezultat, shpejt\u00ebsia e leximit t\u00eb k\u00ebtyre tabelave do t\u00eb jet\u00eb mjaft e ul\u00ebt. N\u00eb an\u00ebn tjet\u00ebr, n\u00eb k\u00ebto grupe ruhet informacioni q\u00eb nevojitet vet\u00ebm nj\u00eb her\u00eb n\u00eb muaj \u2013 llogaritja p\u00ebrfundimtare e pag\u00ebs dhe vler\u00ebsimi i koh\u00ebs. Prandaj, shpejt\u00ebsia n\u00eb k\u00ebt\u00eb rast nuk \u00ebsht\u00eb aq kritike. <\/p>\n

Duke vler\u00ebsimit t\u00eb mund\u00ebsive p\u00ebr krijimin e delt\u00ebs s\u00eb ndryshimit t\u00eb t\u00eb dh\u00ebnave, vendos\u00ebm t\u00eb shqyrtojm\u00eb edhe mund\u00ebsin\u00eb e shkarkimit t\u00eb plot\u00eb. Opsioni p\u00ebr t\u00eb transferuar \u00e7do dit\u00eb gigabajt t\u00eb dh\u00ebnash t\u00eb pandryshueshme midis sistemeve nuk mund t\u00eb duket t\u00ebrheq\u00ebs. Megjithat\u00eb, ai ka disa avantazhe - nuk \u00ebsht\u00eb e nevojshme t\u00eb implementohet delta n\u00eb an\u00ebn e burimit, as implementimi i integrimit t\u00eb k\u00ebsaj delte n\u00eb an\u00ebn e marr\u00ebsit. Si rezultat, reduktohen kostot dhe afatet e realizimit, dhe rritet besueshm\u00ebria e integrimit. Megjithat\u00eb, u p\u00ebrcaktua se pothuajse t\u00eb gjitha ndryshimet n\u00eb SAP HR ndodhin n\u00eb horizontin e tre muajve deri n\u00eb dat\u00ebn aktuale. Prandaj, u mor vendimi p\u00ebr t\u00eb mbetur me shkarkimin e plot\u00eb t\u00eb t\u00eb dh\u00ebnave nga SAP HR \u00e7do dit\u00eb p\u00ebr N muaj para dat\u00ebs aktuale dhe nj\u00eb shkarkim t\u00eb plot\u00eb mujor. Parametri N varet nga tabela specifike.
\n dhe varion nga 1 n\u00eb 15.<\/p>\n

P\u00ebr ekstraktimin e t\u00eb dh\u00ebnave u propozua skema e m\u00ebposhtme:<\/p>\n

\"Ekstraktimi
\n
\nSistemi i jasht\u00ebm krijon nj\u00eb k\u00ebrkes\u00eb dhe e d\u00ebrgon at\u00eb n\u00eb SAP HCM, ku kjo k\u00ebrkes\u00eb kontrollohet p\u00ebr plot\u00ebsin\u00eb e t\u00eb dh\u00ebnave dhe p\u00ebr autorizimin p\u00ebr akses n\u00eb tabela. N\u00eb rastin e verifikimit t\u00eb suksessh\u00ebm, n\u00eb SAP HCM ekzekutohet nj\u00eb program q\u00eb mbledh t\u00eb dh\u00ebnat e nevojshme dhe i transmeton ato n\u00eb zgjidhjen integruese Fuse. Fuse p\u00ebrcakton tem\u00ebn e nevojshme n\u00eb Kafka dhe e d\u00ebrgon atje. M\u00eb pas, t\u00eb dh\u00ebnat nga Kafka d\u00ebrgohen n\u00eb Stage Area GP.<\/p>\n

N\u00eb k\u00ebt\u00eb zinxhir na intereson \u00e7\u00ebshtja e nxjerrjes s\u00eb t\u00eb dh\u00ebnave nga SAP HCM. Le t\u00eb ndalojm\u00eb n\u00eb k\u00ebt\u00eb m\u00eb shum\u00eb. <\/p>\n

Schema e bashk\u00ebpunimit SAP HCM-FUSE.<\/p>\n

\"Ekstraktimi
\n
\nSistemi i jasht\u00ebm p\u00ebrcakton koh\u00ebn e k\u00ebrkes\u00ebs s\u00eb fundit t\u00eb suksesshme n\u00eb SAP.
\nProcesi mund t\u00eb nis\u00eb nga nj\u00eb timer ose ngjarje tjet\u00ebr, duke p\u00ebrfshir\u00eb gjithashtu mund\u00ebsin\u00eb e vendosjes s\u00eb nj\u00eb koh\u00eb pritjeje p\u00ebr p\u00ebrgjigjen me t\u00eb dh\u00ebna nga SAP dhe iniciimin e nj\u00eb k\u00ebrkese t\u00eb p\u00ebrs\u00ebritur. Pas k\u00ebsaj, formulohet nj\u00eb k\u00ebrkes\u00eb p\u00ebr ndryshimin dhe d\u00ebrgohet n\u00eb SAP.<\/p>\n

T\u00eb dh\u00ebnat e k\u00ebrkes\u00ebs d\u00ebrgohen n\u00eb body n\u00eb formatin json.
\nMetoda http: POST.
\nShembulli i k\u00ebrkes\u00ebs:<\/p>\n

\"Ekstraktimi
\n
\nSh\u00ebrbimi SAP kryen kontrollin e k\u00ebrkes\u00ebs p\u00ebr plot\u00ebsin\u00eb, p\u00ebrputhshm\u00ebrin\u00eb me struktur\u00ebn aktuale t\u00eb SAP, dhe munges\u00ebn e autorizimit p\u00ebr akses n\u00eb tabel\u00ebn e k\u00ebrkuar. <\/p>\n

N\u00eb rast gabimesh, sh\u00ebrbimi kthen nj\u00eb p\u00ebrgjigje me kodin dhe p\u00ebrshkrimin p\u00ebrkat\u00ebs. N\u00eb rast t\u00eb nj\u00eb kontrolli t\u00eb suksessh\u00ebm, krijon nj\u00eb proces n\u00eb sfond p\u00ebr t\u00eb formuar mostr\u00ebn, gjeneron dhe kthen nj\u00eb id unik seance n\u00eb m\u00ebnyr\u00eb sinkrone. <\/p>\n

Sistemi i jasht\u00ebm, n\u00eb rast gabimi, e regjistron at\u00eb n\u00eb regjist\u00ebr. N\u00eb rast t\u00eb nj\u00eb p\u00ebrgjigjeje t\u00eb suksesshme, transmeton id e seanc\u00ebs dhe emrin e tabel\u00ebs p\u00ebr t\u00eb cil\u00ebn \u00ebsht\u00eb b\u00ebr\u00eb k\u00ebrkesa.<\/p>\n

Sistemi i jasht\u00ebm regjistron seanc\u00ebn aktuale si t\u00eb hapur. N\u00ebse ka seanca t\u00eb tjera p\u00ebr k\u00ebt\u00eb tabel\u00eb, ato mbyllen me regjistrimin e nj\u00eb paralajm\u00ebrimi n\u00eb regjist\u00ebr.<\/p>\n

Detyra n\u00eb sfond SAP formon nj\u00eb kursator sipas parametrave t\u00eb caktuar dhe nj\u00eb paket\u00eb t\u00eb dh\u00ebnash t\u00eb madh\u00ebsis\u00eb s\u00eb caktuar. Madh\u00ebsia e paket\u00ebs \u2013 numri maksimal i regjistrimeve q\u00eb procesi lexon nga Baza e t\u00eb Dh\u00ebnave. N\u00eb parazgjedhje, ky num\u00ebr merret si i barabart\u00eb me 2000. N\u00ebse n\u00eb mostr\u00ebn e Bazeve t\u00eb Dh\u00ebnash ka m\u00eb shum\u00eb regjistrime sesa madh\u00ebsia e paket\u00ebs s\u00eb p\u00ebrdorur, pas d\u00ebrgimit t\u00eb paket\u00ebs s\u00eb par\u00eb formohet blloku tjet\u00ebr me offsetin p\u00ebrkat\u00ebs dhe numrin e paket\u00ebs t\u00eb inkrementuar. Numrat inkrementohen me 1 dhe d\u00ebrgohen n\u00eb m\u00ebnyr\u00eb strikt t\u00eb rregullt. <\/p>\n

M\u00eb pas, SAP d\u00ebrgon paket\u00ebn n\u00eb sh\u00ebrbimin web t\u00eb sistemit t\u00eb jasht\u00ebm. Ky sistem kryen kontrollin e paket\u00ebs s\u00eb ardhur. N\u00eb sistem duhet t\u00eb jet\u00eb regjistruar nj\u00eb seanc\u00eb me id-n\u00eb e marr\u00eb dhe duhet t\u00eb jet\u00eb n\u00eb status t\u00eb hapur. N\u00ebse numri i paket\u00ebs \u00ebsht\u00eb > 1, n\u00eb sistem duhet t\u00eb jet\u00eb regjistruar marrja e suksesshme e paket\u00ebs s\u00eb m\u00ebparshme (package_id-1).<\/p>\n

N\u00eb rastin e kontrollit t\u00eb suksessh\u00ebm, sistemi i jasht\u00ebm parse dhe ruan t\u00eb dh\u00ebnat e tabel\u00ebs.<\/p>\n

P\u00ebr m\u00eb tep\u00ebr, n\u00ebse n\u00eb paket\u00eb ka nj\u00eb flamur final dhe serializimi ka p\u00ebrfunduar me sukses, njoftohet moduli i integrimit mbi p\u00ebrfundimin e suksessh\u00ebm t\u00eb trajtimit t\u00eb seanc\u00ebs dhe moduli p\u00ebrdit\u00ebson statusin e seanc\u00ebs.<\/p>\n

N\u00eb rast t\u00eb nj\u00eb gabimi n\u00eb kontrolle\/parse, gabimi regjistrohet dhe paketat p\u00ebr k\u00ebt\u00eb seanc\u00eb do t\u00eb refuzohen nga sistemi i jasht\u00ebm.<\/p>\n

Po ashtu, n\u00eb rastin e kund\u00ebrt, kur sistemi i jasht\u00ebm kthen nj\u00eb gabim, ai regjistrohet dhe ndalohet d\u00ebrgimi i paketave.<\/p>\n

P\u00ebr k\u00ebrkesat e t\u00eb dh\u00ebnave nga ana e SAP HCM \u00ebsht\u00eb realizuar nj\u00eb sh\u00ebrbim integrimi. Sh\u00ebrbimi \u00ebsht\u00eb realizuar mbi framework-un ICF (SAP Internet Communication Framework \u2014 help.sap.com\/viewer\/6da7259a6c4b1014b7d5e759cc76fd22\/7.01.22\/en-US\/488d6e0ea6ed72d5e10000000a42189c.html<\/a><\/noindex>). Ai lejon mund\u00ebsi p\u00ebr t\u00eb k\u00ebrkoni t\u00eb dh\u00ebna nga sistemi SAP HCM nga tabela t\u00eb caktuara. Kur formohet k\u00ebrkesa p\u00ebr t\u00eb dh\u00ebna, ekziston mund\u00ebsia p\u00ebr t\u00eb caktuar nj\u00eb list\u00eb t\u00eb fushave specifike dhe parametrave t\u00eb filtrimit p\u00ebr t\u00eb marr\u00eb t\u00eb dh\u00ebnat e nevojshme. Sidoqoft\u00eb, realizimi i sh\u00ebrbimit nuk parashikon asnj\u00eb logjik\u00eb biznesi. Algoritmet e llogaritjes s\u00eb deltas, parametrave t\u00eb k\u00ebrkes\u00ebs, kontrollit t\u00eb integritetit, etj. gjithashtu realizohen n\u00eb an\u00ebn e sistemit t\u00eb jasht\u00ebm.<\/p>\n

Ky mekaniz\u00ebm lejon grumbullimin dhe transmetimin e t\u00eb gjitha t\u00eb dh\u00ebnave t\u00eb nevojshme brenda disa or\u00ebsh. Kjo shpejt\u00ebsi \u00ebsht\u00eb n\u00eb kufirin e pranuesh\u00ebm, prandaj ky zgjidhje konsiderohet nga ne si e p\u00ebrkohshme, e cila ka lejuar mbylljen e nevoj\u00ebs p\u00ebr nj\u00eb mjet nxjerrjeje n\u00eb projekt.
\nN\u00eb vizionin synues p\u00ebr zgjidhjen e detyr\u00ebs s\u00eb nxjerrjes s\u00eb t\u00eb dh\u00ebnave, po shqyrtohen opsionet e p\u00ebrdorimit t\u00eb sistemeve CDC si Oracle Golden Gate ose mjeteve ETL si SAP DS.
\n
Burimi: habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e, \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u044f SAP \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442 \u043f\u043e\u043b\u043d\u044b\u0439 \u0441\u043f\u0435\u043a\u0442\u0440 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u043e\u0433\u043e \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u044f, \u043a\u0430\u043a \u0434\u043b\u044f \u0432\u0435\u0434\u0435\u043d\u0438\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445, \u0442\u0430\u043a \u0438 \u0434\u043b\u044f \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u044d\u0442\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438 \u043e\u0442\u0447\u0435\u0442\u043d\u043e\u0441\u0442\u0438. \u0412 \u0447\u0430\u0441\u0442\u043d\u043e\u0441\u0442\u0438 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 SAP Business Warehouse (SAP BW) \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0431\u043e\u0439 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438 \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0434\u0430\u043d\u043d\u044b\u0445, \u043e\u0431\u043b\u0430\u0434\u0430\u044e\u0449\u0438\u0439 \u0448\u0438\u0440\u043e\u043a\u0438\u043c\u0438 \u0442\u0435\u0445\u043d\u0438\u0447\u0435\u0441\u043a\u0438\u043c\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c\u0438. \u041f\u0440\u0438 \u0432\u0441\u0435\u0445 \u0441\u0432\u043e\u0438\u0445 \u043e\u0431\u044a\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u043f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0430\u0445 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 SAP BW \u043e\u0431\u043b\u0430\u0434\u0430\u0435\u0442 \u043e\u0434\u043d\u0438\u043c […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":95022,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-95021","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Ekstraktimi i t\u00eb dh\u00ebnave nga SAP HCM n\u00eb depo t\u00eb dh\u00ebnash jo-SAP | ProHoster","description":"Si e dihet, kompania SAP ofron nj\u00eb gam\u00eb t\u00eb plot\u00eb softuer\u00ebsh, si p\u00ebr menaxhimin e t\u00eb dh\u00ebnave transaksionale, ashtu edhe p\u00ebr p\u00ebrpunimin e k\u00ebtyre t\u00eb dh\u00ebnave n\u00eb sistemet e analiz\u00ebs dhe raportimit. N\u00eb ve\u00e7anti, platforma SAP Business Warehouse (SAP BW) \u00ebsht\u00eb nj\u00eb mjet p\u00ebr ruajtjen dhe analiz\u00ebn e t\u00eb dh\u00ebnave, q\u00eb ka mund\u00ebsi t\u00eb gjera teknike. Pavar\u00ebsisht t\u00eb gjitha avantazheve objektive, sistemi SAP BW ka nj\u00eb","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u042d\u043a\u0441\u0442\u0440\u0430\u043a\u0446\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 SAP HCM \u0432 non-SAP \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 | ProHoster","og:description":"\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e, \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u044f SAP \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442 \u043f\u043e\u043b\u043d\u044b\u0439 \u0441\u043f\u0435\u043a\u0442\u0440 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u043e\u0433\u043e \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u044f, \u043a\u0430\u043a \u0434\u043b\u044f \u0432\u0435\u0434\u0435\u043d\u0438\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445, \u0442\u0430\u043a \u0438 \u0434\u043b\u044f \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u044d\u0442\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438 \u043e\u0442\u0447\u0435\u0442\u043d\u043e\u0441\u0442\u0438. \u0412 \u0447\u0430\u0441\u0442\u043d\u043e\u0441\u0442\u0438 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 SAP Business Warehouse (SAP BW) \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0431\u043e\u0439 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438 \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0434\u0430\u043d\u043d\u044b\u0445, \u043e\u0431\u043b\u0430\u0434\u0430\u044e\u0449\u0438\u0439 \u0448\u0438\u0440\u043e\u043a\u0438\u043c\u0438 \u0442\u0435\u0445\u043d\u0438\u0447\u0435\u0441\u043a\u0438\u043c\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c\u0438. \u041f\u0440\u0438 \u0432\u0441\u0435\u0445 \u0441\u0432\u043e\u0438\u0445 \u043e\u0431\u044a\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u043f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0430\u0445 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 SAP BW \u043e\u0431\u043b\u0430\u0434\u0430\u0435\u0442 \u043e\u0434\u043d\u0438\u043c","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-09-24T17:42:23+00:00","article:modified_time":"2020-09-24T17:42:23+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"95021","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 11:13:39","updated":"2026-02-22 15:29:41"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/95021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=95021"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/95021\/revisions"}],"predecessor-version":[{"id":162188,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/95021\/revisions\/162188"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/95022"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=95021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=95021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=95021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}