{"id":49366,"date":"2008-12-03T02:25:18","date_gmt":"2008-12-02T23:25:18","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=49366"},"modified":"2021-11-05T06:48:43","modified_gmt":"2021-11-05T03:48:43","slug":"the-dos-and-donts-of-data-integration","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/","title":{"rendered":"The Dos and Don\u2019ts of Data Integration"},"content":{"rendered":"<p><center><small>(Featured image credit: <a href=\"http:\/\/download.101com.com\/tdwi\/ww21\/0506wwd_E-mag.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">TDWI<\/a>, 2006)<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#Making_an_asset_of_your_database\" >Making an asset of your database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#Information_life_cycle_management\" >Information life cycle management<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#Tools_and_services\" >Tools and services<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Making_an_asset_of_your_database\"><\/span>Making an asset of your database<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Extracting and normalizing customer data from multiple sources is the biggest challenge with client data management (54%), according to <a href=\"https:\/\/www.destinationcrm.com\/Articles\/CRM-News\/CRM-Featured-Articles\/Companies-Still-Grapple-with-Effective-CDM-42660.aspx\" rel=\"noopener noreferrer\" target=\"_blank\">a report<\/a> the Aberdeen Group. OK, true, a lot of companies consider linking and migrating customer information between databases, files and applications a sticky, if not risky, process to deal with. Gartner says corporate developers spend approximately 65% of their effort building bridges between applications. That much! No wonder they risk losing lots and lots of data, not even mentioning the time and efforts this may involve.<\/p>\n<p>Commonly, a database is an integral part of a <a href=\"https:\/\/www.altoros.com\/blog\/why-data-warehousing-why-business-intelligence\/\">data warehouse<\/a> or other data integration architecture. Failing to properly manage the database may lead to a failure of the whole system.<\/p>\n<p>So, when I came across <a href=\"http:\/\/rlweiner.com\/best-practices-for-managing-a-database\" rel=\"noopener noreferrer\" target=\"_blank\">a piece<\/a> from <a href=\"https:\/\/www.linkedin.com\/in\/rlweiner\/\" rel=\"noopener noreferrer\" target=\"_blank\">Robert L. Weiner<\/a> on database management, I found it highly relevant. To brush up on your database management strategy, check if you have any of the typical mistakes listed below.<\/p>\n<div id=\"attachment_62038\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/weiner.jpg\"><img decoding=\"async\" aria-describedby=\"caption-attachment-62038\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/weiner.jpg\" width=\"150\" class=\"size-thumbnail wp-image-62038\" \/><\/a><p id=\"caption-attachment-62038\" class=\"wp-caption-text\"><small>Robert L. Weiner<\/small><\/p><\/div>\n<ul>\n<li style=\"padding-bottom:6px;\">Lack of specified data entry policies and procedures, hence no one knowing and applying them.<\/li>\n<li style=\"padding-bottom:6px;\">Using Excel as if it were a database. (JUST a spreadsheet, okay?)<\/li>\n<li style=\"padding-bottom:6px;\">Having no one in charge of data entry\/data quality training.<\/li>\n<li style=\"padding-bottom:6px;\">Forgetting all about backups, or running them way too seldom.<\/li>\n<li style=\"padding-bottom:6px;\">Allowing staff to copy sensitive information onto portable devices and take it home.<\/li>\n<li style=\"padding-bottom:6px;\">Insufficient password security measures.<\/li>\n<li style=\"padding-bottom:6px;\">Error management? Lack of error management strategies, careless data handling by staff.<\/li>\n<li>Keeping your user access rights and <a href=\"https:\/\/www.altoros.com\/blog\/ignoring-security-leads-to-huge-data-management-problems\/\">security options<\/a> a mess.<\/li>\n<\/ul>\n<p>Not about you? Then congratulations, your database management efforts don\u2019t need a major fix.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Information_life_cycle_management\"><\/span>Information life cycle management<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Long story short, it is the information that is the most valuabe asset in your data warehouse.<\/p>\n<p>There&#8217;s another insightful <a href=\"https:\/\/webcache.googleusercontent.com\/search?q=cache:Up2Yb95R8tMJ:https:\/\/www.pcworld.com\/article\/144627\/guide_information_management_data_classification_search.html\" target=\"_blank\" rel=\"noopener noreferrer\">article<\/a> by <a href=\"https:\/\/www.linkedin.com\/in\/michaelkarp001\" rel=\"noopener noreferrer\" target=\"_blank\">Mike Karp<\/a> on information life cycle management (ILM) and the six steps of implementing a successful and efficient policy on data storage, verification, classification, and management. Mike identifies the following steps to follow to ensure your ILM efficiency:<\/p>\n<p>&nbsp;<\/p>\n<p><strong> Stage 1. Preliminary<\/strong><\/p>\n<p>1) Determine whether your company\u2019s data is answerable to regulatory demands.<br \/>\n2) Determine whether your company uses its storage in an optimal manner.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Stage 2. Identifying file type, users accessing the data, and keywords used.<\/strong><\/p>\n<p>1) Make a list of regulatory requirements that may apply. Get this from your legal department or compliance office.<br \/>\n2) Define stakeholder needs. You must understand what users need and what they consider to be nonnegotiable.<br \/>\n3) Third, verify the data life cycles. Verify the value change for each life cycle with at least two other sources, a second source within the department that owns the data (if that is politically impossible, raise the issue through management), and someone familiar with the potential legal issues.<br \/>\n4) Define success criteria and get them widely accepted.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/10\/bi-research-2005-data-integration-project-types.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/10\/bi-research-2005-data-integration-project-types-1024x595.png\" width=\"640\" class=\"aligncenter size-large wp-image-62663\" \/><\/a><small>The most popular scenarios for data integration (<a href=\"https:\/\/tdwi.org\/~\/media\/TDWI\/TDWI\/Miscellaneous\/2002\/08\/TDWI_Data_Integration_Webcast%20pdf.ashx\" rel=\"noopener noreferrer\" target=\"_blank\">image credit<\/a>)<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Stage 3. Classification <\/strong>(aligning your stakeholders\u2019 business requirements to the IT infrastructure).<\/p>\n<p>0) Identifying the business value of each type of data object\u2014i.e., understanding three things: what kind of data you are dealing with, who will be using it, and what its keywords are.<br \/>\n1) Create classification rules.<br \/>\n2) Build retention policies.<\/p>\n<div id=\"attachment_59958\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/05\/mike-carp-networkworld.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-59958\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/05\/mike-carp-networkworld-150x150.jpg\" width=\"150\" height=\"150\" class=\"size-thumbnail wp-image-59958\" \/><\/a><p id=\"caption-attachment-59958\" class=\"wp-caption-text\"><small>Mike Carp<\/small><\/p><\/div>\n<blockquote>\n<p>When you engage with the vendors, make sure to understand their products\u2019 capabilities in each of the following areas:<\/p>\n<ul>\n<li> Ability to tag files as compliant for each required regulation.<\/li>\n<li> Data classification.<\/li>\n<li> Data deduplication.<\/li>\n<li> Disaster recovery and business continuity.<\/li>\n<li> Discovery of compliance-answerable files across Windows, Linux, UNIX, and any other operating systems you may have.<\/li>\n<li> Fully automated file migration based on locally set migration policies.<\/li>\n<li> Integration with backup, recovery, and archiving solutions already on-site.<\/li>\n<li> Searching (both tag-based and other metadata-based).<\/li>\n<li> Security (access control, identity management, and encryption).<\/li>\n<li> Security (antivirus).<\/li>\n<li> Set policies to move files to appropriate storage devices (content-addressed storage, WORM tape).<\/li>\n<li> Finding and tagging outdated, unused and unwanted files for demotion to a lower storage tier.<\/li>\n<li> Tracking access to and lineage of objects through their life cycle.<\/li>\n<\/ul>\n<\/blockquote>\n<p><strong>Finally<\/strong>, when you know your vendor, you can look for solutions to automate the needed processes and phase in.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tools_and_services\"><\/span>Tools and services<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Some more tips can be applied to the components of the integration evironment deployed between the sources\u2014such as ETL or <a href=\"https:\/\/www.altoros.com\/blog\/what-is-the-difference-between-etl-and-eai\/\">EAI<\/a>.<\/p>\n<p><em><strong>Don\u2019t<\/strong> let expenses frighten you.<\/em><\/p>\n<p>In today\u2019s enterprises, most data integration projects never get built. Why? Because most companies consider the return on investment (ROI) on the small projects simply too low to justify bringing in expensive middleware. Yeah, so you have your customer data in two sources and want to integrate (or synchronize). But then you think \u201cHey, it costs too much, I might as well leave everything as it is. It worked up till now, it\u2019ll work just as well in the future.\u201d Then, after a while, you find yourself lost between the systems and the data they contain, trying to figure out which information is more up-to-date and accurate? Guess what? You\u2019re losing again.<\/p>\n<p><em><strong>Do<\/strong> consider open-source software, if ROI is an issue.<\/em><\/p>\n<p>With <a href=\"https:\/\/www.altoros.com\/blog\/guide-to-reducing-etl-and-data-integration-costs-by-80-percent\/\">open-source data integration<\/a> tools, you could have your pie and eat it, too. Open source can offer a cost-effective visual data integration solutions to the companies that previously found proprietary data integration, ETL, and EAI tools expensive and complicated. Not having to pay license fees for BI and data integration software should make companies previously scared of insufficient ROI return to the data integration market.<\/p>\n<p>With these recommendations at hand, one can ensure a more efficient data integration strategy.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Further_reading\"><\/span>Further reading<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/ignoring-security-leads-to-huge-data-management-problems\/\">Ignoring Security Harms Data Management<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/cutting-data-integration-costs-through-rationalization-and-open-source\/\" rel=\"noopener noreferrer\" target=\"_blank\">Gartner Suggests Rationalizing Data Integration Tools to Cut Costs<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/guide-to-reducing-etl-and-data-integration-costs-by-80-percent\/\">Reducing ETL and Data Integration Costs by 80% with Open Source<\/a><\/li>\n<\/ul>\n<hr\/>\n<p><center><small>The post is written by <a href=\"https:\/\/www.altoros.com\/blog\/author\/alena-semeshko\/\">Alena Semeshko<\/a>; edited by <a href=\"https:\/\/www.altoros.com\/blog\/author\/alex\/\">Alex Khizhniak<\/a>.<\/small><\/center><\/p>\n","protected":false},"excerpt":{"rendered":"<p>(Featured image credit: TDWI, 2006)<\/p>\n<p>&nbsp;<\/p>\n<p>Making an asset of your database<\/p>\n<p>Extracting and normalizing customer data from multiple sources is the biggest challenge with client data management (54%), according to a report the Aberdeen Group. OK, true, a lot of companies consider linking and migrating customer information between databases, files and applications [&#8230;]<\/p>\n","protected":false},"author":178,"featured_media":63397,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[7],"tags":[960,895],"class_list":["post-49366","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-and-opinion","tag-data-integration","tag-research-and-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Dos and Don\u2019ts of Data Integration | Altoros<\/title>\n<meta name=\"description\" content=\"Experts give recommendations on how to deal with your database, information life cycle management, and other data integration tools and services.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Dos and Don\u2019ts of Data Integration | Altoros\" \/>\n<meta property=\"og:description\" content=\"(Featured image credit: TDWI, 2006) &nbsp; Making an asset of your database Extracting and normalizing customer data from multiple sources is the biggest challenge with client data management (54%), according to a report the Aberdeen Group. OK, true, a lot of companies consider linking and migrating customer information between databases, files and applications [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2008-12-02T23:25:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-05T03:48:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/tdwi-data-integration-issues-may-2006.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1489\" \/>\n\t<meta property=\"og:image:height\" content=\"845\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alena Semeshko\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alena Semeshko\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/\",\"name\":\"The Dos and Don\u2019ts of Data Integration | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/tdwi-data-integration-issues-may-2006.png\",\"datePublished\":\"2008-12-02T23:25:18+00:00\",\"dateModified\":\"2021-11-05T03:48:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/0ac460afad54a2f6640ce803b407fec8\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/tdwi-data-integration-issues-may-2006.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/tdwi-data-integration-issues-may-2006.png\",\"width\":1489,\"height\":845},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Dos and Don\u2019ts of Data Integration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\",\"url\":\"https:\/\/www.altoros.com\/blog\/\",\"name\":\"Altoros\",\"description\":\"Insight\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.altoros.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/0ac460afad54a2f6640ce803b407fec8\",\"name\":\"Alena Semeshko\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2019\/12\/banner_semeshko_to_the_blog_v2-96x96.jpg\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2019\/12\/banner_semeshko_to_the_blog_v2-96x96.jpg\",\"caption\":\"Alena Semeshko\"},\"description\":\"Alena Semeshko is Technology Evangelist at Apatar \/ Altoros. On her blog, she covers ETL, EAI, BI, open-source, and all the aspects of data integration. Alena is focused on creating awareness, fostering a better understanding, and keeping her readers well-informed on the emerging problems and data integration practices of the day. She possesses rich intercultural experience, having lived in several countries across the globe, and is studying Korean in her spare time.\",\"sameAs\":[\"http:\/\/altoros.com\"],\"url\":\"https:\/\/www.altoros.com\/blog\/author\/alena-semeshko\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Dos and Don\u2019ts of Data Integration | Altoros","description":"Experts give recommendations on how to deal with your database, information life cycle management, and other data integration tools and services.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/","og_locale":"en_US","og_type":"article","og_title":"The Dos and Don\u2019ts of Data Integration | Altoros","og_description":"(Featured image credit: TDWI, 2006) &nbsp; Making an asset of your database Extracting and normalizing customer data from multiple sources is the biggest challenge with client data management (54%), according to a report the Aberdeen Group. OK, true, a lot of companies consider linking and migrating customer information between databases, files and applications [...]","og_url":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/","og_site_name":"Altoros","article_published_time":"2008-12-02T23:25:18+00:00","article_modified_time":"2021-11-05T03:48:43+00:00","og_image":[{"width":1489,"height":845,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/tdwi-data-integration-issues-may-2006.png","type":"image\/png"}],"author":"Alena Semeshko","twitter_misc":{"Written by":"Alena Semeshko","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/","url":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/","name":"The Dos and Don\u2019ts of Data Integration | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/tdwi-data-integration-issues-may-2006.png","datePublished":"2008-12-02T23:25:18+00:00","dateModified":"2021-11-05T03:48:43+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/0ac460afad54a2f6640ce803b407fec8"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/tdwi-data-integration-issues-may-2006.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/12\/tdwi-data-integration-issues-may-2006.png","width":1489,"height":845},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/the-dos-and-donts-of-data-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Dos and Don\u2019ts of Data Integration"}]},{"@type":"WebSite","@id":"https:\/\/www.altoros.com\/blog\/#website","url":"https:\/\/www.altoros.com\/blog\/","name":"Altoros","description":"Insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.altoros.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/0ac460afad54a2f6640ce803b407fec8","name":"Alena Semeshko","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2019\/12\/banner_semeshko_to_the_blog_v2-96x96.jpg","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2019\/12\/banner_semeshko_to_the_blog_v2-96x96.jpg","caption":"Alena Semeshko"},"description":"Alena Semeshko is Technology Evangelist at Apatar \/ Altoros. On her blog, she covers ETL, EAI, BI, open-source, and all the aspects of data integration. Alena is focused on creating awareness, fostering a better understanding, and keeping her readers well-informed on the emerging problems and data integration practices of the day. She possesses rich intercultural experience, having lived in several countries across the globe, and is studying Korean in her spare time.","sameAs":["http:\/\/altoros.com"],"url":"https:\/\/www.altoros.com\/blog\/author\/alena-semeshko\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49366","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/users\/178"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=49366"}],"version-history":[{"count":32,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49366\/revisions"}],"predecessor-version":[{"id":64740,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49366\/revisions\/64740"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/63397"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=49366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=49366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=49366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}