Migration is an essential step within an organization's data architecture, since the correct functioning of any new system to be put into practice depends on it. It is about, in practice, from a transfer of information from one source to another, as part of a sectoral or comprehensive initiative, spanning the entire organization.
Data migration is not an easy task, but if it's done right from the start, the transition will be easier, either a development procedure or the acquisition of a new system to replace the existing one. To that end, it will be essential to have a methodology and effective tools, that adapt to the requirements of each project.
At the same time looking for agility, when moving the data it is necessary answer to a series of critical needs to achieve an operation that meets quality standards and, in summary, the migration requirements. For this, the data architecture must determine a series of conditions, as the identification of the data, as well as the level of transformation and cleaning necessary to adapt to the data model requested by the target applications.
Another key aspect to migrate safely are the migration diagrams, very useful to overcome the usual challenges in a migration, that usually require extracting data from applications, perform data transformation operations, including data quality processes, fuse, consolidate and, to end, upload to target systems.
Uses of the migration diagram
In this context, the data migration diagram is a visual representation of the propagation or flow of data from sources to end applications, defining the source and destination tables. Its design can respond to two needs:
-
Architecture level: It is designed based on the previous action plan, within the approach marked by the data architecture and its objective is to determine a modus operandi.
-
Migration processes: They are simpler diagrams, that reflect the amount of fonts we want to load and allow us to choose changes from the results obtained in the migration procedure after applying that first diagram, once the data is cleaned.
As a data audit and data flow establishment tool, the migration diagram may undergo modifications, that will depend on your level of detail. Therefore, the diagram can simply be a general outline of the migration or go into detail, or it may occur at different stages of the migration procedure and be carried out for different reasons and stakeholder needs, from different perspectives or approaches.
The main advantages
Without taking into account the casuistry, as we have pointed out, the generic goal of migration diagrams is to show the flow of data from source to target applications. But not only visually represents the diffusion of sources to establish the objectives to be achieved, but also enables improve procedure of migration thanks to a series of advantage:
-
Serves as a tool to audit the data.
-
Avoid loss of information.
-
Helps to be precise in loading information.
-
Facilitates maintaining data integrity.
-
Streamline information corrections.
Image source: pictures / FreeDigitalPhotos.net
Related Post:
(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = “//connect.facebook.net/es_ES/all.js#xfbml=1&status=0”;
fjs.parentNode.insertBefore(js, fjs);
}(document, ‘script’, 'facebook-jssdk'));
