How the Netron Data Migration Framework Turns Legacy into Relational

1. ANALYSIS: An incremental approach to reduce complexity and risk

Working with a cross-functional team of your data modelers, application developers, and business analysts, Netron consultants conduct JAD sessions to accurately identify the source-to-target data relationships that need to be migrated. Netron’s approach organizes the project into manageable portions, focusing on 10 to 20 tables at a time relating to a specific business function—greatly reducing complications and helping you to better manage your project scope. Source and target data structures are mapped and data transformation rules are captured using state transition diagrams. Information in these diagrams provides the specs that are fed into our unique Netron Data Migration Framework to produce the extract, transform, and load programs required to migrate your data.

2. CONSTRUCTION: Rapid development of data migration programs

Netron’s consultants use our proven Netron Data Migration Framework consisting of data components, templates, wizards, and tools that let us quickly develop data migration programs for moving your data from the source database to the target model. The productivity benefits of our framework will prove to be a critical success factor in your data migration. Not only does the Netron Data Migration Framework build data migration programs that correspond to the analysis just completed, the framework, in conjunction with our methodology, makes it easy to do data scrubbing or to correct analysis mistakes. Once unaccounted conditions are identified, it’s just a matter of updating the diagrams, making minor adjustments to the framework, and regenerating the programs.

3. EXECUTION: Turning legacy into relational

The generated migration programs now navigate the input data sets, performing the necessary fan-in, fan-out, data scrubbing and validation operations to produce an ouput file ready for loading into the target RDBMS. Along the way, a complete set of audit logs and error reports is produced automatically, ready for the validation steps, and highlighting any need for a further iteration.

4. VALIDATION & TESTING: Ensuring a complete and accurate migration process

With millions of records spanning the entire source database, Netron consultants take special care with the testing and validation phase of your data migration effort to ensure the programs accurately and completely transfer the data. Tasks include unit testing, examining log and audit files, data scrubbing, system testing, spot checking, and cross validation of the source and targeted databases xnxx.

5. ITERATIVE REFINEMENT: The key to successful data migration

Second and third iterations are a fact of data migration life—nobody gets it right the first time because complex legacy data is difficult to successfully clean and migrate on the first try. Here’s the twofold Netron Frameworks advantage: The programs we create using the Netron Data Migration Framework have built-in exception handling. And they’re designed with rapid iteration in mind. That means any problems associated with the applications are immediately documented into log and audit reports including hidden data exception and data scrubbing requirements, many of which are unknown at the start of the data migration project, as well as invalid assumptions made at the requirements gathering phase. Then the transition rules can be quickly updated and validated, and the programs regenerated and re-executed. Each iteration helps make the subsequent iteration more robust and complete than the previous one until no exceptions are found.

A services-based solution that offers:

• Incremental conversion to reduce project risk
• Business process driven JAD analysis to reduce complexity
• State transition methodology to define data transformation
• Iterative refinement for better data scrubbing
• Rigorous validation and testing
• Flexible data migration framework for rapid program development/migration
• Rules-based program generation
• Innovative analysis tools for finding business rules
• Intuitive development tools for generating better programs faster using new data

Preferred Source and Target Platforms

Source: Netron Data Migration Process can migrate data from MVS (CICS, IMS/DB and batch environments), OS/400, OS/2, Wang VS, and OpenVMS.

Target: Most Unix and all Windows server platforms. If we haven’t mentioned your platform, please contact Netron — our approach’s adaptability means that it can probably be customized to support your needs.

Supported Source and Target Databases

Source: For legacy data, any database that has Cobol access including IMS, VSAM, sequential files, DB2, and Oracle as well as proprietary legacy databases (e.g., Wang DMS or ) that are no longer fully supported by their vendors.

Target: any RDBMS that can load data from text files, or that is supported by ODBC.