ONWARD is a collaborative tool for all conversion team members


The main features of ONWARD are:


Record layouts/structures

  • Interpret COBOL and SQL Server record structures.
  • Enter metadata, such as field descriptions, date types, codes, etc.
  • Enter allowed values, enabling identification of data values permitted / not permitted.        
  • Enter data rules for character, numeric, and date fields.
  • Create masking rules for sensitive data, such as Social Security Numbers.


Uploading your data

  • Upload to ONWARD database, both from flat files and SQL Server import.
  • Profile your data. Online editing of analysis results, including Drill-Down capability.
  • Online viewing of data (from flat files and SQL Server). No SQL knowledge required.


Source-to-target mapping

  • Mapping versioning. 
  • Mapping export to Excel. 


Tasks & Issues Manager (TIM)

  • Issues/defects/tasks tracking and reporting. Text and/or image type files may be attached to TIMs.


Attachments Manager

  • Browse text and image files that are attached to TIMs.


Custom queries

  • SQL queries may be developed. If useful to the project, these may be uploaded to ONWARD. Any

      team member can run these and results are sent to Excel.

      Onward is installed with 5 SQL queries:

     


How will ONWARD help my data conversion project?

       Automated processes save time and reduce human error.

       Single database keeps information current, consistent, & accessible for team members.

       Early identification of data anomalies, invalid and problematic data.

       Create custom queries for creating reports in Excel.

       Reduces risk of costly show-stoppers late in project.


ONWARD will not code or run your data conversion, but the many features 

of the tool will assist in making your conversion project a successful one.