{"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\/da\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh","title":{"rendered":"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Som bekendt tilbyder SAP en komplet vifte af software til b\u00e5de h\u00e5ndtering af transaktionsdata og behandling af disse data i analyse- og rapporteringssystemer. Is\u00e6r er SAP Business Warehouse (SAP BW) en platform, der fungerer som v\u00e6rkt\u00f8j til dataopbevaring og analyse med omfattende tekniske muligheder. P\u00e5 trods af sine objektive fordele har systemet SAP BW en betydelig ulempe. Det er de h\u00f8je omkostninger ved opbevaring og behandling af data, hvilket is\u00e6r er tydeligt, n\u00e5r man bruger cloud-l\u00f8sningen SAP BW on HANA. <\/p>\n<p>Hvad nu hvis vi begyndte at bruge et non-SAP lager, helst et OpenSource produkt? Vi i X5 Retail Group har valgt GreenPlum. Dette l\u00f8ser selvf\u00f8lgelig omkostningsproblemet, men der opst\u00e5r straks sp\u00f8rgsm\u00e5l, som n\u00e6sten blev l\u00f8st automatisk ved brug af SAP BW.<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/6b4bb611a259df02dd89d922669e0c04.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nIs\u00e6r hvordan man henter data fra kilde-systemer, som for det meste er SAP-l\u00f8sninger?<\/p>\n<p>\"HR-metrics\" blev det f\u00f8rste projekt, hvor denne udfordring skulle l\u00f8ses. Vores m\u00e5l var at oprette et lager af HR-data og udvikle analytiske rapporter om arbejdet med ansatte. Den prim\u00e6re datakilde er SAP HCM, som h\u00e5ndterer alle personalem\u00e6ssige, organisatoriske og l\u00f8nrelaterede aktiviteter. <\/p>\n<h3>Dataekstraktion<\/h3>\n<p>\nI SAP BW findes der standard dataekstraktorer til SAP-systemer. Disse ekstraktorer kan automatisk indsamle de n\u00f8dvendige data, overv\u00e5ge deres integritet og bestemme \u00e6ndringsdeltaer. Her er for eksempel en standard datakilde for medarbejderattributter 0EMPLOYEE_ATTR:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/fff6e630fec37faf0e6224a4b64a007f.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nResultatet af dataekstraktionen for \u00e9n medarbejder:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/126eb3e74b57d0116db9272b5695f39d.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nOm n\u00f8dvendigt kan en s\u00e5dan ekstraktor tilpasses specifikke krav, eller der kan oprettes en egen ekstraktor. <\/p>\n<p>Ideen om muligheden for genbrug opstod f\u00f8rst. Desv\u00e6rre viste det sig at v\u00e6re en urealiserbar opgave. St\u00f8rstedelen af logikken er implementeret p\u00e5 SAP BW-siden, og det var ikke muligt at adskille ekstraktoren p\u00e5 kilden fra SAP BW uden problemer. <\/p>\n<p>Det blev klart, at der var behov for at udvikle en egen mekanisme til dataudtr\u00e6k fra SAP-systemer. <\/p>\n<h3>Dataopbevaringsstrukturen i SAP HCM<\/h3>\n<p>\nFor understanding the requirements for such a mechanism, we must first determine which specific data we will need.<\/p>\n<p>Most data in SAP HCM is stored in flat SQL tables. Based on this data, SAP applications visualize organizational structures, employees, and other HR information to the user. For example, this is what the organizational structure looks like in SAP HCM:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/2f60b2062467fcfa425b5d02fbf6a45d.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPhysically, such a tree is stored in two tables \u2014 in hrp1000 objects and in hrp1001 the links between these objects. <\/p>\n<p>Objects \"Department 1\" and \"Management 1\":<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/d8a8c9ecc1a0023ae6cc9d5a78111a9c.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nThe link between objects:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/07bb44acfc8d8d10d895ecc790b9e3a2.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nThere can be a vast number of both object types and connection types between them. There are standard connections between objects as well as customized ones for specific needs. For example, the standard connection B012 between an organizational unit and a position indicates the manager of the department.<\/p>\n<p>Displaying the manager in SAP:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/fb636054004f8c0f06a6edcdec971664.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nStorage in the database table:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/6ec59a249b80ac7fa1ed5a243532af58.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nEmployee data is stored in tables pa*. For example, data on employee personnel events is stored in the table pa0000.<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/97403c61cbc95aad064008c3956a970b.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nWe decided that GreenPlum will fetch the \"raw\" data, i.e. simply copy it from the SAP tables. And directly in GreenPlum, it will be processed and converted into physical objects (for instance, Department or Employee) and metrics (for example, average headcount).<\/p>\n<p>Approximately 70 tables were identified, the data from which needs to be transferred to GreenPlum. After this, we began working on the method of transferring this data.<\/p>\n<p>SAP offers a significant number of integration mechanisms. However, the simplest way \u2014 direct access to the database is prohibited due to licensing restrictions. Thus, all integration flows must be implemented at the level of <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/da\/server\/dts-los-angeles\/\"   title=\"server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3660\">server<\/a> applications. <br \/>\nThe next problem was the absence of data on deleted records in the SAP database. When a row is deleted in the database, it is physically removed. That is, forming a delta of changes over the time of change was not possible.<\/p>\n<p>Of course, SAP HCM has mechanisms for recording data changes. For subsequent transmission to receiving systems, there are change pointers that record any changes and based on which Idoc (an object for transferring to external systems) is generated.<\/p>\n<p>Eksempel p\u00e5 IDoc \u00e6ndring af infotypen 0302 for en medarbejder med personalenummer 1251445:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/029509bbb519b7dd9703f8d4dac0f269.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nEller logf\u00f8ring af \u00e6ndringer i data i tabellen DBTABLOG.<\/p>\n<p>Eksempel p\u00e5 log for sletning af posten med n\u00f8gle QK53216375 fra tabellen hrp1000:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/5772891975d494da11cc530ed5cb533e.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nMen disse mekanismer er ikke tilg\u00e6ngelige for alle n\u00f8dvendige data, og deres behandling p\u00e5 serverniveau kan kr\u00e6ve en del ressourcer. Derfor kan en massiv aktivering af logf\u00f8ring for alle n\u00f8dvendige tabeller f\u00f8re til m\u00e6rkbar degradering af systemets ydeevne. <\/p>\n<p>Et n\u00e6ste alvorligt problem var klyngede tabeller. Data vedr\u00f8rende tidsbed\u00f8mmelse og l\u00f8nberegning i RDBMS version SAP HCM opbevares som et s\u00e6t logiske tabeller for hver medarbejder pr. beregning. Disse logiske tabeller gemmes som bin\u00e6re data i tabellen pcl2.<\/p>\n<p>Klynge for l\u00f8nberegning:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/18bfd42ec7c43018d5c156eea9b5ed23.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nData fra klyngetabeller kan ikke l\u00e6ses med en SQL-kommando, men kr\u00e6ver brug af SAP HCM makrobefalinger eller specielle funktionsmoduler. Derfor vil l\u00e6sehastigheden for s\u00e5danne tabeller v\u00e6re relativt lav. P\u00e5 den anden side indeholder s\u00e5danne klynger data, der kun er n\u00f8dvendige en gang om m\u00e5neden \u2013 den samlede l\u00f8nberegning og tidsbed\u00f8mmelse. S\u00e5 hastigheden er ikke s\u00e5 kritisk i dette tilf\u00e6lde. <\/p>\n<p>Ved at vurdere mulighederne for dannelse af \u00e6ndringsdeltaer besluttede vi ogs\u00e5 at se p\u00e5 muligheden for en fuld eksport. Muligheden for dagligt at overf\u00f8re gigabyte af u\u00e6ndrede data mellem systemerne ser ikke s\u00e6rlig appetitlig ud. Men den har ogs\u00e5 flere fordele \u2013 der er ikke behov for hverken at implementere deltaen p\u00e5 kildesiden eller at integrere denne delta p\u00e5 modtagerens side. Dette reducerer omkostningerne og tidsrammerne for implementeringen samt \u00f8ger p\u00e5lideligheden af integrationen. Det blev konstateret, at n\u00e6sten alle \u00e6ndringer i SAP HR finder sted inden for en periode p\u00e5 tre m\u00e5neder f\u00f8r den nuv\u00e6rende dato. Dermed blev beslutningen truffet om at stoppe ved en daglig fuld eksport af data fra SAP HR for N m\u00e5neder f\u00f8r den nuv\u00e6rende dato og om en m\u00e5nedlig fuld eksport. Parameteren N afh\u00e6nger af den specifikke tabel<br \/>\n og varierer fra 1 til 15.<\/p>\n<p>Der blev foresl\u00e5et f\u00f8lgende skema for datakstraktion:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/298df4f63c6ea4779c49927048e66ec3.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nDet eksterne system genererer en foresp\u00f8rgsel og sender den til SAP HCM, hvor foresp\u00f8rgslen kontrolleres for datal\u00f8shed og adgangsretter til tabellerne. Ved en vellykket kontrol udf\u00f8res et program i SAP HCM, som indsamler de n\u00f8dvendige data og sender dem til integreringsl\u00f8sningen Fuse. Fuse bestemmer det n\u00f8dvendige emne i Kafka og sender dataene dertil. Derefter overf\u00f8res dataene fra Kafka til Stage Area GP.<\/p>\n<p>I denne k\u00e6de er vi interesserede i sp\u00f8rgsm\u00e5let om dataudvinding fra SAP HCM. Lad os se n\u00e6rmere p\u00e5 det. <\/p>\n<p>Samarbejdsschema for SAP HCM-FUSE.<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/eeb50901515e019567223044d46c3879.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nDet eksterne system bestemmer tidspunktet for den seneste vellykkede foresp\u00f8rgsel til SAP.<br \/>\nProcessen kan startes ved timer eller en anden begivenhed, inklusiv at der kan v\u00e6re en timeout for at vente p\u00e5 svar med data fra SAP og initiering af en gentagen foresp\u00f8rgsel. Derefter dannes en delta-foresp\u00f8rgsel, som sendes til SAP.<\/p>\n<p>Dataene i foresp\u00f8rgslen sendes i body i json-format.<br \/>\nHttp-metode: POST.<br \/>\nEksempel p\u00e5 foresp\u00f8rgsel:<\/p>\n<p><img decoding=\"async\" alt=\"Dataudtr\u00e6k fra SAP HCM til non-SAP datalagre\" src=\"\/wp-content\/uploads\/2020\/09\/00bc84714a0f650b736109c3bcd2a5e5.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n <br \/>\nSAP-tjenesten udf\u00f8rer kontrol af foresp\u00f8rgslen for fuldst\u00e6ndighed, overensstemmelse med den nuv\u00e6rende struktur for SAP, samt tilstedev\u00e6relsen af adgangstilladelse til den anmodede tabel. <\/p>\n<p>I tilf\u00e6lde af fejl returnerer tjenesten et svar med den relevante kode og beskrivelse. Ved vellykket kontrol opretter den en baggrundsproces for at generere en dataudtr\u00e6k, genererer og synkront returnerer en unik session-id. <\/p>\n<p>Det eksterne system registrerer en fejl i loggen i tilf\u00e6lde af en fejl. Ved et vellykket svar overf\u00f8rer det session-id'et og navnet p\u00e5 tabellen, som foresp\u00f8rgslen blev lavet til.<\/p>\n<p>Det eksterne system registrerer den aktuelle session som \u00e5ben. Hvis der er andre sessioner p\u00e5 den p\u00e5g\u00e6ldende tabel, lukkes de med registrering af en advarsel i loggen.<\/p>\n<p>Den baggrundsopgave i SAP danner en cursor baseret p\u00e5 de givne parametre og et datarapport i en given st\u00f8rrelse. St\u00f8rrelsen af datapakken er det maksimale antal poster, som processen l\u00e6ser fra databasen. Standardv\u00e6rdien er 2000. Hvis der i databasens udtr\u00e6k er flere poster end den anvendte pakke st\u00f8rrelse, dannes n\u00e6ste blok med den relevante offset og inkrementerede pakkenummer efter overf\u00f8rsel af den f\u00f8rste pakke. Numrene inkrementeres med 1 og sendes strikt sekventielt. <\/p>\n<p>Derefter sender SAP pakken til indgangen af en webservice i et eksternt system. Dette system kontrollerer den indkommende pakke. Der skal v\u00e6re registreret en session med det modtagne id, og den skal v\u00e6re i \u00e5ben status. Hvis pakkenummeret &gt; 1, skal der v\u00e6re registreret en succesfuld modtagelse af den forrige pakke (package_id-1).<\/p>\n<p>Ved en vellykket kontrol parser det eksterne system data fra tabellen og gemmer den.<\/p>\n<p>Derudover, hvis pakken indeholder flaget final, og serialiseringen er lykkedes, sendes der en meddelelse til integrationsmodulet om, at sessionen er blevet behandlet med succes, og modulet opdaterer sessionens status.<\/p>\n<p>I tilf\u00e6lde af fejl ved kontrollerne\/parsing logges fejlen, og pakkerne for denne session vil blive afvist af det eksterne system.<\/p>\n<p>Og omvendt, n\u00e5r det eksterne system returnerer en fejl, logges den, og overf\u00f8rslen af pakker stoppes.<\/p>\n<p>For at anmode om data fra SAP HCM er der blevet implementeret en integrationsservice. Servicen er bygget p\u00e5 ICF-rammev\u00e6rket (SAP Internet Communication Framework - <noindex><a rel=\"nofollow\" href=\"https:\/\/help.sap.com\/viewer\/6da7259a6c4b1014b7d5e759cc76fd22\/7.01.22\/en-US\/488d6e0ea6ed72d5e10000000a42189c.html\">help.sap.com\/viewer\/6da7259a6c4b1014b7d5e759cc76fd22\/7.01.22\/en-US\/488d6e0ea6ed72d5e10000000a42189c.html<\/a><\/noindex>). Den g\u00f8r det muligt at anmode om data fra SAP HCM-systemet fra bestemte tabeller. N\u00e5r dataanmodningen oprettes, er der mulighed for at angive en liste over specifikke felter og filtreringsparametre for at opn\u00e5 de n\u00f8dvendige data. Implementeringen af servicen inkluderer ikke nogen forretningslogik. Algoritmer til beregning af delta, anmodningsparametre, integritetskontrol osv. implementeres ogs\u00e5 i det eksterne system.<\/p>\n<p>Denne mekanisme g\u00f8r det muligt at samle og overf\u00f8re alle n\u00f8dvendige data p\u00e5 f\u00e5 timer. Denne hastighed er p\u00e5 gr\u00e6nsen til acceptabel, s\u00e5 denne l\u00f8sning betragtes af os som midlertidig, og den har d\u00e6kket behovet for et ekstraktionsv\u00e6rkt\u00f8j i projektet.<br \/>\nI det m\u00e5lrettede billede for l\u00f8sningen af dataekstraktionsopgaven unders\u00f8ges mulighederne for at bruge CDC-systemer som Oracle Golden Gate eller ETL-v\u00e6rkt\u00f8jer som SAP DS.<br \/>\n<br \/>Kilde: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/X5RetailGroup\/blog\/520234\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\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 [&hellip;]<\/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<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\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.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/da\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"da_DK\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\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\" \/>\n\t\t<meta property=\"og:description\" content=\"\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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/da\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-09-24T17:42:23+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-09-24T17:42:23+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Dataekstraktion fra SAP HCM til non-SAP datalagre | ProHoster","description":"Som bekendt tilbyder SAP et komplet udvalg af software til b\u00e5de h\u00e5ndtering af transaktionsdata og til behandling af disse data i analyse- og rapporteringssystemer.","canonical_url":"https:\/\/prohoster.info\/da\/blog\/administrirovanie\/ekstrakcziya-dannyh-iz-sap-hcm-v-non-sap-hranilishha-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"da_DK","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\/da\/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\/da\/wp-json\/wp\/v2\/posts\/95021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/comments?post=95021"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/95021\/revisions"}],"predecessor-version":[{"id":162188,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/95021\/revisions\/162188"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media\/95022"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media?parent=95021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/categories?post=95021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/tags?post=95021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}