DWH data protection concept

The DWH data protection project is part of the customer's program to implement the EU GDPR and BDSG data protection laws. The DWH contains around 20,000 tables with their 250,000 columns from more than 50 source systems, which are loaded to a teradata database via the Oracle Data Integrator (ODI). More than 100 reports are prepared from the DWH using SAP BO, classic data marts or even Excel exports. The content of these reports is checked for personal data. In the target conceptual design, a decision is reached for each attribute in the ETL paths about whether it can continue to be loaded, whether it needs to be anonymized or encrypted, or whether it needs to be removed from the loading path. A data protection impact assessment is carried out for each report to check whether the report can remain unchanged or it needs to be adapted or discontinued. Instructions, e.g. for database administrators on how to handle backups and log files, complement the technical measures for data protection.