Introduction  

Custom reports in Spirion enable administrators to articulate the outcomes of discovery scans across a variety of datapoints and filters.  

Whether auditing Playbooks for unresolved manual remediation actions, aggregating match counts across specific target types, or generating an age profile of sensitive data locations to ensure the enforcement of retention policies, SDP’s scan results are often only Step One for Data Security Posture Management that involves many stakeholders and solutions. 

A common scenario is taking a report from Sensitive Data Platform (or Manager) and preparing it for ingestion by a downstream, third-party solution whose actions are informed by Spirion’s Privacy-Grade accuracy. One example of this is the integration with Lepide, a leading Data Access Governance (DAG) solution.

Another frequently encountered example is exporting scan results for database scans and preparing them for import into solutions that specialize in remediating structured data. When doing so, the extract, transform, and load (ETL) process is easily defined through Python scripting. This marketplace solution covers how to do so with an example anticipating a specifically formatted CSV import. 

Spirion Products:
Sensitive Data Platform, Sensitive Data Manager

Files:
Datasheet: Database Results ETL with Python