{"id":55203,"date":"2009-06-29T14:10:09","date_gmt":"2009-06-29T11:10:09","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=55203"},"modified":"2021-10-06T06:03:43","modified_gmt":"2021-10-06T03:03:43","slug":"the-three-most-common-problems-faced-during-data-migration","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/","title":{"rendered":"The Three Most Common Problems Faced During Data Migration"},"content":{"rendered":"<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-three-most-common-problems-faced-during-data-migration\/#The_data_migration_puzzle\" >The data migration puzzle<\/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-three-most-common-problems-faced-during-data-migration\/#Issue_1_Understanding_the_new_systems_capabilities\" >Issue #1. Understanding the new system\u2019s capabilities<\/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-three-most-common-problems-faced-during-data-migration\/#Issue_2_A_clear_vision_of_what_should_be_moved_and_how\" >Issue #2. A clear vision of what should be moved and how<\/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-three-most-common-problems-faced-during-data-migration\/#Issue_3_The_quality_of_data_in_your_current_system\" >Issue #3. The quality of data in your current system<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#Afterword\" >Afterword<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"The_data_migration_puzzle\"><\/span>The data migration puzzle<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>According to Standish Group, 30% of <a href=\"https:\/\/en.wikipedia.org\/wiki\/Data_migration\" rel=\"noopener noreferrer\" target=\"_blank\">data migration<\/a> projects fail, while Bloor Research study found 84% of such migrations do not meet expectations. The problem often lies in making source data comply with target formats and standards, which requires a lot of time and effort on the developer&#8217;s side. Due to these and other data integration challenges, 75% of the leading companies are incapable of creating a unified view of a customer (Gartner).<\/p>\n<p>As your business grows, requirements for your data storage change. At the same time, the IT market offers new, diverse software to catch up with or even get ahead of your needs. At a certain stage, you face the necessity of switching to a new system. However, migrating contact data or integrating customer history may take months of coding, lead to huge data losses, or simply fail. <\/p>\n<p>What are the hidden problems related to data migration? How can you omit them and get the most out of your data integration initiative? This article explores these issues in detail, providing examples and recommendations to facilitate the migration process.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Issue_1_Understanding_the_new_systems_capabilities\"><\/span>Issue #1. Understanding the new system\u2019s capabilities<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Studying the new system\u2019s capabilities is an important step not just in preparing requirements for your data migration\/integration project, but in selecting the system in the first place. You have to see that this system really does meet your requirements and will be able to satisfy your needs. You should make sure, not only that this new system has all the components and functions\/capabilities you need, but also that it is convenient for you to work with these components and perform the actions you need to perform with your data.<\/p>\n<p>Let\u2019s take Salesforce CRM and GoldMine, for example. Sometimes, when it comes to migrating contacts\u2019 activity histories from GoldMine to Salesforce CRM, an important question is, which object to move data to: Events or Tasks.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Task-detail.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Task-detail.png\" alt=\"\" width=\"395\" height=\"190\" class=\"aligncenter size-full wp-image-55220\" \/><\/a><small>Salesforce CRM&#8217;s task detail<\/small><\/center><\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Event-detail.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Event-detail.png\" alt=\"\" width=\"392\" height=\"232\" class=\"aligncenter size-full wp-image-55223\" \/><\/a><small>Salesforce CRM\u2019s event detail<\/small><\/center><\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Schedule-a-call.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Schedule-a-call.png\" alt=\"\" width=\"310\" height=\"276\" class=\"aligncenter size-full wp-image-55224\" \/><\/a><small>GoldMine activities<\/small><\/center><\/p>\n<p>Also, for technical professionals it would be good to analyze how the new system communicates with other systems. A good import\/export mechanism included in the new system is a useful feature, but it\u2019s not always sufficient. So, it is important to study the system\u2019s API or SOAP capabilities. While some such interfaces provide you with a great toolset for data integration, others have significant limitations, which means that there will be no easy way to migrate some types of information, so you will need to look for alternative integration methods, such as direct database access, if it is enabled by the system. This issue will definitely make the project more labor-intensive, time-consuming, and, as a result, more costly.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Issue_2_A_clear_vision_of_what_should_be_moved_and_how\"><\/span>Issue #2. A clear vision of what should be moved and how<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To save time when the project is started and to make sure no data is missed, it is very important to make a complete list of the data that should be migrated. You can either prepare screenshots with the fields you need highlighted in some way or you can prepare a list of fields. For the list of fields, it is important to also mention the object\/table this field is related to, as there might be fields with the same name in different objects\/tables. Having the complete list of fields to be migrated will actually help the service provider make their work estimates more accurate.<\/p>\n<p>Example: Activities in GoldMine have fields, such as Activity (specifying the type of activity performed), Code, and Result whereas some other systems do not have such fields (though custom fields can be created to hold this data).<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/list-of-fields.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/list-of-fields.png\" alt=\"\" width=\"513\" height=\"441\" class=\"aligncenter size-full wp-image-55229\" \/><\/a><small>Creating a list of fields<\/small><\/center><\/p>\n<p>This leads us to the next point. When you have the list of fields to be migrated ready, check where they can go in your new system. And there are two aspects here:<\/p>\n<p>&nbsp;<br \/>\n<b>Object-to-object relation<\/b><\/p>\n<p>In your new system, there might be one or several objects that are pretty much equivalent and can hold the data you are migrating (like in the example with GoldMine activities and Salesforce CRM\u2019s Tasks and Events above).<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/object-to-object-relation.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/object-to-object-relation.png\" alt=\"\" width=\"498\" height=\"227\" class=\"aligncenter size-full wp-image-55230\" \/><\/a><small>Contact detail<\/small><\/center><\/p>\n<p>Also, there might be different objects in the new system that data from one object should be split into. For example, your current system has the Customer object that contains contact name, company, address, phone, e-mail, revenue, business type, etc. However, your new system has only two objects for this type of information: Account and Contact. You should think about which customer data goes to Accounts, which to Contact, and which can and should be presented in both objects. Here you need to remember that if you have several contacts that are related to the same company, the values in the fields that should be written to this company account may be different.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/account-detail.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/account-detail.png\" alt=\"\" width=\"381\" height=\"272\" class=\"aligncenter size-full wp-image-55231\" \/><\/a><small>Account object<\/small><\/center><\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/contact-detail.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/contact-detail.png\" alt=\"\" width=\"325\" height=\"232\" class=\"aligncenter size-full wp-image-55232\" \/><\/a><small>Contact object<\/small><\/center><\/p>\n<p>For example, different customers related to the same company may have different addresses or revenues (e.g., one customer has been updated with new numbers, while another still has the old value). This means that if you take this information from customers and write it to a company\u2019s Account, it might not be accurate.<\/p>\n<p>Unless there is some business logic that can be added to the migration process that will be applicable to all customer records, options will need to be considered. One of them can be writing the company data that is 100% identical for all customers to the company\u2019s Account and writing the rest to Contacts. Another option can be creating separate accounts based on each customer\u2019s record. But this option will only make sense if your new system allows creating \u201cduplicate\u201d records (Accounts with the same account name in this case) and has a good duplicates merging mechanism, and of course, if you are sure that you only have a few customers related to the same company in your current system.<\/p>\n<p>(Imagine that you have 20 contacts for some companies in your system and there are 20 accounts created for each of these companies. The effort you\u2019d need to take to merge them wouldn\u2019t be worth it.)<\/p>\n<p>&nbsp;<br \/>\n<b>Field-to-field relation<\/b><\/p>\n<p>While same type of systems (CRM or ERP, for example) offer a similar set of fields for each data object, they are never 100% the same. Compare the list of fields that you have selected for migration with the fields for related objects in your new system. Make sure that you are happy with the corresponding standard fields offered by the system. It is not just field names that you should pay attention to; field characteristics matter, as well. A field that you currently have as a picklist might be a text field, or an equivalent for a text field might be a numeric field in your new system and this might not be what you really need. Another thing to pay attention to is the field size. Your current system might allow a greater number of characters for a certain field compared to the new system, which means a workaround will need to be found so that you do not lose data when cropping it to match the size of the new field.<\/p>\n<p>The best method is to go back to field types and define the names and types for the custom fields that need to be created to hold data from your current system. This way, you will not get into a situation where the processes or triggers that these custom fields are involved in\u2014and that have already been set up\u2014do not work; this will also prevent data loss due to poorly thought out field names or types. It is not that problems occur in 100% of the cases when you change the characteristics of a field that already has data in it, but the risk exists.<\/p>\n<p>Another issue you may face is that you might need to split data currently stored in one field into a number of separate fields.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/field-to-field-relation.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/field-to-field-relation.png\" alt=\"\" width=\"315\" height=\"182\" class=\"aligncenter size-full wp-image-55236\" \/><\/a><small>Data stored in one field<\/small><\/center><\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/splitting-data.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/splitting-data.png\" alt=\"\" width=\"309\" height=\"105\" class=\"aligncenter size-full wp-image-55237\" \/><\/a><small>Splitting data into separate fields<\/small><\/center><\/p>\n<p>Let\u2019s take contact names, for example.<\/p>\n<p>The full name is contained in one field and you need to break it down into first name, middle name, and last name. Errors are possible here during the migration because of the ways names are entered. A few sample values.<\/p>\n<p>Mike M. Smith<br \/>\nMike Smith<br \/>\nSmith, Mike<br \/>\nMike Smith Jr.<br \/>\nMike von Smith<\/p>\n<p>For most of the options above, it is possible to set up the process to automatically split the name into several fields and in case of \u201cMike Smith Jr.\u201d to write \u201cJr.\u201d in the suffix field, for example. However, for the last option (Mike von Smith) there is a great chance that \u201cvon\u201d will go to the middle name field. It might not seem to be a serious problem, however if you use some templates where you need to get the last name of a contact, you will not get the correct value.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Issue_3_The_quality_of_data_in_your_current_system\"><\/span>Issue #3. The quality of data in your current system<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Careful analysis of the quality of data in your current system should be done prior to migration. Good data can save quite a bit of time (and budget) during migration. In fact, this analysis and replacement set up during the migration will help you cleanse and improve your data. Outlined below are some key points to pay attention to.<\/p>\n<p>&nbsp;<br \/>\n<b>Required fields<\/b><\/p>\n<p>Many systems have fields that need to be filled in for records to be migrated. It is important that these key fields are filled in, such as company names for accounts, customer names for contacts, and so on.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/call-back.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/call-back.png\" alt=\"\" width=\"541\" height=\"195\" class=\"aligncenter size-full wp-image-55239\" \/><\/a><small>Key fields that should be filled in<\/small><\/center><\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/event-edit.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/event-edit.png\" alt=\"\" width=\"548\" height=\"153\" class=\"aligncenter size-full wp-image-55240\" \/><\/a><small>Required information is migrated<\/small><\/center><\/p>\n<p>If you feel this information is missing, you need to think what values should be entered into these empty fields. It can be either one value for all empty fields or the values can be generated based on some other information. For example, you can fill in an empty contact name with something like \u201cCompany Name representative.\u201d Or, for activities, if the activity date is empty, you can enter a specific date as a placeholder by which you can then find these activities and have your system users fill in those dates.<\/p>\n<p>The key factor here is to make it convenient for you to use the data when it is migrated.<\/p>\n<p>&nbsp;<br \/>\n<b>Data type transformations<\/b><\/p>\n<p>Data type conversion might also be required when you migrate your data. It is important that the values entered in the fields to be converted in your current system meet the requirements of your new data type. We did mention field size issues earlier. Other examples here are: transferring text field to numeric (phone extensions, etc.); date contained in a text field to a date field; text to picklists; and others.<\/p>\n<p>The issue with picklists is that they normally accept only the values that are there in the dropdown for this field in your new system. You would need to analyze the values contained in the fields that are to be transferred to picklists to make sure you have all the values in the new system and there is no conflict during the migration. The most common problem here is logical duplicates that are presented in different ways in the field. For example, you might want to have \u201cwhite paper\u201d as a value on the list, but in your current system there also are \u201cWP,\u201d \u201cwhitepaper,\u201d and \u201cwhite papre.\u201d If it is not possible to replace these with \u201cwhite paper\u201d automatically in your current system, you will need to add these replacements within the data transformation to be built for the project.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/GoldMine-to-SFDC-History-Migration-with-Apatar.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/GoldMine-to-SFDC-History-Migration-with-Apatar.png\" alt=\"\" width=\"554\" height=\"447\" class=\"aligncenter size-full wp-image-59561\" \/><\/a><small>Migrating History from GoldMine to Salesforce CRM with Apatar<\/small><\/center><\/p>\n<p>&nbsp;<br \/>\n<b>Data uniformity and typos<\/b><\/p>\n<p>This aspect is important both to ensure that all the data is migrated correctly and to omit creating duplicate records. A simple example of why duplicates can be created would be a difference in the way the name of the same company is entered for different contacts. Logically, \u201cApatar,\u201d \u201cApatar Inc.,\u201d and \u201cApatar, Inc.\u201d are the same company, but for an application these values are not the same; so after the migration you will have three different Account records instead of one.<\/p>\n<p>The quality of the data is also important when you convert data types, for example, text to checkboxes or radio buttons (Booleans), joining date and time fields to a field that contains both (timestamp\/date and time), etc. The latter would require both date and time fields to be filled in.<\/p>\n<p>Some systems verify the data that is entered into fields. For example, Salesforce CRM checks the format of entries in the Email field. If you have values in your data source that are not properly formatted e-mails, (\u201cinfo @apatar.com,\u201d \u201cinfoapatar.com,\u201d or \u201cinfo@apatar.com, support@apatar.com.\u201d), the Email field for the record with invalid e-mail format or the entire record will not be migrated.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Afterword\"><\/span>Afterword<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When the migration is completed, make sure to double-check the results. Select at least one record that has most of the data filled in and a few records that have some data that required some workarounds or replacements set during the migration and make sure everything has been migrated correctly.<\/p>\n<p>If the data was migrated from a system that your team members have been working with while the data was being migrated, make sure that new data has also been migrated and the latest changes are also reflected in your new system.<\/p>\n<p>For more, check out how <a href=\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\">Apatar Open Source Data Integration<\/a> can help.<\/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\/what-is-the-difference-between-data-conversion-and-data-migration\/\">What\u2019s the Difference Between Data Conversion and Data Migration?<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/guide-to-reducing-etl-and-data-integration-costs-by-80-percent\/\">Guide to Reducing ETL and Data Integration Costs by 80%<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/what-should-data-migration-plan-comprise\/\">What Should a Data Migration Plan Comprise?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The data migration puzzle<\/p>\n<p>According to Standish Group, 30% of data migration projects fail, while Bloor Research study found 84% of such migrations do not meet expectations. The problem often lies in making source data comply with target formats and standards, which requires a lot of time and effort on the [&#8230;]<\/p>\n","protected":false},"author":190,"featured_media":55577,"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":[966,960,895],"class_list":["post-55203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-and-opinion","tag-apatar","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 Three Most Common Problems Faced During Data Migration | Altoros<\/title>\n<meta name=\"description\" content=\"The differences between CRM systems, such as GoldMine and Salesforce.com, as well as the quality of data, bring in a number of challenges for integration experts.\" \/>\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-three-most-common-problems-faced-during-data-migration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Three Most Common Problems Faced During Data Migration | Altoros\" \/>\n<meta property=\"og:description\" content=\"The data migration puzzle According to Standish Group, 30% of data migration projects fail, while Bloor Research study found 84% of such migrations do not meet expectations. The problem often lies in making source data comply with target formats and standards, which requires a lot of time and effort on the [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2009-06-29T11:10:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-06T03:03:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/The-Three-Most-Common-Problems-Faced-During-Data-Migration2.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"Ludmila Radzevich\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ludmila Radzevich\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 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-three-most-common-problems-faced-during-data-migration\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/\",\"name\":\"The Three Most Common Problems Faced During Data Migration | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/The-Three-Most-Common-Problems-Faced-During-Data-Migration2.gif\",\"datePublished\":\"2009-06-29T11:10:09+00:00\",\"dateModified\":\"2021-10-06T03:03:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/bd58746c6a5bc0d374f8fc1aa663687b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/The-Three-Most-Common-Problems-Faced-During-Data-Migration2.gif\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/The-Three-Most-Common-Problems-Faced-During-Data-Migration2.gif\",\"width\":640,\"height\":360},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Three Most Common Problems Faced During Data Migration\"}]},{\"@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\/bd58746c6a5bc0d374f8fc1aa663687b\",\"name\":\"Ludmila Radzevich\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Ludmila-Radzevich-96x96.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Ludmila-Radzevich-96x96.png\",\"caption\":\"Ludmila Radzevich\"},\"description\":\"Ludmila Radzevich is VP of Business Development at Apatar. She manages the creation of Apatar\u2019s core and the delivery of connectors to various corporate systems and databases. Ludmila is also responsible for interacting with independent contributors to the project, ensuring that their commits seamlessly integrate with Apatar. She is a frequent speaker and participant at international conferences (such as CeBIT in Hannover, Germany).\",\"url\":\"https:\/\/www.altoros.com\/blog\/author\/ludmila\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Three Most Common Problems Faced During Data Migration | Altoros","description":"The differences between CRM systems, such as GoldMine and Salesforce.com, as well as the quality of data, bring in a number of challenges for integration experts.","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-three-most-common-problems-faced-during-data-migration\/","og_locale":"en_US","og_type":"article","og_title":"The Three Most Common Problems Faced During Data Migration | Altoros","og_description":"The data migration puzzle According to Standish Group, 30% of data migration projects fail, while Bloor Research study found 84% of such migrations do not meet expectations. The problem often lies in making source data comply with target formats and standards, which requires a lot of time and effort on the [...]","og_url":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/","og_site_name":"Altoros","article_published_time":"2009-06-29T11:10:09+00:00","article_modified_time":"2021-10-06T03:03:43+00:00","og_image":[{"width":640,"height":360,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/The-Three-Most-Common-Problems-Faced-During-Data-Migration2.gif","type":"image\/gif"}],"author":"Ludmila Radzevich","twitter_misc":{"Written by":"Ludmila Radzevich","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/","url":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/","name":"The Three Most Common Problems Faced During Data Migration | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/The-Three-Most-Common-Problems-Faced-During-Data-Migration2.gif","datePublished":"2009-06-29T11:10:09+00:00","dateModified":"2021-10-06T03:03:43+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/bd58746c6a5bc0d374f8fc1aa663687b"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/The-Three-Most-Common-Problems-Faced-During-Data-Migration2.gif","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/The-Three-Most-Common-Problems-Faced-During-Data-Migration2.gif","width":640,"height":360},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Three Most Common Problems Faced During Data Migration"}]},{"@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\/bd58746c6a5bc0d374f8fc1aa663687b","name":"Ludmila Radzevich","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Ludmila-Radzevich-96x96.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Ludmila-Radzevich-96x96.png","caption":"Ludmila Radzevich"},"description":"Ludmila Radzevich is VP of Business Development at Apatar. She manages the creation of Apatar\u2019s core and the delivery of connectors to various corporate systems and databases. Ludmila is also responsible for interacting with independent contributors to the project, ensuring that their commits seamlessly integrate with Apatar. She is a frequent speaker and participant at international conferences (such as CeBIT in Hannover, Germany).","url":"https:\/\/www.altoros.com\/blog\/author\/ludmila\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/55203","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\/190"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=55203"}],"version-history":[{"count":51,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/55203\/revisions"}],"predecessor-version":[{"id":63919,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/55203\/revisions\/63919"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/55577"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=55203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=55203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=55203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}