Moving from an obsolete system to a newer one is always a headache. The main issue that a business face, in this case, is to transfer all the data to the new system. Nobody wants to lose valuable data contained in the current system they are using, but transferring a database is not an easy task. Many companies are still using very old systems just because the effort needed to input all data in a better performing one is too high. Using a method called ETL (Extract, Transform, Load), we help companies to smoothly migrate into the new system without losing any valuable data in the process.
Database migration is often needed when switching to a new system such as ERP, CMS, CRM, web site, etc... The issue is that in each system data are organized differently and with different formats, so why the migration to a new system can be extremely difficult and expensive. Moreover, data migration is often not supported by the new system suppliers and usually, and it is not easy to figure out how to properly input all the data.
The first step we undertake in a Database migration process is the "Extraction phase". Ee download all data contained in the old system and we store them safely in a separate database. When the data in the old system are not easily accessible we develop a specific "scraping bot" to read and save all the data needed.
The second step is the "Transformation phase" when we analyze the data extracted from the old system and we transform them to meet the structure required by the new system.
The last and final step is the "Loading phase" during which we feed the new system with all the data needed in the format required for instance a specific CSV file
A common user-case of Database Migration is the transition to a new platform for an eCommerce Website, for instance from Magento to Shopify. Data Sensum can support this transition by extracting all the product info on Magento and upload everything (including pictures) with a CSV file in Shopify in a matter of days.
We always start by identifying what are your main business challenges and by understanding what is your desired outcome. It is important to take enough time to deeply analyze the business and make sure we are on the same page. In this phase in particular we learn about the database structure.
Once we have a good understanding of your business we can start planning, estimating the time and resources needed for the project. It is also important in this phase to define a clear target to achieve in order to complete the project. in particular, we define an action plan to perform the ETL (extract, transform, load) process.
When designing the appropriate solution we always privilege simplicity and usability. In this phase, we need your support to get access to all databases needed in order to deploy the project. We will input at first in the new system a sample of the data, so we can make sure that everything is working fine as expected.
Once we have your approval of the last draft, we deploy and perform the data migration in the new system. The time needed to deploy the project depends on the amount of data to migrate, but it is generally relatively short.
Just delivering and deploying the dashboard is in most cases is not enough to solve our client's business problem. That's why we track the progress after the development of the project and we make sure that all data have migrated correctly and in case there is any data missing we complete the loading phase
29 Smithfield Market Block B
Dublin, Ireland
Email: info@datasensum.com
Phone: +353 857443036
Phone +39 3407500372
Develop a free website - Click now