In a properly managed DevOps environment, only anonymized data should be available in Dev/Test databases.
- The Dev/Test database environment should be open by nature with little constraints in order not to impair the work of the Designers, Developers and Testers
- The data on those environments should be as close as possible to Prod data but should be protected. The best way to handle this “dilemma” is to anonymize sensitive data for two main purposes:
– Complying with legal and regulatory concerns about sensitive personal data protection
– Protecting business data from possible breaches
Which data should be anonymized?
- Sensitive personal data should not be attributed to an identifiable person
- Sensitive business data should not be retrieved by the competition
What is « sensitive » is decided by legal, cultural and business concerns depending on the specific organization and country.
Anonymization technical constraints
When data is anonymized, it is imperative not to break existing application constraints and validations
- Preserving the inner coherence of composite data (e.g.: address with street, city, zip…)
- Preserving the structure rules of the data (e.g.: Credit Card, Iban… structure)
- Preserving dependency rules (e.g.: Social Security number might contain birth date which is also stored in a different column of the record)
Anonymize-DB provides high level of freedom to Test and Development teams, allowing them to work with high quality data without endangering compliance to legal regulations or to internal business rules.
Its automatic, flexible and smart process, provides the anonymization manager with a user friendly and performant tool to anonymize sensitive business or personal data in your Dev/Test databases.
Your security and legal compliance is enforced.
- This module can be used as a complete stand-alone solution (independent of other Xcase for i solutions) to comply with your regulation obligations.
- Anonymize-DB supports multiple concurrent RDBMS (DB2, SQL Server, My SQL…)
What is the Anonymize-DB methodology?
Identifying Column Groups: Anonymize-DB identifies groups of columns where data appear in multiple locations across the database, allowing you to identify them as belonging to the same “domain”, and to anonymize them consistently.
Dictionaries: The anonymization consistency is ensured by the use of conversion dictionaries, stored in a secured location. The conversion method in these dictionaries is configured by the anonymization manager.
Methods of Anonymization: 8 different anonymization methods are proposed, allowing to use the most appropriate one to each type of data, and to mix methods to further enforce security.
Data in multiple and heterogeneous databases: Anonymize-DB creates unified consistent dictionaries even when data are stored in multiple and heterogeneous databases.
Activation: Anonymize-DB produces an SQL script, which can be transmitted and ran by the infrastructure operator, which anonymizes the data. This script can be used for multiple data sets and environments yielding to a repeatable and automatable process.
Performance: When properly set, the amount of data to be anonymized is in general small. Consequently, the time needed to anonymize data does not add much to the test database delivery process.