{"id":3374,"date":"2016-09-07T18:35:49","date_gmt":"2016-09-07T18:35:49","guid":{"rendered":"http:\/\/c-bps.com\/?post_type=portfolio&#038;p=3374"},"modified":"2022-05-30T20:04:07","modified_gmt":"2022-05-30T20:04:07","slug":"etl","status":"publish","type":"portfolio","link":"https:\/\/enterprisemindfactory.com\/?portfolio=etl","title":{"rendered":"ETL"},"content":{"rendered":"<div class=\"flex_column av_two_third  flex_column_div first  avia-builder-el-0  el_before_av_one_third  avia-builder-el-first  \" ><div   data-size='no scaling'  data-lightbox_size='large'  data-animation='slide'  data-conditional_play=''  data-ids='3485'  data-video_counter='0'  data-autoplay='true'  data-bg_slider='false'  data-slide_height=''  data-handle='av_slideshow'  data-interval='5'  data-class=' avia-builder-el-1  avia-builder-el-no-sibling  '  data-el_id=''  data-css_id=''  data-scroll_down=''  data-control_layout='av-control-default'  data-custom_markup=''  data-perma_caption=''  data-autoplay_stopper='1'  data-image_attachment=''  data-min_height='0px'  class='avia-slideshow avia-slideshow-1  av-control-default av-default-height-applied avia-slideshow-no scaling av_slideshow  avia-builder-el-1  avia-builder-el-no-sibling   avia-slide-slider '  itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><ul class='avia-slideshow-inner ' style='padding-bottom: 56.521739130435%;' ><li  class=' av-single-slide slide-1 ' ><div data-rel='slideshow-1' class='avia-slide-wrap '   ><img class=\"wp-image-3485\"  src=\"https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1.jpg\" width='2300' height='1300' title='ETL_1' alt=''  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1.jpg 2300w, https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1-300x170.jpg 300w, https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1-1030x582.jpg 1030w, https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1-768x434.jpg 768w, https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1-1536x868.jpg 1536w, https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1-2048x1158.jpg 2048w, https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1-1500x848.jpg 1500w, https:\/\/enterprisemindfactory.com\/wp-content\/uploads\/2016\/09\/ETL_1-705x398.jpg 705w\" sizes=\"(max-width: 2300px) 100vw, 2300px\" \/><\/div><\/li><\/ul><\/div><\/div><div class=\"flex_column av_one_third  flex_column_div av-zero-column-padding   avia-builder-el-2  el_after_av_two_third  avia-builder-el-last  \" style='border-radius:0px; '><section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock  '   itemprop=\"text\" ><h3><span style=\"color: #67619e;\">Modul\u00a0ETL<\/span><\/h3>\n<p>Modul EM-ETL (Extract, Transform, Load) unterst\u00fctz Sie bei den ETL-Prozessen. Zielsetzung ist es, die Daten aus den verschiedenen internen und externen Datenquellen\u00a0zu extrahieren, aufzubereiten und in die Big Data Datenbank entsprechend dem Datenmodell\u00a0zu laden. Um\u00a0einen hohen Automatisierungsgrad zu erreichen k\u00f6nnen die ETL-Prozesses als\u00a0Jobs terminiert werden. Hierf\u00fcr\u00a0bietet Ihnen das\u00a0Modul\u00a0folgende Funktionalit\u00e4ten an:<\/p>\n<\/div><\/section><br \/>\n<div  class=\"togglecontainer   toggle_close_all  avia-builder-el-4  el_after_av_textblock  avia-builder-el-last \" >\n<section class=\"av_toggle_section\"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\"  >    <div role=\"tablist\" class=\"single_toggle\" data-tags=\"{Alle} \"  >        <p data-fake-id=\"#toggle-id-1\" class=\"toggler \"  itemprop=\"headline\"    role=\"tab\" tabindex=\"0\" aria-controls=\"toggle-id-1\">Management<span class=\"toggle_icon\" >        <span class=\"vert_icon\"><\/span><span class=\"hor_icon\"><\/span><\/span><\/p>        <div id=\"toggle-id-1\" class=\"toggle_wrap \"  >            <div class=\"toggle_content invers-color \"  itemprop=\"text\"   ><p>Erfassung der ETL-Prozesse, Zuordnung der Verantwortlichkeiten und manuelle Durchf\u00fchrung. Um Doppelerfassung zu vermeiden, werden die meisten Daten aus den Modulen Prozessmanagement und Datenmanagement \u00fcbernommen.\u00a0Mittels Ver\u00e4nderung des Status\u00a0erfolgt hier die Freigabe in die Produktion.<\/p>\n            <\/div>        <\/div>    <\/div><\/section>\n<section class=\"av_toggle_section\"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\"  >    <div role=\"tablist\" class=\"single_toggle\" data-tags=\"{Alle} \"  >        <p data-fake-id=\"#toggle-id-2\" class=\"toggler \"  itemprop=\"headline\"    role=\"tab\" tabindex=\"0\" aria-controls=\"toggle-id-2\">Erstellung<span class=\"toggle_icon\" >        <span class=\"vert_icon\"><\/span><span class=\"hor_icon\"><\/span><\/span><\/p>        <div id=\"toggle-id-2\" class=\"toggle_wrap \"  >            <div class=\"toggle_content invers-color \"  itemprop=\"text\"   ><p>Konzeption\u00a0des ETL-Prozesses durch Festlegung der Datenquelle, Datenstruktur und Felder, sowie Transformation und Zuordnung. Anschlie\u00dfend kann der ETL-Prozess \u00a0getestet werden.<\/p>\n            <\/div>        <\/div>    <\/div><\/section>\n<section class=\"av_toggle_section\"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\"  >    <div role=\"tablist\" class=\"single_toggle\" data-tags=\"{Alle} \"  >        <p data-fake-id=\"#toggle-id-3\" class=\"toggler \"  itemprop=\"headline\"    role=\"tab\" tabindex=\"0\" aria-controls=\"toggle-id-3\">Planung<span class=\"toggle_icon\" >        <span class=\"vert_icon\"><\/span><span class=\"hor_icon\"><\/span><\/span><\/p>        <div id=\"toggle-id-3\" class=\"toggle_wrap \"  >            <div class=\"toggle_content invers-color \"  itemprop=\"text\"   ><p>Zusammenfassung der ETl-Prozesse zu ETL-Jobs. Um einen hohen Automatisierungsgrad zu erreichen, \u00a0k\u00f6nnen die\u00a0ETL-Jobs t\u00e4glich, w\u00f6chentlich oder monatlich terminiert werden.<\/p>\n            <\/div>        <\/div>    <\/div><\/section>\n<section class=\"av_toggle_section\"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\"  >    <div role=\"tablist\" class=\"single_toggle\" data-tags=\"{Alle} \"  >        <p data-fake-id=\"#toggle-id-4\" class=\"toggler \"  itemprop=\"headline\"    role=\"tab\" tabindex=\"0\" aria-controls=\"toggle-id-4\">Nachverfolgung<span class=\"toggle_icon\" >        <span class=\"vert_icon\"><\/span><span class=\"hor_icon\"><\/span><\/span><\/p>        <div id=\"toggle-id-4\" class=\"toggle_wrap \"  >            <div class=\"toggle_content invers-color \"  itemprop=\"text\"   ><p>Die ETL-Jobs werden\u00a0im Kalender als Termine angezeigt. Damit kann nachverfolgt werden, welche ETL-Jobs geplant sind, welche bereits abgearbeitet wurden und inwieweit\u00a0Fehler bei der Bearbeitung erfolgt\u00a0sind.<\/p>\n            <\/div>        <\/div>    <\/div><\/section>\n<\/div><\/p><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excerpt goes here!<\/p>\n","protected":false},"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","tags":[],"portfolio_entries":[14],"_links":{"self":[{"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=\/wp\/v2\/portfolio\/3374"}],"collection":[{"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=\/wp\/v2\/types\/portfolio"}],"replies":[{"embeddable":true,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3374"}],"version-history":[{"count":2,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=\/wp\/v2\/portfolio\/3374\/revisions"}],"predecessor-version":[{"id":3484,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=\/wp\/v2\/portfolio\/3374\/revisions\/3484"}],"wp:attachment":[{"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3374"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3374"},{"taxonomy":"portfolio_entries","embeddable":true,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=%2Fwp%2Fv2%2Fportfolio_entries&post=3374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}