It is common practice amongst test analysts to store their test data in Excel, as it is convenient to do so and provides an easy way to manipulate the data to meet test conditions.

The Proteros Excel interface provides a mechanism whereby test analysts can continue to store their data using Excel but can make that data available to payment systems in a variety of proprietary formats.

There are just 4 steps required to make data stored in Excel available to a particular payment system in native format, as detailed below:

1. Define your target structure using the Proteros Data Dictionary editors
2. Define the mapping between your Excel spreadsheet and your target structure
3. Run the Excel interface module to populate your target structure with your test data
4. Import the resultant test data into the appropriate Proteros payment system simulator for auto conversion to the correct format.

All field definitions are automatically adjusted to ensure correct alignment. For example, numeric data is right justified, zero filled etc.

In order to further enhance the quality of the data and eliminate problems with badly constructed test data, the Proteros validation services are invoked as part of the Excel interface. This validates your test data against the target structures and identifies potential data issues. Data correction can therefore take place ahead of the system under test being exposed to poorly constructed test data.

Furthermore, as the Proteros Data Dictionary services hold the information for the target system, if these structures change you do not need to revisit your spreadsheets and adjust them. The Excel interface ignores target fields that do not exist, thus removing the headache of having to maintain your Excel workbooks if your target system changes.

If you would like further information on this product, please complete the form below and a member of our sales team will contact you, or you can call us on: