Background

This sample was developed in cooperation with DPOrganizer (https://www.dporganizer.com/) and aims to export classified data as information assets for DPOrganizer to import.

Classification instructions

Create a multi-valued category called "Data Subject Category"

Create tags such as "Employees UK", "Contracts at customers"

Create a multi-valued category called "Personal Data Types"

Create tags such as "Access rights", "IP address", "CV", "Address"

Create a multi-valued category called "Person Responsible"

Create tags such as "Head OSS", "HR"

Categorise columns with the above categories and tags. If the whole table pertains to a certain category above, categorise its primary key

Example output

(Download DPO.CSV)

Data Storage Name	Data Storage Id	Data Subject Category	Person Responsible	Personal Data Types
DatabaseServer1.Logins	664079978790387000	Employees	HR	Credentials
DatabaseServer2.CustomerDb1	664079979042045000	Channel Partners\|Customers Employees and Representatives	Head of OSS	Address
DatabaseServer2.CustomerDb2	664079979100766000	Customers End Users\|Employees	Head of OSS	Email Address\|Telephone Number
DatabaseServer2.Commissions	679352554320035000	Channel Partners	Head of OSS	Address\|Email Address
DatabaseServer2.Commissions	679352556278775000	Channel Partners	Head of OSS	Address\|Email Address
DatabaseServer3.CustomerPortal	679352832104595000	Customers Employees and Representatives	Head of OSS	Telephone Number
DatabaseServer3.CustomerPortal	679352832104595000	Customers Employees and Representatives\|Customers End Users	Head of OSS	Telephone Number
DatabaseServer4.ChannelPartners	692064631996284000	Channel Partners\|Customers Employees and Representatives\|Customers End Users\|Employees	Head of OSS	Call Detail Record

SQL Data Catalog

Integration - Export classification to DPOrganizer

Background

Classification instructions

Example output

Sample export script