Validata SAS | ALM for Banking and Finance

Switch to desktop Register Login

Test Data Management

How do we create / generate test data?
Validata’s methodology instructs for test cases to use migrated test data from legacy migrations or system upgrades. For test data generation the tool is also using the client’s requirements, runs workshops with the testing teams in order to validate the good test data for the test scenarios.

During the test cases creation phase, Validata has the ability and the technology to verify in real time, that the scenario contains the correct test data that meets SUT screen requirements before even we move to the test cases execution phase. With that way we can speed up and ensure the test cases structure, reducing the time we need to indentify the need test data and improve the productivity.
How can we populate it into database?
Either if we are talking about population in Validata’s database or any other database or system, Validata is using its prebuilt adapters to read, extract, transform and populate data to any database is needed. The adapters support also Graphical user interfaces so even if Validata doesn’t have direct access to the databases it can still read, extract, transform and populate data thought the GUI( Desktop, Web) no matter how the interface looks like. This ability is provided by the fact that Validata can store any object / metadata, and identify any structure, object, screen, window that is available.
How Validata can handle “synthetic” test data?
Validata has the ability to import and store any flat files in its repository. This enables the user for subset selections or records with full version control if the file structure or data records get updated. Easy masking of valuable data, look up features, ability to edit the views or calculate derived values such as trailer totals, data aging, data filtering, data consolidation, data profiling, data archiving are the feature s that are introduced and supported by Validata’s Data manager module.
How do you design test data in to the tool?
The test data are getting designed based on the system’s screen requirements and settings following the defined business rules of the client. All test data are getting stored in to Validata’s repository, where they can be managed, organized, grouped and profiled against specific rules and settings. Once they have been created they can be validated real time against the system to identify any issues or missing information.
How Validata can manage Flat files?
Flat files are data files that contain records with no structured relationships. Additional knowledge is required to interpret these files such as the file format properties. Getting advantage from Validata capabilities, our clients are using the tool in order to extract the information from systems that are running with flat files, and store them in to Validata Object oriented database with faster performance. This enables them to import multiple files in to Validata’Ss repository storing their associations in order to keep and maintain data records relations. As a benefit our clients don’t need to keep old systems up and running avoiding expensive maintenances and resources.
How Validata uses data objects. What is your data coverage?
Validata is using that objects in order to store data information. In Validata data objects are stored and organized under typicals and catalogues. Data objects in Validata contain additional information such as, functions, variables, data structures, hierarchies. By handing so easily the data objects Validata can support any complex database structures for Migration data archiving and testing purposes. For this reason our data coverage reached 100% as we are capable to store any type of data information for flat files, complex files, up to blob files.
Does Validata support Data masking for sensitive information?
Valuable information on data that are used for migration, upgrade or testing purposes can be masked and encoded protecting the privacy of the banks clients. Validata is offering prebuilt mechanisms to encode the data during their extraction from the source systems. The stored data in to Validata remain encoded until we decide to load them on the target system. The same mechanism decodes the data to the original version during the load process. In that way we can ensure that sensitive customer information is not leaked to Validata users.
What Data quality features the tool can offer?
Validata is offering a variety of features in order to manage the Data quality aspects that need to be handed in a project. The Data quality aspects that Validata offers are:

Data Accuracy
Data Completeness
Data Status update and versioning
Data Relevance
Data Consistence across multiple data sources
Data Reliability
Data Accessibility

To achieve those aspects the features that are offered by the tool are:

Data Profiling
- Databases Structure Modelling and synchronization
- Source Analysis and dependencies
- Redundancy analysis Data
Cleansing standardization
- Prebuilt Templates for data cleansing
- Prebuilt rules for Data cleansing
- Record Matching and identification
- Automated Scheduled tasks for Data cleansing process
Data reporting
- Consolidation reporting
- Automated reconciliation engine
- Prebuilt Reconciliation Reporting patterns
Does Validata support Database subsets methods and techniques?
Validata is using database subsets in order to slice and dice database versions for more efficient database and migration testing. Database models and versions can be stored in multiple catalogues under in the tool, containing multiple versions of data records with full history logs for changes. In that way data validation and quality processes are becoming more fast and efficient.
Does Validata support Data archiving?
Validata Test Data Manager enables you to achieve with the best possible performance, archiving information to your chosen criteria without losing access to your data. All old test data from the legacy systems are extracted and stored in validates High performance Data archiving area. Data views, searching filters and reports are created on top of it providing any required information for future reference.