msg systems ag

Tools and procedures

To support the individual phases and steps of your migration project, our Competence Center Migration has put together a toolbox containing the following useful tools:


1. Repository: This database contains all migration-relevant objects (for example all attributes in the database tables for the source and also the target systems) to obtain a complete detailed overview and to automate as many procedures as possible (e.g. generation of load jobs, impact analyses).

2. Data profiling tools: Practically at the touch of a button, these data analysis tools permit the analysis and visualization of value ranges, data types and other parameters in the source and target systems, thus saving great programming and analysis workload.

3. Transformation tool: This tool formulates the visualization rules for the transfer of source to target attributes, transforming them to executable migration programs. For very complex target systems it may be necessary to produce so-called "business loaders" – loading programs that use the automated business processes already present in the target system – in order to import the data.

4. Data comparison tools: An important aid for systematic comparison of source and target data in the simplest possible manner during the migration process, with the results shown both in detail and compacted in the form of "indices". This is a prerequisite for generating sound information in order to proceed with migration.

5. Generic browsers: These tools are used for viewing and manipulating data in any data storage systems, for example for later access to data from source applications stored in staging areas when the source applications are to be shut down after the migration.


Together with these proven tools and procedures supporting efficient and successful migration, we also use tools of other makes, e.g. LSMW (Legacy System Migration Workbench) by SAP.

 

 

Contact

Michael Ort,
Senior IT-Consultant