{"id":49236,"date":"2009-04-02T03:27:11","date_gmt":"2009-04-02T00:27:11","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=49236"},"modified":"2021-08-03T21:25:44","modified_gmt":"2021-08-03T18:25:44","slug":"integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/","title":{"rendered":"Acquisitions and Mergers: Adding New Systems into a Data Warehouse"},"content":{"rendered":"<p><center><small>(<a href=\"https:\/\/www.slideshare.net\/mrm0\/etl-market-webcast\" rel=\"noopener noreferrer\" target=\"_blank\">Featured image credit<\/a>)<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_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\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#CDI_why_interoperability_is_essential\" >CDI: why interoperability is essential<\/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\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#Best_practices_to_consider\" >Best practices to consider<\/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\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"CDI_why_interoperability_is_essential\"><\/span>CDI: why interoperability is essential<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Customer data with no doubt is an asset, especially for customer-centric companies. It gives a clear understanding of who the customers are and what their needs are, essential information for measuring and analyzing the effectiveness of company\u2019s work.<\/p>\n<p>We all remember those talks about mergers and acquisitions among companies due to the present economic downturn. Integrating new systems acquired with the merger or acquisition in a data warehouse is a big challenge for those in charge.<\/p>\n<p>When mergers or acquisitions occur, customer data is being put at risk, because customer data integration being not an easy thing within a company, in case of mergers gets even more complex. The name of the factor making the whole thing that complex is interoperability.<br \/>\nWhy interoperability is of such an importance for those responsible for data integration? Okay, here are some points.<\/p>\n<p>Even within one company customer data is being spread between different systems. This means different tools and solutions created by different people and being used for different periods. Moreover, all those systems utilize different data models and architectures.<\/p>\n<p>So, interoperability of company\u2019s systems, or their ability to communicate with each other, may provide better customer data integration and save amounts of time and money needed to make all those disparate tools work together.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Best_practices_to_consider\"><\/span>Best practices to consider<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>There are several things with respect to ETL integration from one system to the other one can do to make this process easier. Here is an advice by <a href=\"https:\/\/www.linkedin.com\/in\/joeoates\/\" rel=\"noopener noreferrer\" target=\"_blank\">Joe Oates<\/a>, an internationally known consultant on data warehousing:<\/p>\n<div id=\"attachment_63002\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/joe-oates.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-63002\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/joe-oates-150x150.jpg\" width=\"150\" height=\"150\" class=\"size-thumbnail wp-image-63002\" \/><\/a><p id=\"caption-attachment-63002\" class=\"wp-caption-text\"><small>Joe Oates<\/small><\/p><\/div>\n<blockquote>\n<ul>\n<li style=\"padding-bottom:6px;\">Get involved as early as possible. Work out an arrangement with IT management so that the data warehouse team can be involved with the planning for the merger or acquisition from the start.<\/li>\n<li style=\"padding-bottom:6px;\">In your requirements gathering, you should have obtained a list of the top 20 questions that each manager or involved stakeholder in the current data warehouse project would like to get from the data warehouse. Consolidate these questions into a single list and run them by the management of the new company as well as your existing management to see if they still apply and if any new questions are needed. This is something you should do periodically.<\/li>\n<p><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/microsoft-data-warehouse-toolkit-with-sql-server-2005-and-BI-toolset-237x300.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/microsoft-data-warehouse-toolkit-with-sql-server-2005-and-BI-toolset-237x300.png\" width=\"160\" class=\"alignright size-medium wp-image-63010\" \/><\/a><\/p>\n<li style=\"padding-bottom:6px;\">Prepare templates for the ETL process flow. You may not have much time to bring the new systems in. You also may have to bring on inexperienced resources to do the ETL. Having well-designed templates that handle the overall flow of the ETL, the dimension processing, fact processing, exception processing and audit trail will be invaluable. The best source for this information in a readily available <a href=\"https:\/\/www.amazon.com\/Microsoft-Data-Warehouse-Toolkit-Intelligence\/dp\/0471267155\" rel=\"noopener noreferrer\" target=\"_blank\">book<\/a> that I have seen is <i>&#8220;The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset&#8221;<\/i> by Ralph Kimball, et al. Regardless of the database system or ETL tool that you may use, the section on how to develop the ETL is excellent and the principles can be transferred to any ETL tool or database.<\/li>\n<li style=\"padding-bottom:6px;\">You will probably want to have two or more phases involved in bringing the data over from the new company. It is much easier to handle several smaller ETL projects than one gigantic ETL project. Regardless of whether you can or not, the previously mentioned templates will make your life much easier.<\/li>\n<li>Negotiate a trial period or parallel if the acquired company already has a DW. You may have to develop special reports and\/or analyses for the new company. Being able to work out the details before going into full production will help you set expectations and help ensure a smoother transition.<\/li>\n<\/ul>\n<\/blockquote>\n<p>Now, getting the data from all those systems into one place makes the famous single customer view which is the goal of customer data integration. It helps improve selling by delivering the fullest information about company\u2019s customers. Plus, support of a single system costs far less then support of multiple systems across the company.<\/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\/5-things-to-watch-out-for-in-data-warehousing\/\">5 Things to Watch Out for in Data Warehousing<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/why-data-warehousing-why-business-intelligence\/\">Why Business Intelligence for Data Warehousing?<\/a><\/li>\n<\/ul>\n<hr\/>\n<p><center><small>The post is written by <a href=\"https:\/\/www.altoros.com\/blog\/author\/olga\/\">Olga Belokurskaya<\/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)<\/p>\n<p>&nbsp;<\/p>\n<p>CDI: why interoperability is essential<\/p>\n<p>Customer data with no doubt is an asset, especially for customer-centric companies. It gives a clear understanding of who the customers are and what their needs are, essential information for measuring and analyzing the effectiveness of company\u2019s work.<\/p>\n<p>We all remember those talks about mergers [&#8230;]<\/p>\n","protected":false},"author":81,"featured_media":63007,"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-49236","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 v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Acquisitions and Mergers: Adding New Systems into a Data Warehouse | Altoros<\/title>\n<meta name=\"description\" content=\"Learn about best practices to follow, paying attention to interoperability, ETL, and everything involved into the process.\" \/>\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\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Acquisitions and Mergers: Adding New Systems into a Data Warehouse | Altoros\" \/>\n<meta property=\"og:description\" content=\"(Featured image credit) &nbsp; CDI: why interoperability is essential Customer data with no doubt is an asset, especially for customer-centric companies. It gives a clear understanding of who the customers are and what their needs are, essential information for measuring and analyzing the effectiveness of company\u2019s work. We all remember those talks about mergers [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2009-04-02T00:27:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-03T18:25:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/traditional-data-warehouse-architecture-v2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1494\" \/>\n\t<meta property=\"og:image:height\" content=\"974\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Olga Belokurskaya\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olga Belokurskaya\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/\"},\"author\":{\"name\":\"Olga Belokurskaya\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#\\\/schema\\\/person\\\/b4c29d31973f82a70fcb5e68c5aa5b60\"},\"headline\":\"Acquisitions and Mergers: Adding New Systems into a Data Warehouse\",\"datePublished\":\"2009-04-02T00:27:11+00:00\",\"dateModified\":\"2021-08-03T18:25:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/\"},\"wordCount\":705,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2009\\\/04\\\/traditional-data-warehouse-architecture-v2.png\",\"keywords\":[\"Data Integration\",\"Research and Development\"],\"articleSection\":[\"News\\\/Opinion\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/\",\"name\":\"Acquisitions and Mergers: Adding New Systems into a Data Warehouse | Altoros\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2009\\\/04\\\/traditional-data-warehouse-architecture-v2.png\",\"datePublished\":\"2009-04-02T00:27:11+00:00\",\"dateModified\":\"2021-08-03T18:25:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#\\\/schema\\\/person\\\/b4c29d31973f82a70fcb5e68c5aa5b60\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2009\\\/04\\\/traditional-data-warehouse-architecture-v2.png\",\"contentUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2009\\\/04\\\/traditional-data-warehouse-architecture-v2.png\",\"width\":1494,\"height\":974},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Acquisitions and Mergers: Adding New Systems into a Data Warehouse\"}]},{\"@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\\\/b4c29d31973f82a70fcb5e68c5aa5b60\",\"name\":\"Olga Belokurskaya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/Olga-Belokurskaya-96x96.jpg\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/Olga-Belokurskaya-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/Olga-Belokurskaya-96x96.jpg\",\"caption\":\"Olga Belokurskaya\"},\"description\":\"Olga Belokurskaya is a writer with a long history of working in the information technology and services industry. She has broad expertise in writing news and articles on cloud computing, data integration, and software product development. Olga is adept at holding interviews with business owners and representatives. In addition, she has experience working as an interpreter and communications specialist.\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/author\\\/olga\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Acquisitions and Mergers: Adding New Systems into a Data Warehouse | Altoros","description":"Learn about best practices to follow, paying attention to interoperability, ETL, and everything involved into the process.","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\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Acquisitions and Mergers: Adding New Systems into a Data Warehouse | Altoros","og_description":"(Featured image credit) &nbsp; CDI: why interoperability is essential Customer data with no doubt is an asset, especially for customer-centric companies. It gives a clear understanding of who the customers are and what their needs are, essential information for measuring and analyzing the effectiveness of company\u2019s work. We all remember those talks about mergers [...]","og_url":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/","og_site_name":"Altoros","article_published_time":"2009-04-02T00:27:11+00:00","article_modified_time":"2021-08-03T18:25:44+00:00","og_image":[{"width":1494,"height":974,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/traditional-data-warehouse-architecture-v2.png","type":"image\/png"}],"author":"Olga Belokurskaya","twitter_misc":{"Written by":"Olga Belokurskaya","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#article","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/"},"author":{"name":"Olga Belokurskaya","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60"},"headline":"Acquisitions and Mergers: Adding New Systems into a Data Warehouse","datePublished":"2009-04-02T00:27:11+00:00","dateModified":"2021-08-03T18:25:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/"},"wordCount":705,"commentCount":1,"image":{"@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/traditional-data-warehouse-architecture-v2.png","keywords":["Data Integration","Research and Development"],"articleSection":["News\/Opinion"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/","url":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/","name":"Acquisitions and Mergers: Adding New Systems into a Data Warehouse | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/traditional-data-warehouse-architecture-v2.png","datePublished":"2009-04-02T00:27:11+00:00","dateModified":"2021-08-03T18:25:44+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/traditional-data-warehouse-architecture-v2.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/traditional-data-warehouse-architecture-v2.png","width":1494,"height":974},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/integrating-new-systems-acquired-with-the-merger-in-a-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Acquisitions and Mergers: Adding New Systems into a Data Warehouse"}]},{"@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\/b4c29d31973f82a70fcb5e68c5aa5b60","name":"Olga Belokurskaya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","caption":"Olga Belokurskaya"},"description":"Olga Belokurskaya is a writer with a long history of working in the information technology and services industry. She has broad expertise in writing news and articles on cloud computing, data integration, and software product development. Olga is adept at holding interviews with business owners and representatives. In addition, she has experience working as an interpreter and communications specialist.","url":"https:\/\/www.altoros.com\/blog\/author\/olga\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49236","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\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=49236"}],"version-history":[{"count":16,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49236\/revisions"}],"predecessor-version":[{"id":63015,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49236\/revisions\/63015"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/63007"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=49236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=49236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=49236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}