Data mapping solutions: what the tooling does, and the four columns that do most of it

Published , updated

Data mapping solutions promise to discover where personal data lives across your systems and draw the flows between them. For an enterprise with hundreds of databases that is a real problem worth paying to solve. For a company with a website, a CRM, a mailing tool, a payment processor and a support inbox, the map is a page of writing, and the reason it does not exist is not that it is hard to build but that nobody has been asked to own it.

What the tooling actually does

Automated discovery does three jobs. It connects to systems and classifies the fields it finds, so a column called cust_em is recognized as an email address. It watches traffic or integrations to infer flows between systems. And it keeps the picture current, which is the part with lasting value, because a map is only useful while it matches reality. What it does not do is tell you why you hold something or what you promised about it, and those are the two questions every privacy duty actually turns on.

The blind spot nobody advertises

Discovery finds data in systems it can connect to. The personal data that causes trouble at a small company is usually somewhere else: a spreadsheet of leads on somebody's laptop, an export sitting in a shared drive, a support inbox holding eight years of attachments, a form tool nobody canceled. No scanner reaches those. A conversation with the four people who collect data reaches all of them in an afternoon, which is why the first map should be written by a person and only then handed to tooling to maintain.

The four columns

System, what personal data it holds, why you hold it, and who else can see it. Add retention when you know it and leave it blank when you do not, because a blank is a question and a guess is a false answer. Those four columns answer the disclosure duties in a privacy notice, the recipient list in an access request response, the vendor list your processing agreements cover, and the scope of a deletion request. A fifth column for the contract reference turns it into your vendor register as well.

When buying is the right call

Buy when the number of systems has passed what one person can hold, when data is copied between systems by processes nobody documented, or when you are answering enough access requests that finding the data is the slow part. Do not buy to produce a map you could have written, and do not buy to satisfy an auditor, because an auditor asks whether the map is true rather than what produced it.

Questions people ask about data mapping solutions

Is data mapping a legal requirement?

Not by that name. The obligations are to disclose categories and recipients, to answer requests, and in Europe to keep a record of processing. Each of those is unanswerable without a map, so the map is required by consequence rather than by name.

How often should it be updated?

On the event rather than the calendar: a new tool, a new purpose, a vendor change. A quarterly review of the tool list catches what the events missed.

Who should own it?

One person, named, usually whoever owns the website or operations. Shared ownership of a register means the register is nobody's, and the first stale row is the one that makes the whole document untrustworthy.

Does a map help with access requests?

It is the difference between a search and a hunt. The map tells you the list of places to look, which is what makes an answer inside the statutory deadline routine rather than heroic.

Sources

Related answers

Keep the request record: $10 a monthStart the request record