Use Case · Compliance

Compliance export on the Software Lifecycle Cloud

A compliance export on KERNSTACK is a declared job instead of a scramble: an auditor’s request names tables and a time window, a worker assembles the matching records into a bucket as a structured bundle with a checksum manifest, and delivery is a time-limited presigned link. The export itself is logged — who asked, what was included, which checksum left the building.

The engineering bottleneck with assembled stacks

Auditors ask for “all records relating to X between these dates” and engineering discovers the question has no owner: the data is spread across tables and tools, the export is a hand-written script run once and deleted, and producing the same export again — the auditor’s follow-up question, always — is impossible because nobody kept the script or the parameters.

Architecture on the Software Lifecycle Cloud

The export is a workflow with a human at each end. A request step records the scope; a worker extracts the rows into per-table files, computes SHA checksums, and writes a manifest describing tables, windows, row counts, and hashes. An approver reviews the scope before the bundle leaves, and the presigned delivery link expires — the export is an event in the project’s history, not a file on a laptop.

Reproducibility is the compliance property

Because scope, code, and manifest are project artifacts, re-running last quarter’s export with the same parameters yields a bundle whose manifest can be compared line by line. That is what “we have a process” means to an auditor — not that an export exists, but that its existence is repeatable and its contents are self-describing.

  • Checksum manifest travels with the bundle, so the recipient verifies integrity without calling you
  • Scope approval is a human workflow step — nothing leaves on a single person’s say-so
  • The export log (requester, scope, approver, checksum) is itself exportable for the next audit

What this does not automate

Judgement about scope — whether the auditor should get table A, whether a field must be redacted — stays with your compliance owner, expressed in the request and approval steps. The system’s contribution is that once judgement is exercised, execution is exact, recorded, and repeatable.

Frequently asked questions

A structured bundle: one file per table in JSON or CSV, plus a manifest with row counts, time windows, and SHA checksums for every file. It opens with ordinary tools and verifies without any KERNSTACK software.

Yes. The worker code, the scope parameters, and the manifest are kept with the project, so the same request re-runs deterministically and the manifests can be diffed. Deleted-since records are the only honest caveat, and retention holds make those visible.

People your workflow names: a requester creates the scope, a different approver confirms it at a human step before packaging. That separation of duties is declared in the workflow, not in a wiki page.

Related capabilities, architectures, and comparisons

Ship your stack on the Software Lifecycle Cloud.

Closed preview on dedicated European infrastructure. Bring a repository or start from a blueprint.