Onward is a collaborative tool for all team members
- Interpret COBOL copybooks 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.
- Upload to Onward database, both from flat files and SQL Server import.
- Online viewing of data (from flat files and SQL Server). No SQL knowledge required.
- Profile your source and target data. Online editing of analysis results, including Drill-Down capability.
- Verify quality of source and target data.
- Map target tables and columns from source.
- Mapping versioning. All changes are archived.
- Mapping export to Excel. For coders and QA staff.
- Real-time tracking of project issues, defects, and tasks.
- Supporting text and image files may be attached to recorded issues.
Browse text and image files that have been attached to recorded issues (TIMs).
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 6 SQL queries:
