| The NOMAD toolset is supplied free of charge as an indispensable aid for the ATD analyst to perform a migration. The tools semi-automate many of the data-related processes. They are based on the Microsoft SQL Server database and development tools and assist the loading, evaluation, transformation and export of data for migration. Microsoft Access is used as the front-end tool to manage and control the various processes.
NOMAD has a number of discrete components:
Data Dictionary
The dictionary is a central component to
all the data migration tools. In addition to storing the basic metadata it is used to
hold the profile statistics, business rules and validation tests. It is also important in keeping the data mapping specifications required for migration.
Data Profiler
The profile tools scan the data to provide statistical analysis of data attributes in
order to facilitate the construction of the overall metadata. They analyse three
aspects of the data; Columns, Dependencies and Redundancies.
This information can then be used to evaluate the data for its meaning and
its overall integrity.
Data Evaluator
The data evaluation software utilises the metadata and produces validation reports
of data errors and inconsistencies. It also provides the ability to define and evaluate complex business rules, which are outside the scope of metadata, for example, a balance which is the sum of specific transactions. The evaluation reports identify the data items that require cleansing or modification. The tests can be run in "online" mode to assist development or in "batch" mode.
Data Mapper
The data mapping software provides an analyst with a tool to define the precise source to target relationship. The tool requires an analyst with the technical skill to use SQL statements to define the mapping. The migration software can then be generated as SQL queries and incorporated into Data Transformation Services (DTS) packages for export to internal or external tables.
Event Manager
The Event Manager provides a tool to manage the tasks and issues arising during a migration project, including issues raised with suppliers, errors found in testing and actions assigned to users. Event Manager records such tasks and issues against the appropriate items of data, facilitates their communication to third parties and within the project team, and maintains a history of actions taken. |