{"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 depozita t\u00eb dh\u00ebnash non-SAP","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Si e njohur, kompania SAP ofron nj\u00eb gam\u00eb t\u00eb plot\u00eb t\u00eb softuerit, 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) p\u00ebrb\u00ebnte nj\u00eb mjet p\u00ebr ruajtjen dhe analizimin e t\u00eb dh\u00ebnave, me mund\u00ebsi t\u00eb gjera teknike. Megjith\u00eb t\u00eb gjitha p\u00ebrfitimet e saj objektive, sistemi SAP BW ka nj\u00eb mang\u00ebsi t\u00eb r\u00ebnd\u00ebsishme. Kjo \u00ebsht\u00eb kostoja e lart\u00eb e ruajtjes dhe p\u00ebrpunimit t\u00eb t\u00eb dh\u00ebnave, ve\u00e7an\u00ebrisht e dukshme kur p\u00ebrdoret SAP BW on Hana n\u00eb cloud. <\/p>\n

Por \u00e7far\u00eb n\u00ebse si nj\u00eb depo fillojm\u00eb t\u00eb p\u00ebrdorim ndonj\u00eb produkt non-SAP dhe preferohet open-source? Ne n\u00eb grupin X5 Retail kemi vendosur p\u00ebr GreenPlum. Kjo sigurisht q\u00eb zgjidh \u00e7\u00ebshtjen e kostos, por menj\u00ebher\u00eb ngjall pyetje q\u00eb me p\u00ebrdorimin e SAP BW zgjidheshin praktikisht automatikisht.<\/p>\n

\"Ekstraktimi
\n<\/a><\/noindex>
\nVe\u00e7an\u00ebrisht, si t\u00eb marrim t\u00eb dh\u00ebna nga sistemet burimore, t\u00eb cilat 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 zgjidhim k\u00ebt\u00eb problem. Q\u00ebllimi yn\u00eb ishte krijimi i nj\u00eb depoje t\u00eb dh\u00ebnash HR dhe nd\u00ebrtimi i raportimeve analitike n\u00eb drejtimin e pun\u00ebs me punonj\u00ebsit. N\u00eb k\u00ebt\u00eb rast, burimi kryesor i t\u00eb dh\u00ebnave \u00ebsht\u00eb sistemi transaksional SAP HCM, n\u00eb t\u00eb cilin menaxhohen t\u00eb gjitha aktivitetet e stafit, 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, t\u00eb p\u00ebrcaktojn\u00eb deltat e 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 prej tij p\u00ebr nj\u00eb punonj\u00ebs:<\/p>\n

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

Ideja e p\u00ebrdorimit t\u00eb tyre u shfaq e para. Fatkeq\u00ebsisht, kjo u tregua nj\u00eb detyr\u00eb e pamundur. Pjesa m\u00eb e madhe e logjik\u00ebs \u00ebsht\u00eb realizuar nga ana e SAP BW, dhe nuk arrit\u00ebm t\u00eb ndajn\u00eb me leht\u00ebsi ekstraktorin n\u00eb burim nga SAP BW. <\/p>\n

U b\u00eb e qart\u00eb se do t\u00eb ishte e nevojshme zhvillimi i nj\u00eb mekanizmi t\u00eb vet 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 cilat t\u00eb dh\u00ebna do t\u00eb na nevojiten.<\/p>\n

Shumica e t\u00eb dh\u00ebnave n\u00eb SAP HCM ruhen n\u00eb tabela SQL t\u00eb sheshta. N\u00eb baz\u00eb t\u00eb k\u00ebtyre t\u00eb dh\u00ebnave, aplikacionet SAP vizualizojn\u00eb p\u00ebr p\u00ebrdoruesin strukturat organizative, punonj\u00ebsit dhe informacionin e tjera HR. P\u00ebr shembull, k\u00ebshtu duket struktura organizative n\u00eb SAP HCM:<\/p>\n

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

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

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

\"Ekstraktimi
\n
\nKa nj\u00eb num\u00ebr t\u00eb madh t\u00eb tipeve t\u00eb objekteve dhe tipeve t\u00eb lidhjeve midis tyre. Ekzistojn\u00eb si lidhje standarde midis objekteve, ashtu edhe t\u00eb personalizuara p\u00ebr nevojat specifike. P\u00ebr shembull, lidhja standarde B012 midis nj\u00eb nj\u00ebsi organizative dhe nj\u00eb pozite t\u00eb caktuar tregon mbi shefin e n\u00ebndeg\u00ebs.<\/p>\n

Shfaqja e shefit 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 tabelat pa*. P\u00ebr shembull, t\u00eb dh\u00ebnat mbi aktivitetet e pun\u00ebs p\u00ebr nj\u00eb punonj\u00ebs ruhen n\u00eb tabel\u00ebn pa0000.<\/p>\n

\"Ekstraktimi
\n
\nNe vendos\u00ebm q\u00eb GreenPlum do t\u00eb marr\u00eb t\u00eb dh\u00ebnat \"t\u00eb pap\u00ebrpunuara\", dmth, do t'i kopjoj\u00eb ato thjesht nga tabelat SAP. Dhe pas k\u00ebsaj, n\u00eb GreenPlum do t\u00eb p\u00ebrpunohen dhe p\u00ebrmir\u00ebsohen n\u00eb objekte fizike (p.sh., Departament ose Punonj\u00ebs) dhe metrikat (p.sh., numri mesatar i punonj\u00ebsve).<\/p>\n

I jan\u00eb p\u00ebrcaktuar rreth 70 tabela, t\u00eb dh\u00ebnat nga t\u00eb cilat duhet t\u00eb kalojn\u00eb n\u00eb GreenPlum. Pas k\u00ebsaj, ne filluam t\u00eb punojm\u00eb mbi m\u00ebnyr\u00ebn e kalimit 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 leht\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 q\u00eb, t\u00eb gjitha rrjedhat e integrimit duhet t\u00eb realizohen n\u00eb nivelin \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/a> e aplikacioneve.
\nProblemi tjet\u00ebr ishte mungesa e t\u00eb dh\u00ebnave p\u00ebr regjistrimet e fshira n\u00eb DB SAP. Kur nj\u00eb rresht zhduket n\u00eb DB, ai zhduket fizikisht. Dometh\u00ebn\u00eb, formimi i diferenc\u00ebs s\u00eb ndryshimeve n\u00eb koh\u00ebn e ndryshimit nuk ishte i mundur.<\/p>\n

Sigurisht, n\u00eb SAP HCM ekzistojn\u00eb mekanizma p\u00ebr regjistrimin e ndryshimeve t\u00eb t\u00eb dh\u00ebnave. P\u00ebr shembull, p\u00ebr kalimin e m\u00ebvonsh\u00ebm n\u00eb sistemet marr\u00ebs ekzistojn\u00eb tregues ndryshimesh (change pointer), t\u00eb cilat regjistrojn\u00eb \u00e7do ndryshim dhe mbi baz\u00ebn e t\u00eb cilave formohen Idoc (objekti p\u00ebr transferimin n\u00eb sisteme t\u00eb jashtme).<\/p>\n

Shembulli i ndryshimit t\u00eb infotype 0302 p\u00ebr nj\u00eb punonj\u00ebs me numrin e regjistrimit 1251445:<\/p>\n

\"Ekstraktimi
\n
\nOse mbajtja e log\u00ebve 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 regjistrimi me \u00e7el\u00ebsin QK53216375 nga tabela hrp1000:<\/p>\n

\"Ekstraktimi
\n
\nPor k\u00ebto mekanizma nuk jan\u00eb t\u00eb disponuesh\u00ebm p\u00ebr t\u00eb gjitha t\u00eb dh\u00ebnat e nevojshme dhe p\u00ebrpunimi i tyre n\u00eb nivelin e serverit t\u00eb aplikacioneve mund t\u00eb konsumoj\u00eb mjaft 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 i r\u00ebnd\u00ebsish\u00ebm ishte tabelat klaster. T\u00eb dh\u00ebnat e llogaritjes s\u00eb koh\u00ebs dhe llogaritjes s\u00eb pag\u00ebs n\u00eb RDBMS versionin SAP HCM ruhen si nj\u00eb grup tabelash logjike p\u00ebr \u00e7do punonj\u00ebs p\u00ebr \u00e7do llogaritje. K\u00ebto tabela logjike ruhen 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 klaster nuk mund t\u00eb lexohen me komand\u00ebn SQL, dhe nevojitet p\u00ebrdorimi i makrokomanandave 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. Nga ana tjet\u00ebr, n\u00eb k\u00ebto klaster ruhen t\u00eb dh\u00ebna q\u00eb nevojiten vet\u00ebm nj\u00eb her\u00eb n\u00eb muaj \u2013 llogaritja p\u00ebrfundimtare e pag\u00ebs dhe vler\u00ebsimi i koh\u00ebs. Pra, shpejt\u00ebsia n\u00eb k\u00ebt\u00eb rast nuk \u00ebsht\u00eb aq kritike. <\/p>\n

Duke vler\u00ebsuar opsionet p\u00ebr formimin e dyt\u00eb t\u00eb ndryshimeve t\u00eb t\u00eb dh\u00ebnave, vendos\u00ebm gjithashtu t\u00eb shqyrtojm\u00eb opsionin me eksport t\u00eb plot\u00eb. Opsioni p\u00ebr t\u00eb kaluar gigabajt t\u00eb t\u00eb dh\u00ebnave t\u00eb pandryshuara \u00e7do dit\u00eb midis sistemeve nuk mund t\u00eb duket t\u00ebrheq\u00ebs. Megjithat\u00eb, ai ka dhe disa p\u00ebrfitime \u2013 nuk ka nevoj\u00eb as p\u00ebr realizimin e dyt\u00ebs nga ana e burimit, as p\u00ebr realizimin e integrimit t\u00eb k\u00ebsaj dyt\u00ebs nga ana e marr\u00ebsit. Si rezultat, u zvog\u00ebloa kostoja dhe koha e realizimit, dhe u rrit besueshm\u00ebria e integrimit. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, u p\u00ebrcaktua se pothuajse t\u00eb gjitha ndryshimet n\u00eb SAP HR ndodhin brenda nj\u00eb harku tre mujor deri n\u00eb dat\u00ebn aktuale. Prandaj, u mor vendimi p\u00ebr t\u00eb q\u00ebndruar te eksporti i plot\u00eb t\u00eb t\u00eb dh\u00ebnave nga SAP HR p\u00ebr N muaj deri n\u00eb dat\u00ebn aktuale dhe p\u00ebr eksportin e plot\u00eb \u00e7do muaj. 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 propozuar skema e m\u00ebposhtme:<\/p>\n

\"Ekstraktimi
\n
\nSistemi i jasht\u00ebm formon nj\u00eb k\u00ebrkes\u00eb dhe e d\u00ebrgon n\u00eb SAP HCM, ku kjo k\u00ebrkes\u00eb kontrollohet p\u00ebr plot\u00ebsin\u00eb e t\u00eb dh\u00ebnave dhe kompetencat p\u00ebr qasje n\u00eb tavola. N\u00eb rast t\u00eb nj\u00eb verifikimi t\u00eb suksessh\u00ebm, n\u00eb SAP HCM punon nj\u00eb program q\u00eb mbledh t\u00eb dh\u00ebnat e nevojshme dhe i transmeton ato n\u00eb zgjidhjen e integrimit Fuse. Fuse p\u00ebrcakton tem\u00ebn e nevojshme n\u00eb Kafka dhe e d\u00ebrgon atje t\u00eb dh\u00ebnat. M\u00eb pas, t\u00eb dh\u00ebnat nga Kafka d\u00ebrgohen n\u00eb Stage Area GP.<\/p>\n

Ne n\u00eb k\u00ebt\u00eb zinxhir jemi t\u00eb interesuar p\u00ebr procesin e nxjerrjes s\u00eb t\u00eb dh\u00ebnave nga SAP HCM. Do t\u00eb ndalemi m\u00eb n\u00eb detaje mbi k\u00ebt\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.
\nProcessi mund t\u00eb iniciohet nga nj\u00eb koh\u00ebmat\u00ebs ose nj\u00eb ngjarje tjet\u00ebr, p\u00ebrfshir\u00eb mund\u00ebsin\u00eb e vendosjes s\u00eb nj\u00eb koh\u00ebprerjeje p\u00ebr pritjen e nj\u00eb p\u00ebrgjigjeje me t\u00eb dh\u00ebna nga SAP dhe iniciimin e nj\u00eb k\u00ebrkese t\u00eb p\u00ebrs\u00ebritur. Pas k\u00ebsaj, formon nj\u00eb k\u00ebrkes\u00eb p\u00ebr delta dhe e d\u00ebrgon at\u00eb n\u00eb SAP.<\/p>\n

T\u00eb dh\u00ebnat e k\u00ebrkes\u00ebs d\u00ebrgohen n\u00eb trup 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\u00ebsi, p\u00ebrputhje me struktur\u00ebn aktuale t\u00eb SAP, dhe pranimin e aksesit n\u00eb tavolat e k\u00ebrkuara. <\/p>\n

N\u00eb rast gabimesh, sh\u00ebrbimi kthen nj\u00eb p\u00ebrgjigje me kodin p\u00ebrkat\u00ebs dhe p\u00ebrshkrimin. N\u00eb rast kontrolli t\u00eb suksessh\u00ebm, krijon nj\u00eb proces n\u00eb sfond p\u00ebr formimin e p\u00ebrzgjedhjes, gjeneron dhe kthen n\u00eb m\u00ebnyr\u00eb sinhron nj\u00eb ID unik t\u00eb sesionit. <\/p>\n

Sistemi i jasht\u00ebm n\u00eb rast gabimi e regjistron at\u00eb n\u00eb ditar. N\u00eb rast t\u00eb nj\u00eb p\u00ebrgjigjeje t\u00eb suksesshme, transmeton ID-n\u00eb e sesionit dhe emrin e tavol\u00ebs p\u00ebr t\u00eb cil\u00ebn u b\u00eb k\u00ebrkesa.<\/p>\n

Sistemi i jasht\u00ebm regjistron sesionin aktual si t\u00eb hapur. N\u00ebse ka sesione t\u00eb tjera p\u00ebr k\u00ebt\u00eb tavoll\u00eb, ato mbyllen duke regjistruar nj\u00eb paralajm\u00ebrim n\u00eb ditar.<\/p>\n

Detyra n\u00eb sfond SAP formon nj\u00eb kursori sipas parametrave t\u00eb caktuara dhe nj\u00eb paket\u00eb t\u00eb dh\u00ebnash me madh\u00ebsi t\u00eb caktuar. Madh\u00ebsia e paket\u00ebs - numri maksimal i rekordeve q\u00eb procesi lexon nga Baza e t\u00eb Dh\u00ebnave. N\u00eb m\u00ebnyr\u00eb t\u00eb parazgjedhur merret si 2000. N\u00ebse n\u00eb p\u00ebrzgjedhjen e Baza e t\u00eb Dh\u00ebnave ka m\u00eb shum\u00eb rekorde se madh\u00ebsia e p\u00ebrdorur e paket\u00ebs, 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 rrept\u00ebsisht n\u00eb radh\u00eb. <\/p>\n

M\u00eb pas, SAP d\u00ebrgon paket\u00ebn n\u00eb hyrje t\u00eb sh\u00ebrbimit web t\u00eb sistemit t\u00eb jasht\u00ebm. Ai sistem realizon kontrollet e paket\u00ebs n\u00eb hyrje. N\u00eb sistem duhet t\u00eb jet\u00eb regjistruar nj\u00eb seanc\u00eb me ID-n\u00eb e marr\u00eb dhe ajo duhet t\u00eb jet\u00eb n\u00eb statusin e hapur. N\u00ebse numri i paket\u00ebs > 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 \u00ebsht\u00eb prania e flamurit final dhe serializimi ka kaluar me sukses, ndodh njoftimi i modulit t\u00eb integrimit p\u00ebr p\u00ebrfundimin e suksessh\u00ebm t\u00eb p\u00ebrpunimit t\u00eb sesionit dhe moduli p\u00ebrdit\u00ebson statusin e sesionit.<\/p>\n

N\u00eb rast gabimi gjat\u00eb kontrolleve\/parsing, 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 ndalet transmetimi i paketave.<\/p>\n

P\u00ebr k\u00ebrkesat e t\u00eb dh\u00ebnave n\u00eb an\u00ebn e SAP HCM \u00ebsht\u00eb realizuar nj\u00eb sh\u00ebrbim integrimi. Sh\u00ebrbimi \u00ebsht\u00eb realizuar n\u00eb framework-un ICF (SAP Internet Communication Framework \u2014 help.sap.com\/viewer\/6da7259a6c4b1014b7d5e759cc76fd22\/7.01.22\/en-US\/488d6e0ea6ed72d5e10000000a42189c.html<\/a><\/noindex>). Ai lejon marr\u00ebveshjen e t\u00eb dh\u00ebnave nga sistemi SAP HCM nga disa tabela t\u00eb caktuara. Gjat\u00eb formimit t\u00eb k\u00ebrkes\u00ebs p\u00ebr t\u00eb dh\u00ebna, ka mund\u00ebsi t\u00eb caktosh nj\u00eb list\u00eb t\u00eb fushave specifike dhe parametrat e filtrimit me q\u00ebllim marrjen e t\u00eb dh\u00ebnave t\u00eb nevojshme. Nd\u00ebrkoh\u00eb, realizimi i sh\u00ebrbimit nuk parashikon ndonj\u00eb logjik\u00eb biznesi. Algoritmet e llogaritjes s\u00eb d\u00eblty, parametrat e k\u00ebrkes\u00ebs, kontrolli i integritetit, etj., gjithashtu realizohen n\u00eb an\u00ebn e sistemit t\u00eb jasht\u00ebm.<\/p>\n

Ky mekaniz\u00ebm lejon mbledhjen dhe transmetimin e t\u00eb dh\u00ebnave t\u00eb nevojshme brenda disa or\u00ebve. Kjo shpejt\u00ebsi ndodhet n\u00eb kufijt\u00eb e pranuesh\u00ebm, prandaj kjo zgjidhje shqyrtohet nga ne si nj\u00eb opsion t\u00eb p\u00ebrkohsh\u00ebm, q\u00eb i ka mund\u00ebsuar p\u00ebrmbushjen e nevoj\u00ebs p\u00ebr nj\u00eb mjet ekstraktimi n\u00eb projekt.
\nN\u00eb pamjen e synuar p\u00ebr zgjidhjen e problemit t\u00eb ekstraktimit t\u00eb t\u00eb dh\u00ebnave, po shqyrtohen opsionet e p\u00ebrdorimit t\u00eb sistemeve CDC si Oracle Golden Gate ose mjete 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 non-SAP | ProHoster","description":"Si\u00e7 dihet, kompania SAP ofron nj\u00eb gam\u00eb t\u00eb plot\u00eb t\u00eb softuerit, si p\u00ebr mbajtjen e t\u00eb dh\u00ebnave tranzaksionale, ashtu edhe p\u00ebr p\u00ebrpunimin e k\u00ebtyre t\u00eb dh\u00ebnave n\u00eb sistemet e analiz\u00ebs dhe raportimit.","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.","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","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"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}]}}