{"id":4723,"date":"2016-09-07T18:35:49","date_gmt":"2016-09-07T18:35:49","guid":{"rendered":"https:\/\/enterprisemindfactory.com\/?portfolio=etl"},"modified":"2022-08-01T18:10:10","modified_gmt":"2022-08-01T18:10:10","slug":"etl","status":"publish","type":"portfolio","link":"https:\/\/enterprisemindfactory.com\/?portfolio=etl&lang=en","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;\">Module ETL<\/span><\/h3>\n<p>Module EM-ETL (Extract, Transform, Load) supports you in the ETL processes. The objective is to extract the data from the various internal and external data sources, prepare it and load it into the Big Data database according to the data model. To achieve a high degree of automation, the ETL processes can be scheduled as jobs. For this purpose, the module offers you the following functionalities:<\/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>Capture ETL processes, assign responsibilities, and perform manually. To avoid double entry, most of the data is taken from the Process Management and Data Management modules. By changing the status, the release into production takes place here.<\/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\">Creation<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>Design the ETL process by defining the data source, data structure and fields, and transformation and mapping. The ETL process can then be tested.<\/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\">Planning<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>Summary of ETl processes to ETL jobs. To achieve a high level of automation, ETL jobs can be scheduled daily, weekly or monthly.<\/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\">Tracking<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>The ETL jobs are displayed in the calendar as appointments. This makes it possible to track which ETL jobs are scheduled, which have already been processed, and to what extent errors have occurred during processing.<\/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":[70],"_links":{"self":[{"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=\/wp\/v2\/portfolio\/4723"}],"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=4723"}],"version-history":[{"count":3,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=\/wp\/v2\/portfolio\/4723\/revisions"}],"predecessor-version":[{"id":4735,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=\/wp\/v2\/portfolio\/4723\/revisions\/4735"}],"wp:attachment":[{"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4723"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4723"},{"taxonomy":"portfolio_entries","embeddable":true,"href":"https:\/\/enterprisemindfactory.com\/index.php?rest_route=%2Fwp%2Fv2%2Fportfolio_entries&post=4723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}