Background

This sample was developed in cooperation with OneTrust (https://www.onetrust.com/) and aims to export classified data as Assets into the Data Mapping module of an OneTrust installation.

Set-up in OneTrust

• There must be a registered Asset type called "Instance" in OneTrust (Data Mapping > Setup > Inventory Manager > Asset Attributes > Type). This represents the database instance / server wherein the classified databases lives. This asset can then be associated with other Asset types, such as Application or System, as appropriate in your unique scenario.

Classification instructions

• Create a multi-valued category called "Data Subject"
• Create tags such as "Employees", "Customers". Please note that these tag names must match the Data Subject Type Keys registered in OneTrust (Data Mapping > Setup > Inventory Manager > Data Subject Types > Key)
• Create a multi-valued category called "Data Elements"
• Create tags such as "Full Name", "IP address". Again, please note that these tag names must match the Data Element Keys registered in OneTrust (Data Mapping > Setup > Inventory Manager > Data Elements > Key)
• Categorise columns with the above categories and tags. If the whole table pertains to a certain category above, categorise its primary key.

Sample export script