Product Documentation
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage
  1. Product Documentation
  2. /
  3. Assessment
  4. /
  5. Database Mapping

Database Mapping

Structured Data

Databases are comprised of data organized in a well-defined structure that can be deciphered by computer programs. A common type of structured data is found in relational databases that are designed and accessed through Structured Query Language (SQL). Relational databases are organized as a series of interrelated tables, where each table contains multiple columns of information. The relationships between tables, table names, and column definitions are defined using SQL. To access data within a database, the database must often be restored in the originating database software platform. Depending on the software and the size of the database, this process can be an arduous task. Mining PII from structured data requires defining not only the fields containing PII, but also how those fields relate back to an individual or business.

Canopy’s groundbreaking new database mapping functionality enables reviewers to quickly and easily identify and map the relationships of PII detected within databases.

To access the database mapping workflow, click on the Filters button from the Document List page:

img.png

Click on Databases in the Filter Type section under the Processing & Detection tab:

img_1.png

All supported databases in the project will appear on the data grid to be sorted as needed:

img_3.png

Select a database from the list to see the results of sampled tables:

img_4.png

Click on the ER Diagram button to select tables from the database schema list to view tables and interrelationships:

img_5.png

Tables containing detected PII will be identified and can be selected via checkbox to appear in the entity relationship diagram:

img_8.png

Entity relationship diagrams (ERDs) can be exported or downloaded by clicking Export PNG at the top right of the page:

img_9.png

Canopy’s database mapping functionality is currently in beta. Users will soon be able to independently create their own mapped database table views. At the current time, Canopy supports users by creating mapped database table views reflecting the ERDs that users create. Please contact Customer Success for support using this new beta functionality.