{"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\/sk\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh","title":{"rendered":"Extrahovanie d\u00e1t zo SAP HCM do non-SAP \u00falo\u017e\u00edsk d\u00e1t","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Ako vieme, spolo\u010dnos\u0165 SAP pon\u00faka kompletn\u00fd rozsah softv\u00e9ru, ktor\u00fd sl\u00fa\u017ei na spracovanie transak\u010dn\u00fdch \u00fadajov aj na anal\u00fdzu a reportovanie t\u00fdchto \u00fadajov. Konkr\u00e9tne platforma SAP Business Warehouse (SAP BW) predstavuje n\u00e1stroj na ulo\u017eenie a anal\u00fdzu \u00fadajov s rozsiahlymi technick\u00fdmi mo\u017enos\u0165ami. Napriek v\u0161etk\u00fdm svojim objekt\u00edvnym v\u00fdhod\u00e1m m\u00e1 syst\u00e9m SAP BW jednu v\u00fdznamn\u00fa nev\u00fdhodu. To je vysok\u00e1 cena za ukladanie a spracovanie \u00fadajov, \u010do je obzvl\u00e1\u0161\u0165 vidite\u013en\u00e9 pri pou\u017e\u00edvan\u00ed cloudovej SAP BW na HANA. <\/p>\n

A \u010do ak za\u010dneme ako \u00falo\u017eisko pou\u017e\u00edva\u0165 nejak\u00fd non-SAP, ide\u00e1lne OpenSource produkt? My v X5 Retail Group sme sa rozhodli pre GreenPlum. To ur\u010dite rie\u0161i probl\u00e9m n\u00e1kladov, ale hne\u010f sa objavuj\u00fa ot\u00e1zky, ktor\u00e9 sa pri pou\u017e\u00edvan\u00ed SAP BW rie\u0161ili prakticky implicitne.<\/p>\n

\"Extrahovanie
\n<\/a><\/noindex>
\nV pr\u00edpade, ak\u00fdm sp\u00f4sobom z\u00edskava\u0165 \u00fadaje z syst\u00e9mov zdrojov, ktor\u00e9 s\u00fa vo v\u00e4\u010d\u0161ine pr\u00edpadov rie\u0161enia SAP?<\/p>\n

Projekt \u201eHR-metrics\u201c bol prv\u00fdm projektom, v ktorom bolo potrebn\u00e9 vyrie\u0161i\u0165 tento probl\u00e9m. Na\u0161\u00edm cie\u013eom bolo vytvorenie \u00falo\u017eiska HR \u00fadajov a vytvorenie anal\u00fdtick\u00fdch reportov v oblasti pr\u00e1ce so zamestnancami. Hlavn\u00fdm zdrojom \u00fadajov je toti\u017e transak\u010dn\u00fd syst\u00e9m SAP HCM, v ktorom prebiehaj\u00fa v\u0161etky person\u00e1lne, organiza\u010dn\u00e9 a mzdov\u00e9 aktivity. <\/p>\n

Extrahovanie \u00fadajov<\/h3>\n

\nV SAP BW existuj\u00fa \u0161tandardn\u00e9 extraktory \u00fadajov pre SAP syst\u00e9my. Tieto extraktory m\u00f4\u017eu automaticky zhroma\u017e\u010fova\u0165 potrebn\u00e9 \u00fadaje, sledova\u0165 ich integritu a ur\u010dova\u0165 zmeny. Napr\u00edklad, tu je \u0161tandardn\u00fd zdroj \u00fadajov pod\u013ea atrib\u00fatov zamestnanca 0EMPLOYEE_ATTR:<\/p>\n

\"Extrahovanie
\n
\nV\u00fdsledok extrahovania \u00fadajov z neho pre jedn\u00e9ho zamestnanca:<\/p>\n

\"Extrahovanie
\n
\nV pr\u00edpade potreby m\u00f4\u017ee by\u0165 tak\u00fd extraktor prisp\u00f4soben\u00fd vlastn\u00fdm po\u017eiadavk\u00e1m alebo m\u00f4\u017ee by\u0165 vytvoren\u00fd vlastn\u00fd extraktor. <\/p>\n

Prv\u00e1 vznikla my\u0161lienka o mo\u017enosti ich op\u00e4tovn\u00e9ho pou\u017eitia. Bohu\u017eia\u013e, to sa uk\u00e1zalo ako neuskuto\u010dnite\u013en\u00e1 \u00faloha. V\u00e4\u010d\u0161ina logiky je implementovan\u00e1 na strane SAP BW, a bezbolestne oddeli\u0165 extraktor na zdroji od SAP BW sa nepodarilo. <\/p>\n

Stalo sa zjavn\u00e9, \u017ee bude potrebn\u00e9 vyvin\u00fa\u0165 vlastn\u00fd mechanizmus na extrakciu \u00fadajov zo SAP syst\u00e9mov. <\/p>\n

\u0160trukt\u00fara ukladania \u00fadajov v SAP HCM<\/h3>\n

\nNa pochopenie po\u017eiadaviek na tak\u00fdto mechanizmus je najprv potrebn\u00e9 ur\u010di\u0165, ak\u00e9 \u00fadaje budeme potrebova\u0165.<\/p>\n

V\u00e4\u010d\u0161ina \u00fadajov v SAP HCM sa uchov\u00e1va v ploch\u00fdch SQL tabu\u013ek\u00e1ch. Na z\u00e1klade t\u00fdchto \u00fadajov aplik\u00e1cie SAP vizualizuj\u00fa pou\u017e\u00edvate\u013eovi organiza\u010dn\u00e9 \u0161trukt\u00fary, zamestnancov a \u010fal\u0161ie HR inform\u00e1cie. Napr\u00edklad, takto vyzer\u00e1 organiza\u010dn\u00e1 \u0161trukt\u00fara v SAP HCM:<\/p>\n

\"Extrahovanie
\n
\nFyzicky je tento strom ulo\u017een\u00fd v dvoch tabu\u013ek\u00e1ch - v hrp1000 objekty a v hrp1001 vz\u0165ahy medzi t\u00fdmito objektmi. <\/p>\n

Objekty \u201eOddelenie 1\u201c a \u201e\u00darad 1\u201c:<\/p>\n

\"Extrahovanie
\n
\nVz\u0165ah medzi objektmi:<\/p>\n

\"Extrahovanie
\n
\nM\u00f4\u017ee existova\u0165 obrovsk\u00e9 mno\u017estvo typov objektov, ako aj typov vz\u0165ahov medzi nimi. Existuj\u00fa \u0161tandardn\u00e9 vz\u0165ahy medzi objektmi, ako aj prisp\u00f4soben\u00e9 pre vlastn\u00e9 \u0161pecifick\u00e9 potreby. Napr\u00edklad, \u0161tandardn\u00fd vz\u0165ah B012 medzi organiza\u010dnou jednotkou a pracovnou poz\u00edciou ozna\u010duje ved\u00faceho oddelenia.<\/p>\n

Zobrazenie ved\u00faceho v SAP:<\/p>\n

\"Extrahovanie
\n
\nUlo\u017eenie v tabu\u013eke DB:<\/p>\n

\"Extrahovanie
\n
\n\u00dadaje o zamestnancoch sa uchov\u00e1vaj\u00fa v tabu\u013ek\u00e1ch pa*. Napr\u00edklad, \u00fadaje o person\u00e1lnych udalostiach zamestnanca sa uchov\u00e1vaj\u00fa v tabu\u013eke pa0000.<\/p>\n

\"Extrahovanie
\n
\nRozhodli sme sa, \u017ee GreenPlum bude z\u00edskava\u0165 \u201esurov\u00e9\u201c \u00fadaje, t.j. jednoducho ich skop\u00edruje z tabu\u013eiek SAP. A a\u017e v GreenPlum bud\u00fa spracov\u00e1van\u00e9 a transformovan\u00e9 na fyzick\u00e9 objekty (napr\u00edklad Oddelenie alebo Zamestnanec) a metriky (napr\u00edklad priemern\u00fd po\u010det zamestnancov).<\/p>\n

Bolo ur\u010den\u00fdch pribli\u017ene 70 tabu\u013eiek, z ktor\u00fdch je potrebn\u00e9 pren\u00e1\u0161a\u0165 \u00fadaje do GreenPlum. N\u00e1sledne sme pre\u0161li k spracovaniu sp\u00f4sobu prenosu t\u00fdchto \u00fadajov.<\/p>\n

SAP pon\u00faka dostato\u010dne ve\u013ek\u00e9 mno\u017estvo integra\u010dn\u00fdch mechanizmov. Najjednoduch\u0161\u00ed sp\u00f4sob - priamy pr\u00edstup k datab\u00e1ze je v\u0161ak zak\u00e1zan\u00fd z d\u00f4vodu licen\u010dn\u00fdch obmedzen\u00ed. Tak\u017ee v\u0161etky integra\u010dn\u00e9 toky musia by\u0165 realizovan\u00e9 na \u00farovni servera<\/a> aplik\u00e1ci\u00ed.
\n\u010eal\u0161\u00edm probl\u00e9mom bolo absencia \u00fadajov o vymazan\u00fdch z\u00e1znamoch v datab\u00e1ze SAP. Pri odstr\u00e1nen\u00ed riadku v datab\u00e1ze je fyzicky odstr\u00e1nen\u00fd. T.j. generovanie delta zmien pod\u013ea \u010dasu zmeny nebolo mo\u017en\u00e9.<\/p>\n

Samozrejme, v SAP HCM existuj\u00fa mechanizmy na zachyt\u00e1vanie zmien \u00fadajov. Napr\u00edklad, pre n\u00e1sledn\u00fd prenos do syst\u00e9mov pr\u00edjemcov existuj\u00fa ukazovatele zmien (change pointer), ktor\u00e9 registruj\u00fa ak\u00e9ko\u013evek zmeny a na z\u00e1klade ktor\u00fdch sa generuj\u00fa Idoc (objekt na prenos do extern\u00fdch syst\u00e9mov).<\/p>\n

Pr\u00edklad IDoc zmeny infotypu 0302 pre zamestnanca s eviden\u010dn\u00fdm \u010d\u00edslom 1251445:<\/p>\n

\"Extrahovanie
\n
\nAlebo vedenie logov zmien d\u00e1t v tabu\u013eke DBTABLOG.<\/p>\n

Pr\u00edklad logu odstr\u00e1nenia z\u00e1znamu so k\u013e\u00fa\u010dom QK53216375 z tabu\u013eky hrp1000:<\/p>\n

\"Extrahovanie
\n
\nTieto mechanizmy s\u00fa v\u0161ak dostupn\u00e9 len pre niektor\u00e9 potrebn\u00e9 d\u00e1ta a ich spracovanie na \u00farovni aplika\u010dn\u00e9ho servera m\u00f4\u017ee vy\u017eadova\u0165 zna\u010dn\u00e9 mno\u017estvo zdrojov. Preto hromadn\u00e9 zap\u00ednanie logovania pre v\u0161etky potrebn\u00e9 tabu\u013eky m\u00f4\u017ee vies\u0165 k v\u00fdraznej degrad\u00e1cii v\u00fdkonu syst\u00e9mu. <\/p>\n

\u010eal\u0161\u00edm v\u00e1\u017enym probl\u00e9mom boli klastrovan\u00e9 tabu\u013eky. \u00dadaje o odhade \u010dasu a v\u00fdpo\u010dte mzdy v RDBMS verzii SAP HCM s\u00fa ulo\u017een\u00e9 ako s\u00fabor logick\u00fdch tabuliek pre ka\u017ed\u00e9ho zamestnanca pri ka\u017edom v\u00fdpo\u010dte. Tieto logick\u00e9 tabu\u013eky s\u00fa vo forme bin\u00e1rnych d\u00e1t ulo\u017een\u00e9 v tabu\u013eke pcl2.<\/p>\n

Klastor v\u00fdpo\u010dtu mzdy:<\/p>\n

\"Extrahovanie
\n
\n\u00dadaje z klastrovan\u00fdch tabuliek nie je mo\u017en\u00e9 \u010d\u00edta\u0165 SQL pr\u00edkazom, pri\u010dom je potrebn\u00e9 pou\u017ei\u0165 makropokyny SAP HCM alebo \u0161peci\u00e1lne funk\u010dn\u00e9 moduly. R\u00fdchlos\u0165 \u010d\u00edtania tak\u00fdchto tabuliek bude preto dos\u0165 n\u00edzka. Na druhej strane, v t\u00fdchto klastroch s\u00fa ulo\u017een\u00e9 d\u00e1ta, ktor\u00e9 s\u00fa potrebn\u00e9 len raz mesa\u010dne \u2013 kone\u010dn\u00fd v\u00fdpo\u010det mzdy a odhad \u010dasu. Preto r\u00fdchlos\u0165 v tomto pr\u00edpade nie je a\u017e tak kritick\u00e1. <\/p>\n

Pri hodnoten\u00ed mo\u017enost\u00ed generovania delty zmien d\u00e1t sme sa rozhodli zv\u00e1\u017ei\u0165 aj mo\u017enos\u0165 plnej export\u00e1cie. Mo\u017enos\u0165 ka\u017edodenne pren\u00e1\u0161a\u0165 gigabajty nemenn\u00fdch d\u00e1t medzi syst\u00e9mami nem\u00f4\u017ee vyzera\u0165 priaznivo. Av\u0161ak m\u00e1 aj mno\u017estvo v\u00fdhod \u2013 nie je potrebn\u00e9 realizova\u0165 deltov\u00fa logiku na strane zdroja, ani integrova\u0165 t\u00fato deltu na strane prij\u00edma\u010da. T\u00fdm sa zni\u017euj\u00fa n\u00e1klady a \u010das realiz\u00e1cie a zvy\u0161uje sa spo\u013eahlivos\u0165 integr\u00e1cie. Z\u00e1rove\u0148 bolo stanoven\u00e9, \u017ee takmer v\u0161etky zmeny v SAP HR sa dej\u00fa v horizonte troch mesiacov pred aktu\u00e1lnym d\u00e1tumom. Tak\u017ee bolo prijat\u00e9 rozhodnutie zastavi\u0165 sa na dennom plnom exporte d\u00e1t z SAP HR za N mesiacov pred aktu\u00e1lnym d\u00e1tumom a na mesa\u010dnom plnom exporte. Parameter N z\u00e1vis\u00ed od konkr\u00e9tnej tabu\u013eky.
\n a kol\u00ed\u0161e od 1 do 15.<\/p>\n

Na extrakciu d\u00e1t bola navrhnut\u00e1 nasledovn\u00e1 sch\u00e9ma:<\/p>\n

\"Extrahovanie
\n
\nExtern\u00fd syst\u00e9m vytv\u00e1ra po\u017eiadavku a posiela ju do SAP HCM, kde sa t\u00e1to po\u017eiadavka kontroluje na \u00faplnos\u0165 \u00fadajov a opr\u00e1vnenia na pr\u00edstup k tabu\u013ek\u00e1m. V pr\u00edpade \u00faspe\u0161nej kontroly sa v SAP HCM spust\u00ed program, ktor\u00fd zhroma\u017e\u010fuje potrebn\u00e9 \u00fadaje a odosiela ich do integra\u010dn\u00e9ho rie\u0161enia Fuse. Fuse ur\u010duje potrebn\u00fa t\u00e9mu v Kafka a pren\u00e1\u0161a tam \u00fadaje. N\u00e1sledne sa \u00fadaje z Kafka pren\u00e1\u0161aj\u00fa do Stage Area GP.<\/p>\n

V tejto re\u0165azci n\u00e1s zauj\u00edma ot\u00e1zka z\u00edskavania \u00fadajov z SAP HCM. Zastav\u00edme sa na \u0148om podrobnej\u0161ie. <\/p>\n

Sch\u00e9ma interakcie SAP HCM-FUSE.<\/p>\n

\"Extrahovanie
\n
\nExtern\u00fd syst\u00e9m ur\u010duje \u010das poslednej \u00faspe\u0161nej po\u017eiadavky v SAP.
\nProces m\u00f4\u017ee by\u0165 spusten\u00fd pod\u013ea \u010dasova\u010da alebo inej udalosti, vr\u00e1tane mo\u017enosti nastavi\u0165 \u010dasov\u00fd limit na \u010dakaniu na odpove\u010f s \u00fadajmi od SAP a iniciova\u0165 opakovan\u00fa po\u017eiadavku. Po tom vytv\u00e1ra po\u017eiadavku na deltu a odosiela ju do SAP.<\/p>\n

\u00dadaje po\u017eiadavky sa pren\u00e1\u0161aj\u00fa v tele v form\u00e1te json.
\nMet\u00f3da http: POST.
\nPr\u00edklad dotazu:<\/p>\n

\"Extrahovanie
\n
\nSlu\u017eba SAP vykon\u00e1va kontrolu po\u017eiadavky na \u00faplnos\u0165, zhodu so s\u00fa\u010dasnou \u0161trukt\u00farou SAP a vekou pr\u00edstupov\u00e9ho povolenia k po\u017eadovanej tabu\u013eke. <\/p>\n

V pr\u00edpade ch\u00fdb slu\u017eba vracia odpove\u010f s pr\u00edslu\u0161n\u00fdm k\u00f3dom a popisom. V pr\u00edpade \u00faspe\u0161nej kontroly vytv\u00e1ra pozadinsk\u00fd proces na tvorbu v\u00fdberu, generuje a synchronne vracia unik\u00e1tne id rel\u00e1cie. <\/p>\n

Extern\u00fd syst\u00e9m v pr\u00edpade chyby zaznamen\u00e1va ju do denn\u00edka. V pr\u00edpade \u00faspe\u0161nej odpovede odovzd\u00e1va id rel\u00e1cie a n\u00e1zov tabu\u013eky, k tejto po\u017eiadavke.<\/p>\n

Extern\u00fd syst\u00e9m registruje aktu\u00e1lnu rel\u00e1ciu ako otvoren\u00fa. Ak existuj\u00fa in\u00e9 rel\u00e1cie pre dan\u00fa tabu\u013eku, s\u00fa uzavret\u00e9 s registr\u00e1ciou varovania v denn\u00edku.<\/p>\n

Pozadinsk\u00e1 \u00faloha SAP vytv\u00e1ra kurzor pod\u013ea dan\u00fdch parametrov a paket \u00fadajov stanovenej ve\u013ekosti. Ve\u013ekos\u0165 paketu \u2013 maxim\u00e1lny po\u010det z\u00e1znamov, ktor\u00e9 proces \u010d\u00edta z DB. Predpoklad\u00e1 sa ako 2000. Ak je vo v\u00fdbere DB viac z\u00e1znamov, ako je pou\u017eit\u00e1 ve\u013ekos\u0165 paketu, po odoslan\u00ed prv\u00e9ho paketu sa vytv\u00e1ra \u010fal\u0161\u00ed blok s pr\u00edslu\u0161n\u00fdm offsetom a inkrementovan\u00fdm \u010d\u00edslom paketu. \u010c\u00edsla sa inkrementuj\u00fa o 1 a posielaj\u00fa sa striktne postupne. <\/p>\n

N\u00e1sledne SAP pren\u00e1\u0161a bal\u00edk na vstup webovej slu\u017eby vonkaj\u0161ieho syst\u00e9mu. Tento syst\u00e9m vykon\u00e1va kontroly prich\u00e1dzaj\u00faceho bal\u00edka. V syst\u00e9me by mala by\u0165 zaregistrovan\u00e1 rel\u00e1cia s prijat\u00fdm ID a mala by by\u0165 v otvorenom stave. Ak je \u010d\u00edslo bal\u00edka > 1, v syst\u00e9me by mala by\u0165 zaregistrovan\u00e1 \u00faspe\u0161n\u00e1 prijatie predch\u00e1dzaj\u00faceho bal\u00edka (package_id-1).<\/p>\n

V pr\u00edpade \u00faspe\u0161nej kontroly vonkaj\u0161\u00ed syst\u00e9m parsuje a uklad\u00e1 \u00fadaje tabu\u013eky.<\/p>\n

Okrem toho, ak bal\u00edk obsahuje vlajku final a serializ\u00e1cia prebehla \u00faspe\u0161ne, doch\u00e1dza k notifik\u00e1cii integra\u010dn\u00e9ho modulu o \u00faspe\u0161nom dokon\u010den\u00ed spracovania rel\u00e1cie a modul aktualizuje stav rel\u00e1cie.<\/p>\n

V pr\u00edpade chyby kontrol \/ parsovania sa chyba loguje a bal\u00edky za dan\u00fa rel\u00e1ciu bud\u00fa zamietnut\u00e9 vonkaj\u0161\u00edm syst\u00e9mom.<\/p>\n

Rovnako aj v opa\u010dnom pr\u00edpade, ke\u010f vonkaj\u0161\u00ed syst\u00e9m vracia chybu, t\u00e1to je logovan\u00e1 a prenos bal\u00edkov sa zastavuje.<\/p>\n

Pre po\u017eiadavku na \u00fadaje zo strany SAP HCM bol implementovan\u00fd integra\u010dn\u00fd servis. Servis je implementovan\u00fd na frameworku ICF (SAP Internet Communication Framework \u2014 help.sap.com\/viewer\/6da7259a6c4b1014b7d5e759cc76fd22\/7.01.22\/en-US\/488d6e0ea6ed72d5e10000000a42189c.html<\/a><\/noindex>). Umo\u017e\u0148uje vykona\u0165 po\u017eiadavku na \u00fadaje z syst\u00e9mu SAP HCM z konkr\u00e9tnych tabuliek. Pri tvorbe po\u017eiadavky na \u00fadaje je mo\u017en\u00e9 zada\u0165 zoznam konkr\u00e9tnych pol\u00ed a parametrov filtrovania s cie\u013eom z\u00edska\u0165 potrebn\u00e9 \u00fadaje. Implement\u00e1cia servisu pritom nepredpoklad\u00e1 \u017eiadnu obchodn\u00fa logiku. Algoritmy v\u00fdpo\u010dtu delty, parametre po\u017eiadavky, kontrola integrity a podobne s\u00fa taktie\u017e implementovan\u00e9 na strane vonkaj\u0161ieho syst\u00e9mu.<\/p>\n

Tento mechanizmus umo\u017e\u0148uje zhroma\u017e\u010fova\u0165 a pren\u00e1\u0161a\u0165 v\u0161etky potrebn\u00e9 \u00fadaje za nieko\u013eko hod\u00edn. Tak\u00e1to r\u00fdchlos\u0165 je na hranici akceptovate\u013enosti, preto je toto rie\u0161enie pova\u017eovan\u00e9 za do\u010dasn\u00e9, ktor\u00e9 n\u00e1m umo\u017enilo uzavrie\u0165 potrebu po n\u00e1stroji extrakcie v projekte.
\nV cie\u013eovom obraze pre rie\u0161enie \u00falohy extrakcie \u00fadajov sa zva\u017euj\u00fa mo\u017enosti pou\u017eitia CDC syst\u00e9mov typu Oracle Golden Gate alebo ETL n\u00e1strojov typu SAP DS.
\n
Zdroj: 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\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\udd47Extrahovanie \u00fadajov z SAP HCM do non-SAP \u00falo\u017eiska \u00fadajov | ProHoster","description":"Ako je zn\u00e1me, spolo\u010dnos\u0165 SAP pon\u00faka kompletn\u00fd rad softv\u00e9ru, ako na vedenie transak\u010dn\u00fdch \u00fadajov, tak na spracovanie t\u00fdchto \u00fadajov v analytick\u00fdch a reportovac\u00edch syst\u00e9moch.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/95021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=95021"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/95021\/revisions"}],"predecessor-version":[{"id":162188,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/95021\/revisions\/162188"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media\/95022"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=95021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=95021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=95021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}