Step (1) Initial Data Analysis
Step one of our data migration process is to determine if there is an opportunity to clean up your existing data. As a starting point, you want to make sure that you have valid data in the correct fields of your existing software. For example, if you’ve stored telephone numbers in address fields, you will want to fix this. This step also provides you with the opportunity to improve the quality of your data. Do you have a lot of duplicate customer records? Are you happy with existing product codes? Do you have duplicate inventory items to account for different UOMs? If you want to change anything, now is the time to do so. One of our consultants will work with you to help clean up your data in the most efficient way possible. This might be done with the help of a simple spreadsheet template, or, if the data follows a logical pattern, our team can write a data conversion import routine to make any necessary changes.
Step (2) Accessing the Data
Step two of the data migration process involves our team of in-house consultants working with you and your team to actually access the raw data to begin the migration process. Our team will extract the data from your existing systems and other data sources such as Excel spreadsheets into Blue Link ERP. Depending on your existing company set-up, you may have multiple solutions in which you will need to extract data – such as accounting systems, warehouse systems, eCommerce platforms, spreadsheets and CRM software – and you may have multiple entities in which you will need to migrate data for.
During this step, our team will write a data conversion routine that maps data from your old systems to Blue Link according to labels, titles and structures and you can migrate as much or as little data as you want. Enlisting the help of our team during this process ensures all important data is imported – including unpaid and opening balances, open sales orders and purchase orders, lot numbers and existing quotes.
As part of the implementation process, we move your data ahead of your Go-Live date. This allows us to validate the data, identify and fix any issues and provides your company with a set of relevant data within Blue Link ERP for training purposes.
Step (3) Data Migration
Step three of the data migration process involves re-extracting the data from your existing system right before Go-Live and importing it into Blue Link ERP using our data conversion import routine to ensure the data is the most up-to-date while reducing downtime and set-up. We will also re-validate the data at this stage to ensure it is accurate.
Blue Link has migrated data from hundreds of different pieces of software and across multiple operating systems. Whether its introductory software, legacy ERP, spreadsheets or other applications, Blue Link consultants can work with you and your current systems to extract the data.
There are several factors that can have an impact on the time it takes to move your data and therefore the costs of doing so. At Blue Link we bill for our data migration services based on the actual time it takes to move and clean-up the data. Therefore, if you require a lot of data clean-up, this can have an impact on overall costs. For example:
- If you have a lot of duplicate customer records that you want to consolidate
- If you want to update/change existing product codes
- If you have duplicate inventory items to account for different UOMs that you want consolidated
Alternatively, for start-up companies with no existing data or only a small amount of historical data, the migration process is simplified.
For Blue Link specifically, it’s hard to provide an accurate cost for data migration during initial conversations until we learn more about your data, what formats we are working with and how much data clean-up is required. This is why we provide estimates across a large range to account for these types of variables until we know more about your company.
Keep in mind that data migration quotes can vary by thousands of dollars because many software vendors low-ball quotes and ignore the massaging process and can sometimes put the onus on the customer to extract the data or manually enter it themselves. Although completing steps one and two may seem easy for individuals who have the skill set, even these people often face a number of issues and resort to getting the vendor to perform the migration for them.