Schema Pattern Search to Data Class Association
Editors Note, Q2’19: In addition to the method described below, there is now also available to IRI FieldShield (data masking product) or IRI Voracity (data management platform) users a Data Class Database Masking wizard, which can be used if you have pre-classified your data. It is also designed for use not only within, but across, RDBMS schemas.
Once a Schema Pattern Search is performed in IRI Workbench (WB), the results can be used by the Schema Pattern Search to Data Class Association wizard to assign data classes to the matched columns. The association can be used in various wizards if rules, such as encryption, need to be applied to that data in a consistent, global fashion.
Note that this wizard performs associations similar to the table and file sources scanned and classified in the Data Classification editor, but was designed specifically for schema search results.
The search results used in this example were from scanning an Oracle schema using a credit card regular expression. Right click the file called columnSearchResults.csr in the WB project explorer and select Associate Schema Pattern Search to Data Class from the IRI menu. Select whether to use an existing data class library or make a new one.
The Data Class Selection page will display the columns with matching data found during the pattern search. Check the column and use the drop down in the second column to associate a data class with that column. Classes can also be added or edited on this screen if they were not set up previously.
Upon clicking Finish, the Data Class Library editor is opened showing the data sources, data classes, and class mappings. This is where further editing takes place. For example, a field rule can be assigned to the column. Other columns in the table can be assigned data classes as well.
Using these two wizards before performing data redaction can increase efficiency, as well as offer repeating de-identfication processes and audit trails to support compliance with data privacy regulations.
3 COMMENTS
[…] that results of the Schema Pattern Search wizard described also be automatically associated to your data classes. In addition, DB/schema-wide data class search and data class masking wizards […]
[…] If you need to search and classify data across one or more full databases schemas at once, use the Schema Pattern Search and Schema Pattern Search to Data Class Association […]
[…] columnSearchResults.csr file can be used by the Schema Pattern Search to Data Class Association wizard in WB that takes the column results and assigns data classes to them. This can speed the […]