Technical Solutions

DATA MIGRATION FEATURES

• Extract data from any system and retrieve required data elements.

• Change the old data format and translate business function codes.

• Parse name and address (and other data) from any known format.

• Negotiate with the client’s current vendor as an unbiased consultant.

• Provide balancing reports at every level.

• Extract and convert historical records.

• We probably have experience with the legacy system.

• Acquire data via FTP site, remote dial-in or overnight mail.

• Call us with any questions about data, media, platform or data transmission.

FEATURES:

• Internal data integrity

• Custom data mapping 

• Identify and resolve duplicates

• Eliminate manual data entry 

• Purge old data

• History transactions

• Validate/balance transferred data

REPORT WRITING:

• Crystal Reports

• Access

TAPE AND FLOPPY DISK MEDIA MIGRATIONS:

DATA FILE MIGRATIONS:

PLATFORMS:

• HP 3000/9000 

• IBM AS/400

• IBM System/34/36/38

• DEC/VAX Mainframe

• MS/DOS 

• Windows / NT

• Novell

• UNIX

TRANSLATING DATA

Custom designed tools are used to translate data from its existing format or representation to a selected format or representation.  We have trained our specialists in the use of various data formats, i.e. packed signed, floating point, hexadecimal, Binary, Text, EPCDIC, ANSII, etc. We provide them with data maps of the source data, when available, that identifies length and type of the data fields, special identifiers such as a byte that identifies a field length, etc.

Most data coming into a data conversion resides on old and poorly documented systems. However, our skills in data formats and data manipulation enable us to get accurate data from these poorly defined and even undefined databases.

Some examples of the many data formats commonly used in legacy and new technology applications are listed below. We regularly work with these and many more.

DATA TYPES (there are 64+; the most common are listed here:)

• 32 bit Floating Point 

• 80 bit Floating Point (and 8 other Floating Point types)

• Binary (multiple lengths with or without implied decimal points)

• Packed Decimal

• Display number with embedded sign

• Pascal String

• Date and Time (multiple formats)

DATABASE TYPES: (about 100+; some of the most common are listed here:)

DATA ENCODING FORMATS:

• ASCII

• EPCDIC (by country)

• ANSI

• MS-DOS

FILE CHARACTERISTICS:

• Fixed length blocks

• Variable length blocks

• Labeled files

• Unlabeled files