Software - Envision Series

Today:

Envision Series - AutoMap

AutoMap is a dedicated meta-data mapping and data conversion tool enabling legacy data definitions and data content to be converted into a relational database format used by Envision Series. AutoMap, uses Microsoft Access and ODBC to import data definitions and data content from ODBC compliant legacy databases. Alternatively, non ODBC-compliant legacy data can be imported from flat files. AutoMap allows to visually map legacy data field definitions into Envision Series' data model as it appears through Envision Series on-line transactions. Once the meta-data mapping is completed, AutoMap uses this mapping and the actual legacy data records to create transaction files to be processed by AutoConvert.

AutoConvert uses Envision Series application logic to validate legacy data; any mismatched data errors will be edited by the application logic and erroneous data will automatically be recycled through AutoMap. Erroneous data can be corrected within AutoMap and new transaction files created for submission through AutoConvert.

Functions and Features

Application Interfaces

ODBC interface for viewing and obtaining legacy data in user-friendly format
Visual interface for mapping legacy tables to Envision Series on-line transactions fields
Association of transformation functions and/or default values with mapping
Grouping of related data at a functional module level
Provision for creating batches that group transactions
Transaction data files formatted in a user-friendly format
Comprehensive data conversion error consolidation process
Log file to maintain history of data conversion cycles
Ability to use Microsoft Office tools such as Access, Excel, Word, Project for easy tracking of data conversion process
Automatic extraction of sub-sets of legacy data for testing purposes

AutoConvert
AutoView
All Envision Series modules