');height:32px;width:32px;vertical-align:middle;}.header-mobile-menu.show{transform:none;}a.contact-phonenumber-button{display:inline-block;font-weight:bold;width:auto;line-height:1em;margin-top:25px;border:1px solid #ddd;background:white;padding:5px;padding-left:6px;padding-right:6px;padding-top:8px;border-radius:5px;position:relative;z-index:1000;}a.contact-phonenumber-button:before{content:"";height:20px;width:20px;display:inline-block;padding-right:5px;vertical-align:middle;margin-top:-2px;background-size:contain;background-repeat:no-repeat;background-image:url('data:image/svg+xml, ');}.body .header a{text-decoration:none;}.header-part-2{display:block;}.header-part-1{width:15%;}.domain-www-biaward-nl .header-part-1{width:23%;}.header-part-2{width:63%;}.domain-www-biaward-nl .header-part-2{width:57%;}.header-part-3{text-align:right;width:auto;font-size:18px;}.header-mobile-menu{color:white;float:left;padding-right:5px;font-size:30px;display:none;color:#ff5252;}.header-logo,a.header-company-name{padding-right:5px;float:left;}.header-logo{width:60px;height:60px;margin-top:13px;padding:10px;margin-left:-11px;margin-right:8px;background:white;border-radius:42px;position:relative;border:1px solid #ddd;box-shadow:0px 4px 16px #ddd;}.container-logo-white{height:40px;}a.header-company-name{margin-top:23px;line-height:1.1em;max-width:100px;font-size:18px;color:#707070;}.domain-www-biaward-nl a.header-company-name{max-width:175px;}*{box-sizing:border-box;}.search-icon{position:relative;margin-left:10px;float:left;transition:transform 0.3s ease-out;padding-top:27px;cursor:pointer;}.search-icon:after{background-image:url('data:image/svg+xml, ');}.show{display:block !important;}.hide{display:none;}.header-menu-container{display:-webkit-box;display:-ms-flexbox;display:flex;justify-content:center;flex-direction:row;line-height:1.8;}.header-menu-container.hide{display:none;}.sub-menu-container{display:none;}.menu-item{max-height:83px;display:inline-block;overflow-y:hidden;overflow-x:hidden;white-space:nowrap;font-weight:normal;position:relative;cursor:pointer;}.menu-item a.mia{height:83px;max-height:83px;overflow:hidden;display:inline-block;padding-right:5px;padding-left:10px;padding-top:27px;padding-bottom:27px;font-weight:bold;}#menu-item-1 .mia:after{content:"";display:inline-block;background-size:contain;background-repeat:no-repeat;background-image:url('data:image/svg+xml, ');height:32px;width:32px;margin-top:-4px;}.menu-item.hide-nav{display:none;}.menu-item.hide-sub-menu a,.menu-item .sub-menu-container a{color:inherit;}.header-menu-container .menu-item:hover> a{color:#ff5252;background:white;box-shadow:0px 4px 16px #eee;}.body .header-menu-container .menu-item a.mia:after,.list-read-more-button:after,.advanced-more:after{content:"";background-size:contain;background-repeat:no-repeat;height:20px;width:20px;margin-left:-2px;vertical-align:middle;display:inline-block;background-image:url('data:image/svg+xml, ');}.body .header-menu-container .menu-item.no-sub-menu a.mia:after{background-image:none;height:0px;width:8px;}.header-menu-container .menu-item:not(.no-sub-menu):hover{overflow-y:visible;overflow-x:visible;}.header-menu-container .menu-item:hover> .sub-menu-container{display:inline-block;}.body .header-menu-container .sub-menu-container a:after{display:none;}.container-h1{width:100%;position:relative;margin-top:90px;margin-bottom:85px;border-radius:5px;border:1px solid #ddd;background:white;padding:30px;padding-top:40px;display:inline-block;box-shadow:0px 4px 16px #eee;}.is-product .container-h1{padding-top:50px;padding-bottom:40px;}.toc-is-open .container-h1{margin-bottom:0px;}.container-h1 .pdf{cursor:pointer;color:#aaa;width:auto;font-size:15px;display:block;line-height:1.1em;margin-top:-15px;}.container-h1 .pdf:before{content:"\00AB";padding-right:3px;}.container-h1 .pdf:after{content:"\00BB";padding-left:3px;}.intro{margin-right:30px;}.article .intro a:not(.important){color:black;}.article .intro .nav-buttons a,.article .intro a:not(.important):hover{color:#ff5252;}.featured-image-container{float:right;width:50%;margin-top:7px;position:relative;margin-left:30px;margin-bottom:25px;}.product-cat-1 .featured-image-container{width:50%;padding-left:40px;padding-right:40px;margin-top:0px;z-index:1;transition:transform 0.5s;}.body.product-cat-1 .container-content h2.first-h2{bottom:50px;background:white;font-weight:bold;}.container-content h2.first-h2{position:absolute;bottom:40px;right:15px;padding:8px;font-weight:bold;border-top-left-radius:5px;border-bottom-left-radius:5px;font-size:15px;background:white;max-width:75%;box-shadow:-7px -2px 32px white;}#first-h2{clear:none;}h2.first-h2.first-h2-length-4{max-width:65%;}h2.first-h2.first-h2-length-5{max-width:70%;}h2.first-h2.first-h2-length-6{max-width:75%;}h2.first-h2.first-h2-length-7{max-width:80%;}.container-h1 .social-media-share-icon{position:absolute;top:2px;right:10px;font-size:14px;}.container-h1 .col-2:hover> .social-media-share-icon{display:inline-block;}.error-404 .container-h1 .social-media-share-icon{display:none;}.container-h1 .social-media-share-icon:after{background-image:url('data:image/svg+xml, ');height:15px;width:15px;vertical-align:middle;margin-left:5px;}.container-h1 .social-media-share-icon:before{font-family:system-ui,Roboto;color:#bbb;}.container-h1 .social-media-share-icon:hover:before{color:#505050;}.lang-nl .container-h1 .social-media-share-icon:before{content:"Deel deze pagina";}.lang-en .container-h1 .social-media-share-icon:before{content:"Share this page";}.post.lang-nl .container-h1 .social-media-share-icon:before{content:"Deel dit bericht";}.post.lang-en .container-h1 .social-media-share-icon:before{content:"Share this post";}.blog .container-h1,.portfolio .container-h1{margin-bottom:150px;}.article a.intro-table-author,.article span.intro-table-author{display:table;font-size:16px;width:100%;color:black;border-bottom:0px;max-width:450px;}.intro-table-author .column-1{width:100px;display:table-cell;vertical-align:middle;}.intro-table-author .column-2{display:table-cell;vertical-align:middle;padding-left:20px;line-height:1.7em;padding-right:20px;padding-bottom:10px;}.article .intro-table-author a{border:0px;color:black;}.intro-table-author .column-1 img{width:100px !important;object-fit:cover;border-radius:15px;height:100px;background:#f0f0f0;transition:transform 0.5s;}.intro-table-author:hover .column-1 img{transform:scale(1.05);}.container-content{margin-top:25px !important;display:inline-block;line-height:2.2em;width:100%;}.container-content p{margin-bottom:32px;}.article .ec h2,.article .box h2{padding-right:0px;}.container-content .article{margin-bottom:70px;position:relative;margin-left:15%;margin-right:15%;}.container-content h2{margin-bottom:5px;}.container-content .box h2{margin-top:20px;}ul li.limb,ul.limb> li,ol li.limb,ol.limb> li{margin-bottom:15px !important;}input,select,textarea{box-sizing:border-box;background-color:#fff;border:1px solid #ccc;border-radius:5px;box-shadow:none;font-size:17px;font-weight:400;line-height:1;padding:15px;width:100%;}.mb10{margin-bottom:10px;}.action-button,.black-button,.glass-button{display:inline-block;text-decoration:none !important;background:#ff5252;color:#ffffff !important;cursor:pointer;font-weight:bold;padding:12px 24px !important;text-align:center;width:auto;white-space:normal;overflow-wrap:break-word;text-decoration:none;border-bottom:0px !important;border-radius:5px;line-height:1.7em;transition:background 0.5s 0s;}.action-button.small,.black-button.small,.glass-button.small{font-size:16px;padding:6px 8px !important;margin-bottom:10px;}.action-button:first-letter,.black-button:first-letter,.glass-button:first-letter{text-transform:uppercase;}.glass-button:after{color:#ff5252;}.glass-button{background:transparent !important;color:black !important;border:1px solid black !important;transition:none;padding:10px 24px !important;}.glass-button:hover{color:white !important;background:#f24a4a !important;border:1px solid #f24a4a !important;}.glass-button:hover::after{color:white !important;}.action-button:hover{text-decoration:none !important;background:#f24a4a;}.black-button{border:1px solid black !important;color:#ffffff !important;}.black-button:hover{text-decoration:none !important;background:#f24a4a;}.tac{text-align:center;line-height:1.6;clear:both;}.tar{text-align:right;line-height:1.6;clear:both;}.staracademy{font-weight:300;color:#FF5252;padding-right:2px;}.disablephone{visibility:hidden;}.star.full:before,.star.half:before,.star.zero:before{content:"";display:inline-block;background-size:contain;background-repeat:no-repeat;background-image:url('data:image/svg+xml, ');height:32px;width:32px;margin-top:-1px;vertical-align:middle;}.star.half:before{background-image:url('data:image/svg+xml, ');}.star.zero:before{background-image:url('data:image/svg+xml, ');}.image-area-reviews .star:before{margin-top:-3px;}.heading-product.training .dates:before,.praktische-info .practicalthings td.fwb.dates:before,.post-meta-date-icon.calendar_month:before{background-image:url('data:image/svg+xml, ');}.body.product-cat-3 h1,.body.product-cat-1 h1{margin-bottom:0px;}.toc-button{clear:both;font-size:15px;position:absolute;bottom:-16px;cursor:pointer;line-height:1.6em;left:50%;transform:translateX(-50%);border:1px solid #ddd;border-radius:5px;padding:3px;padding-left:5px;padding-right:7px;background:floralwhite;z-index:500;white-space:nowrap;}.js-disabled .toc-button{display:none;}.body .featured-image img,.body img.featured-image{width:90%;display:block;object-fit:cover;border-radius:5px;border:15px solid #f5f5f5;margin-left:10%;}.body.product-cat-1 .featured-image img,.body.product-cat-1 img.featured-image{border:0px;border-radius:0px;box-shadow:none;width:100%;margin-left:0px;}a.image-area-reviews{display:none;position:absolute;top:-23px;padding:3px;padding-left:8px;padding-right:10px;margin-left:0px;color:#ff5252;font-weight:normal;border-radius:5px;border:1px solid #ddd !important;left:50%;transform:translateX(-50%);visibility:visible;display:inline-block;background:#f8f8f8;}.intro-consultant-image{width:40%;border-radius:80px;}.action-button:after,.display-form-next-page-button:after,.display-form-submit-button:after,.article .heading-product a.cell.order-button:after{content:"";display:inline-block;background-size:contain;background-repeat:no-repeat;background-image:url('data:image/svg+xml, ');height:20px;width:20px;margin-top:-2px;vertical-align:middle;margin-left:5px;}.image-area-reviews.disable-page-rating{display:none !important;}.container-content .image-area-reviews .star{margin-right:0px;line-height:1.4;float:left;font-size:24px;display:inline-block;}.image-area-reviews .star-number{text-decoration:none !important;padding-left:5px;line-height:2;font-weight:bold;color:black;display:block;float:right;}.image-align-right{float:right;width:50%;}.portrait-photo{border:5px solid white !important;background-image:initial;border-radius:5px;box-shadow:0px 2px 4px #ccc;background-size:100% 200%;margin-right:10px;}.alignright.portrait-photo{margin-top:15px !important;margin-left:40px !important;}.alignleft{float:left;text-align:left;margin-top:10px !important;}.alignright{float:right;text-align:right;margin-top:15px !important;}.container-content .alignright{margin-left:15px;margin-bottom:10px;max-width:none;}a.alignleft,a.alignnone,a.alignright{max-width:100%;}.error-404 .bread-crumb-container{display:none;}.post-content-container{width:62%;float:left;margin-bottom:30px;}.display-form-embedded .post-content-container{width:100%;float:none;}.sidebar-content{margin-top:80px;line-height:1.7em;font-size:14px;height:auto;width:23.25%;position:relative;float:right;}.sidebar-widget{margin-bottom:80px;border:1px solid #eee;border-top-left-radius:5px;border-top-right-radius:5px;box-shadow:0px 4px 64px #fbfbfb;}.article a.sidebar-widget{display:block;color:black;border:1px solid #eee;}.sidebar-widget> p,.sidebar-widget> ul{padding-left:15px;padding-right:15px;margin-bottom:15px;}.sidebar-widget> ul.check-list{margin-left:-20px !important;}.sidebar-widget> ul{margin-left:-5px !important;}.sidebar-widget h2,.sidebar-widget h3,.sidebar-widget h4{font-size:16px;padding:15px;padding-top:15px;padding-bottom:15px;text-align:center;margin-bottom:15px;background:#f5f5f5;border-top-left-radius:5px;border-top-right-radius:5px;font-weight:bold;}.sidebar-widget .check-list{margin-top:5px;}.sidebar-widget p.tac{margin-bottom:10px;}@media (min-width:2200px){.container-content .article{margin-left:8%;margin-right:8%;}.header{padding-left:8%;padding-right:8%;}.body{font-size:24px;}.body h2{font-size:32px;}.body h3{font-size:28px;}.body h4,.body h5{font-size:26px;}.sidebar-content{width:25% !important;}.body .box ol{margin-left:-5px !important;}.body ol{margin-left:-15px !important;}.action-button,.black-button,.glass-button{padding:16px 16px !important;line-height:1.9;padding-bottom:18px !important;}.header-menu-container{font-size:22px;}.search-icon{max-height:45px;}.header-part-1{width:15%;}.header-part-2{width:67%;}.menu-item a.mia{padding-right:30px;padding-left:30px;padding-top:26px;padding-bottom:20px;}.container-content .image-area-reviews .star{line-height:2em;}.image-area-reviews .star:before{width:32px !important;height:32px !important;}.container-content .stars-global-reviews .star{margin-right:10px !important;}.star.full:before,.star.half:before,.star.zero:before{width:45px;height:45px;}}@media (min-width:2000px) and (max-width:2199px){.container-content .article{margin-left:18%;margin-right:18%;}.header{padding-left:18%;padding-right:18%;}.sidebar-content{width:28% !important;}.body h2{font-size:28px;}.body h3{font-size:24px;}.body h4,.body h5{font-size:22px;}}@media (min-width:1800px) and (max-width:1999px){.body{font-size:18px !important;}.sidebar-content{width:27% !important;}.menu-item a.mia{padding-top:26px;padding-bottom:27px;padding-right:10px;padding-left:10px;}}@media (min-width:1600px) and (max-width:1800px){.container-content .article{margin-left:12%;margin-right:12%;}.header{padding-left:12%;padding-right:12%;}}@media (max-width:1600px){a.header-company-name{font-size:17px;}.header{padding-left:10%;padding-right:10%;}.container-content .article{margin-left:10%;margin-right:10%;}.post-content-container{width:63%;}.container-h1{margin-top:40px;}.intro-container{margin-top:50px;}}@media (max-width:1500px){.header{padding-left:5%;padding-right:5%;}.container-content .article{margin-left:5%;margin-right:5%;}.post-content-container{width:60%;}.container-content h2.first-h2{max-width:75%;}}@media (max-width:1400px) and (max-resolution:1.39dppx){.header{padding-left:6%;padding-right:6%;}.container-content .article{margin-left:6%;margin-right:6%;}.post-content-container{width:66%;}.header-part-3{font-size:15px;}.header-menu-container .menu-item a.mia{padding-top:29px;padding-bottom:27px;padding-left:7px;padding-right:7px;}.body .header-menu-container .menu-item a.mia:after{display:none;}a.header-company-name{max-width:65%;}}@media (max-width:1300px) and (max-resolution:1.39dppx){.header{padding-left:5%;padding-right:5%;}.container-content .article{margin-left:5%;margin-right:5%;}.post-content-container{width:67%;}h2.first-h2.first-h2-length-4,h2.first-h2.first-h2-length-5,h2.first-h2.first-h2-length-6,h2.first-h2.first-h2-length-7{max-width:90%;}.header-menu-container{font-size:14px;}.header-menu-container .menu-item a.mia{padding-top:30px;padding-bottom:31px;padding-right:6px;padding-left:6px;}}@media (max-width:1250px){.post-content-container{width:65%;}}@media (max-width:1200px){.header{padding-left:5%;padding-right:5%;}.container-content .article{margin-left:5%;margin-right:5%;}.sidebar-content{display:none;}.post-content-container{width:100%;padding-right:0;float:none;}.body.product-cat-3 h1{padding-bottom:10px;}.body.product-cat-3 .heading-product{font-size:14px;}.header-part-1{width:9%;}.header-part-2{width:70%;}a.header-company-name{display:none;}a.image-area-reviews{background:white;}}@media (max-width:1100px){#menu-item-1{display:none;}.header-part-3{font-size:13px;}}@media (max-width:1000px){.header-part-3{font-size:10px;}.header-menu-container{font-size:12px;}a.contact-phonenumber-button{padding-left:5px;padding-right:5px;}.header-menu-container .menu-item a.mia{padding-right:6px;padding-left:6px;padding-bottom:32px;padding-top:32px;}.header-menu-container .menu-item a.mia:after{display:none !important;}.blog .container-h1,.portfolio .container-h1{margin-bottom:100px;}.article .box h2{width:100%;}.action-button,.black-button,.glass-button{margin-bottom:15px;}.action-button:hover,.black-button:hover,.glass-button:hover{padding:12px 24px !important;}.container-content h2.first-h2{font-size:16px;}}@media (max-width:800px){.header{height:64px;box-shadow:none;}.header-logo{border:1px solid #CCC;margin-left:0;}.header-part-1{width:30%;}.alignleft,.alignright{max-width:250px !important;}.search-icon{display:none;}.header-part-2{width:0px;}.domain-www-biaward-nl .header-part-1{width:32%;}.domain-www-biaward-nl .header-part-2{width:auto;}.header-part-3{font-size:14px;}a.contact-phonenumber-button{padding-left:10px;padding-right:10px;margin-top:15px;}.header-menu-container .menu-item a.mia{display:none;}.header-logo{width:45px;height:45px;padding:8px;margin-top:9px;}.container-logo-white{height:30px;}.header-part-2{justify-content:right;}.search-icon{margin-top:15px;float:right;}.menu-item a.mia{padding-right:0;padding-left:0;padding-top:0;padding-bottom:0;}.container-content{margin-top:10px !important;}.body.page h1,.body.post h1{font-size:6vw !important;line-height:1.2;padding-right:20px;margin-top:15px !important;}.header-mobile-menu{margin-top:3px;display:inline-block;line-height:53px;height:53px;width:35px;transform:scaleY(1.3);font-weight:normal;margin-left:-5px;}.is-product .container-h1{padding-top:20px;padding-bottom:20px;}.image-area-reviews{display:none !important;}.container-h1 .social-media-share-icon{top:10px;right:10px;}.product-cat-1 .toc-button{display:none;}.featured-image-container{float:none;width:100%;margin-left:0px;margin-bottom:25px;}.body .featured-image img,.body img.featured-image{border-radius:0px;width:100%;margin-left:0px;border:1px;}.product-cat-1 .featured-image-container{width:100%;padding:0px;}.intro{margin-right:0px;}.article a.intro-table-author,.article span.intro-table-author{line-height:1.7em;}.body.toc-is-open .toc-container{border:1px solid #ccc !important;border-top:0px !important;}.container-content h2.first-h2{font-size:20px;padding-top:5px;padding-bottom:5px;right:0px;max-width:90%;}.body.product-cat-1 .container-content h2.first-h2{bottom:60px;}.body.plain h1{font-size:32px !important;}}@media (max-width:750px){.container-content{margin-top:15px !important;}}@media (max-width:650px){.body h1{padding-top:5px;padding-bottom:10px;font-size:36px;font-size:5vw !important;}.body h2{font-size:22px;}.body h3{font-size:20px;}.body h4,.body h5{font-size:18px;}.container-h1 .social-media-share-icon:before{display:none;}.alignleft,.alignright{width:40%;max-width:200px !important;}.container-h1{padding:0px !important;border:0px;text-align:center;box-shadow:none;background:white;margin-top:20px;margin-bottom:40px;}.container-h1 .social-media-share-icon{top:-10px;right:0px;}.body .container-h1 h1{font-size:30px !important;line-height:1.4;padding-right:0px;}.article a.intro-table-author,.article span.intro-table-author{font-size:12px;margin-bottom:10px;color:#707070;text-transform:uppercase;display:inline-block;}.intro-table-author .column-1{width:100%;margin-top:15px;margin-bottom:5px;display:inline-block;}.intro-table-author .column-1 img.portrait-photo{margin-right:0px;}.intro-table-author .column-2{width:100%;padding:0px;font-family:monospace;display:inline-block;}.article .heading-product a.cell,.article .heading-product span.cell{float:none;}.toc-button{display:none;}.container-h1 .pdf{margin-top:0px;}.featured-image-container{margin-top:10px;margin-bottom:40px;width:111%;margin-left:-5.5%;overflow-x:hidden;}.body.product-cat-1 .featured-image-container{margin-left:0%;}.body .featured-image img,.body img.featured-image{border:0px;}.container-content h2.first-h2,.body.product-cat-1 .container-content h2.first-h2{position:absolute;border:0px;bottom:20px;right:0px;background:white;padding:5px;margin-top:0px;font-size:14px !important;box-shadow:none;max-width:70%;}.body.product-cat-1 .container-content h2.first-h2{bottom:60px;}}@media (max-width:426px){.body{max-width:100% !important;overflow-x:hidden !important;}.header-logo{background:transparent;border:0px;}.header-part-3{font-size:12px;}a.contact-phonenumber-button{background:floralwhite;}.container-content{line-height:2em;}.container-content .article{margin-left:5%;margin-right:5%;}strong{font-weight:bold;}.display-form.free-product .container-content .article{margin-top:30px;}.product-features .extra-html{line-height:2em;}.container-content h2:not(.normal-expand-title,.first-h2,.display-form-group-h2,.ecm h2,.sba h2,.reviews h2,.box h2,.container-list-post h2,h2.faq-h2){font-size:20px !important;}.body.product-cat-1 .container-content h2.first-h2{bottom:40px;}.body .box ol{margin-left:-20px !important;}.alignleft,.alignright{width:35%;max-width:150px !important;}.alignright.ml25{margin-left:5px !important;}.alignleft.mr25{margin-right:5px !important;}.action-button,.black-button,.glass-button{padding:12px 16px !important;}}@media (max-width:375px){.header-part-1{width:35%;}}
Data Integration - advice, tools & training
Data Integration: challenges and overview of the tools Author: Daan van Beek Senior Data Integration consultant
Table of Contents
Manage your data flow Data Integration helps organizations manage their data and data flows efficiently. Organizations seldom use one system to capture all their company data. They frequently use different systems for specific purposes like customer relationship management (CRM) , Enterprise Resource Planning (ERP), finance, Human Resources, and so forth. In many cases, the same customer, product, or employee data is captured and stored in different systems in different formats for different purposes.
Many organizations face 3 big data integration challenges The use of different systems gives organizations a lot of flexibility. On the other hand, the huge amount of relevant (and also irrelevant) data outside the company creates three big data integration challenges for every company:
How to make sure that data elements are not getting obsolete? Changes in one system are not automatically transferred to other systems. How to create one view of the customer or employee data? Data in the different systems is not automatically combined in one database. How to combine external (big) data with company data easily? Read more about Big Data . Different technologies: EAI & ETL These three challenges are addressed in Data Integration. To get rid of the first challenge, organizations have to implement Enterprise Application Integration (EAI) technology. Often a Service Oriented Architecture (SOA) is used. A data warehouse has to be implemented to overcome the second challenge. In both cases, you should consider using ETL tools . To deal with the third challenge you also need a Business Intelligence tool with Big Data capabilities.
The fundaments of Business Intelligence To be able to make better decisions using KPIs and key insights across the enterprise, the data needs to be integrated and combined into one single system. Business Intelligence can’t be successful without a proper data integration layer. That layer takes care of unified definitions, improving the data quality, and combining data from different sources into a single table or cube, thus facilitating very fast response times. Data integration is the beating heart of the Intelligent Organization and it serves several vital functions. Also, read our article ‘9 reasons to build a data warehouse’ .
Overview of Data Integration tools Since 2007, we’ve been investigating a large number of data integration tools based on over 190 criteria that play a major role in the quick and successful development of a BI infrastructure . In our study, we concentrated on products that could be (relatively) easily used by either business or IT professionals with a minimum of specialized training. In our fully independent analysis (updated regularly) we have divided the products into four separate categories to avoid comparing apples with oranges.
1. Pure ETL Products These data integration tools are independent of the database and the Business Intelligence tool with which they will probably be used. The companies do not rely on another product providing the functionality they offer, and they allow you to migrate to another (relational) database or another Business Intelligence tool without having to substantially change your integration processes.
List of pure ETL products:
2. Database Integrated These data integration products are supplied as an option when you buy the database software; some of the functionality is built into the database and not available separately in the ETL tool itself. The ETL tool is database-dependent and will not work with another database, which is an intended part of the design. Replacement of the database would entail completely rewriting the integration processes.
List of database-integrated ETL products:
3. Business Intelligence Integrated These are products from the same supplier as the BI software . In many cases these are separate products and the supplier will claim that they can be used independently of the BI tool. This is probably true but because of their use of proprietary metadata, and sometimes the same scripting tools as the BI product, they are seldom used separately.
List of BI-integrated ETL products:
SAP Data Services SAS Data Integration Studio 4. Niche Products These are products that don’t fit well into any of the above-mentioned groups, but still have considerable ETL functionality in them. In most cases they’re not as complete as the other data integration tools we’ve looked at, but they’re often in a totally different price class and are very usable to solve certain problems. Traditionally we have included the Open Source products in this category since they lacked the full functionality and customer experience to qualify for the main categories.
Click here to see a complete list of data integration tools.
Interested in our data integration services and independent advice? Would you like to be informed about Data Integration and get professional, 100% vendor-independent advice? Contact us and we will get back to you as soon as possible.
About Passionned Group We are Passionned, experts in data integration and Business Analytics. Our experienced consultants help companies and other institutions build an intelligent organization. Every other year we present the Dutch BI & Data Science Award™ to the Smartest organization in the Netherlands.
contact us
A selection of our customers
You are here:
How to cite this article? Van Beek, D. (2024), Data Integration: challenges and overview of the tools. Consulted on [insert date here], from https://www.passionned.com/data-integration/
Would you like to link to this article? You can do so as follows: <a href="https://www.passionned.com/data-integration/">Passionned Group: Data Integration</a>