Copying and refreshing data between production, test and development environments is daily business for many DBAs. Choosing the right copying method, configuring source and target database, accurately forecasting storage, and eventually testing duplicated data tend to be lengthy complex processes, and even more so when different platforms or RDBMS versions are involved. The need to mask or scramble sensitive customer details when copying data from production to lower environments is an additional challenge to environment refresh processes.
Accelario’s Environment Refresh Manger (ERM) presents a highly efficient and innovative approach to data duplication and refresh processes across environments.
An automated tool, it provides DBAs with unprecedented management abilities and full control both at source and target while accelerating execution and reducing source down time. Data moving is rendered efficient and transparent with ERM, which also automatically compresses data in the target environment and optimizes performance.
Accelario ERM ensures secure and truly hassle-free environment refresh, through its inbuilt Data Masking Engine, preventing sensitive data from reaching unprotected databases.
Through the Accelario management interface, IT managers simply define the fields containing sensitive data, which are scrambled on the fly during refresh. Based on parallel processing with controlled parallel degree, the Accelario masking algorithms include tokens, values-replace, ID generation (credit card numbers, SCN), random values generation, deletion of sensitive data, etc.