Manual Data Classification
You can use Dataedo to find and classify sensitive data in your databases and then share this classification in HTML documentation.
Search and Classify Data
When you imported the schema of your databases, you can use the search function (ctrl + F or search option from the ribbon) to find tables and columns using keywords that you suspect indicate columns containing sensitive data.
Go table by table and review highlighted columns. You can use custom fields) to provide different classifications for columns.
Review Column
You can also use the find column name option to review all columns in all databases with the same name. Right-click the column and choose the Find column option.
A window will open with all columns with the same name. You will be able to review and set classifications for those columns.
Defining Custom Fields
To add custom fields) to your repository, choose the Custom fields option from the ribbon and add a new field. For the new field, provide:
- Title - make it something meaningful, for instance, a name of regulation or a meaningful keyword, like Sensitive data, Classification
- Type - choose Drop-down list, open or closed, depending on if you want users to be able to add new values as they browse the documentation (closed is advised)
- Definition - list all classification labels separated with commas
- Visibility - choose Column at minimum, you may also add Table/View, Parameter, and Term
Share in HTML
When you gathered metadata in the repository, reviewed it, and classified columns, you can now share it with everyone else in convenient HTML documentation like this:
