Now that you’re set up, let’s get an overview of DATPROF Privacy!
DATPROF Privacy is a database solution to easily build advanced masking templates for complex databases.
A masking template consists of the meta data of a database and the configured masking rules on the tables and columns. This meta data will be saved on your hard disk in an *.DPV file. The DPV file is an XML file that contains all of the imported meta data and the configured masking rules. This file can be checked in, in version control systems like Git, SVN, CVS or any other file version control system.
The software enables users to add different kind of masking function on top of their data model. Privacy will than generate SQL scripts that can be executed directly on the database to mask the data in place. The data is actually manipulated within the database and cannot be reversed engineered. Because the data is actually changed within the database, it cannot be used for Dynamic (role based) Data Masking.
An advanced bypass system will make sure that the masking process can be directly executed within the database itself by temporary bypassing all constraints, indexes and triggers. That means that DATPROF Privacy can be used to mask terabytes of data without extracting any of the data outside the database.
There are multiple ways of deploying your masking template to the database. During development you can execute the template directly from DATPROF Privacy to the database. When your masking template is complete you can also generate a Runtime application. This application can be uploaded and installed in DATPROF Runtime. DATPROF Runtime is webbased server application which enables users to manage their test data from one central portal. Masking templates can be executed on different environments and can be fully automated using the Runtime API. This training will only focusing on deploying the template directly from DATPROF Privacy.
Because DATPROF Privacy is an database specific solution not every database is directly supported. However most of the common databases, like Oracle, Microsoft SQL Server, IBM DB2, PostgreSQL and more can be directly masked within the database, For a complete overview of all supported database check the release notes of DATPROF Privacy.