Why are we unique?

ARCAD-Extract extracts a coherent subset of production data and injects it into another data environment with full referential integrity. A typical use is to populate test environments with representative test data sets extracted directly from the production database.

ARCAD-Extract addresses two main objectives:

• Regeneration of test environments. All of the tables in the data environment are processed. Copying is carried out by record selection according to the values of certain fields.
• Creation of test environments. 

Selected tables are processed in relation to their link with an initial table (master file) used as a base for record selection. ARCAD-Extract generates extraction scripts that can be re-used as often as required to “refresh” test data. It is also possible to retrieve data from a remote production machine and return it to a testing or development machine.

Further, in order to support data confidentiality requirements, ARCAD-Extract has been designed to enable the calling of “scrambling” processes from within the solution itself (during both extraction and injection). This allows custom scrambling according to specific customer requirements that adhere very closely to business rules.