WORLD CLOCK ValidFrom · when it happened 13 Nov 2025  18:29
BusRoute MS SQL Now (Live)
SYSTEM CLOCK RecordedAt · when we knew 14 Nov 2025  19:55
⚠ Gap detected between WORLD CLOCK and SYSTEM CLOCK 25.5 h late entry
Bi-Temporal Data Engine for Audit-Grade Compliance

What did your database
look like last Tuesday
at 4:00 PM?

Connect your existing operational data — SQL databases, REST APIs, Geotab, DoForms, or Excel — and Transformative builds a living, bi-temporal compliance record automatically. Every change in your source system flows in continuously. Nothing is overwritten. Every version of every record is preserved across time, permanently available to answer any audit question — without requiring you to replace your existing production infrastructure.

Book a Demo  → User Guide
Connects to your existing systems — nothing to replace
Continuous ingestion — every change preserved automatically
Any point in time — exact historical state on demand
Scenarios & forecasting built on your real data
3
Clicks to answer any auditor's "what was true then?" question
Any
Moment in time — query the exact state of your records
4+
Source connectors — SQL, API, Geotab, DoForms, Excel
Zero
Changes to your existing source systems required
Platform

Six questions auditors ask.
All answerable in seconds.

Compliance officers, software resellers, and internal auditors all face the same issue: operational databases don't preserve history in a way that survives strict legal scrutiny. Transformative connects to those systems and builds a permanent, bi-temporal record of every change — so any audit question about any point in time has an unambiguous answer.

🕐

"Show me exactly what existed on that date."

Move the time slider to any date in the past and the entire platform rewinds — every table, every record, every count reflects your exact operational state at that moment. Not a report. The actual data.

📋

"Was this record entered on time, or after the fact?"

Gap detection compares when a record was true in the real world vs when it arrived in the system. In the Bi-Temporal Analysis panel, late entries trigger explicit alerts — for example, "Overnight gap detected: This submission was recorded 1d 2h after the event occurred." A built-in Gap Distribution chart instantly segments your operations into latency buckets, from under 1 hour to over 48 hours, so you can audit systemic delays at a glance.

🔍

"What changed between these two versions?"

Every change to every record is preserved with a timestamp. Select any record and open Version History to see a complete diff — what changed, when, and what it looked like before.

🤖

"Find all records that meet this condition."

Ask in plain English — no SQL needed. The AI infers the correct SQL relationships, displays its inferred table tracking chips, and returns clean, readable results a compliance officer can act on without an IT ticket or a developer in the room.

🔮

"Is this metric trending outside acceptable range?"

Switch the AI bar into Predict mode. Transformative generates a structured Forecast panel displaying key metrics — Trend, Projection, Seasonality, and an AI-generated Recommended Action — alongside a side-by-side historical-vs-forecast grid. Divergence alerts fire when actuals deviate beyond your set threshold.

"What would the numbers look like if we changed this?"

Branch off from any historical date to model "what-if" operational shifts without touching live production data. Published scenarios are permanent and auditable for executive risk reviews — which means they stand up in a compliance review as well as a board presentation.

For Executives & Compliance Staff

No SQL. No developer.
Just ask the question.

The AI search bar is the bridge between a complex audit-grade data engine and the people who actually need the answers — compliance officers, operations managers, auditors on-site who can't wait for an IT ticket.

Type a question in plain English. The platform works out which table to query, builds the filter or aggregation, and returns results with a written explanation — not just a data dump.

  • Filter mode — narrow the live grid to exactly the records you need
  • Insight mode — get a written analysis with aggregated numbers
  • Predict mode — project any metric forward and set a divergence alert
  • Works across all connected data sources simultaneously
transformative — AI query bar
⚡ Filter
🔍 Insight
🔮 Predict
show routes with a data entry gap > 12 hours Ask
Inferred table: RouteTable 📌
INSIGHT RESULT
7 routes have a gap between application time and system time exceeding 12 hours. The largest gap is 25.5 hours on Route 12 – Croydon North, recorded 14 Nov 2025 for an event that occurred 13 Nov 2025.
Route 12 – Croydon North 25.5h gap ⚠
Route 7 – Ringwood Express 14.2h gap
Route 15 – Lilydale Loop 13.1h gap
transformative — bus route dashboard
Transformative dashboard home view
Dashboard

Your whole operation in one view

Select a data source and every provisioned table appears as a tab — Routes, Vehicles, Employees, Assignments, Trip Log. Click any row to open the full record and its connected detail panel on the right.

  • Alert rules and data quality checks built into the toolbar
  • Filter grid and AI query bar work side-by-side
  • Tab pinning remembers your preferred working table
  • Drill from any record straight into child records without leaving the page
transformative — AI query bar
Transformative AI query bar
AI Intelligence

Ask anything. In plain English.

Three modes in one bar. Switch between Filter (narrow the grid), Insight (summarise and analyse), and Predict (forecast a trend). The AI reads your table relationships, infers intent, and shows its working.

  • Filter — "show routes with stops in zone DOH"
  • Insight — "summarise vehicle utilisation across the fleet"
  • Predict — "forecast timesheet hours over the next 8 weeks"
  • Table inference chip shows which table it queried — click to override
transformative — version history & bi-temporal analysis
Version history and bi-temporal analysis
Temporal Intelligence

See any record as it was on any date

Every change is preserved. Move the time scrubber to last month and the entire platform rewinds — every table, every record, every count reflects your exact operational state on that date.

  • Version history panel shows every change with timestamps and diffs
  • Bi-temporal gap detection flags when data arrived late vs when it happened
  • Application time vs system time — both tracked on every record
  • Amber banner reminds you you're in historical view, one click to return to present
transformative — GPS route map & geotab trips
GPS route map view
Geospatial

Maps that draw themselves from your data

Select any route and the GPS breadcrumb trail appears automatically — the exact path your vehicles travelled, timestamped at every interval. No map configuration, no coordinate imports.

  • Stop markers overlaid on the GPS track with hover detail
  • Geotab trip strip shows each journey card — click to isolate on the map
  • All-records scatter view shows where activity concentrates across your whole operation
  • Works with Geotab, SQL Server coordinates, and any REST API with lat/lng fields
transformative — forecasting & divergence alerts
Forecast and divergence alert chart
Predictive

Forecast any metric. Get alerted when it drifts.

Switch the AI bar to Predict mode and type what you want to project. The platform analyses historical patterns, generates a weekly forecast, and monitors incoming actuals — alerting you the moment reality diverges from the projection.

  • Teal baseline vs dotted purple forecast — visual divergence at a glance
  • Set alert threshold: "alert me when actuals diverge more than 15% for 2 consecutive weeks"
  • Per-period breakdown shows forecasted vs actual vs percentage drift
  • Forecasts stored and tracked over time — accuracy improves as history accumulates
The Audit Scenario That Breaks Most Systems

An event happened on the 13th.
The system was told on the 14th.
Which date matters to a regulator?

Traditional systems timestamp the entry date and call it done. In a compliance audit, that 25.5-hour gap is the difference between a clean record and a finding. Transformative surfaces it automatically — on every record, every time, without anyone having to look for it.

⊙ Bi-Temporal Analysis
Present Late Backdate Overnight
WORLD CLOCK
ValidFrom · when it happened
13 Nov 2025
18:29
25.5h
gap
SYSTEM CLOCK
RecordedAt · when we knew
14 Nov 2025
19:55
🌙
Overnight gap detected
This submission was recorded 14.2h after the event occurred. 3 versions recorded.
Version History — 3 versions
v1  9-minute gap
13 Nov 2025 18:29 → 13 Nov 2025 18:38  ·  James Wilson
Driver Start Time: 08:00:00 → 08:32:00
v2  2-hour gap
13 Nov 2025 12:00 → 13 Nov 2025 14:05  ·  James Wilson
v3  current
13 Nov 2025 12:48 → 14 Nov 2025 02:55  ·  Tom Baker
🌙

The overnight gap — what it means

This record describes something that happened at 6:29 PM on the 13th. The system wasn't told until 7:55 PM the following day — 25.5 hours later. In most systems, that gap is invisible. Here it is flagged, measured, and attached to the record permanently.

📋

Three versions — a complete correction trail

The record was corrected twice after initial entry. Version 1 corrected the driver start time. Version 2 revised the window. Version 3 is the current authoritative state. All three versions exist. An auditor can see exactly what was believed at each point.

⚖️

Why regulators care about the gap, not just the record

A compliance obligation that required awareness on the 13th was not met if the system wasn't updated until the 14th — regardless of what the final record says. Transformative captures the distinction between "it happened" and "we knew it happened in time."

🔎

No SQL. No developer. Visible to everyone.

This analysis is surfaced automatically on every record. A compliance officer, an auditor on-site, or a board member reviewing risk — all of them see the same information, without needing to understand the database architecture behind it.

How It Works

Your audit trail has
two timelines. Most systems only keep one.

When a late-arriving batch corrects a record, a traditional system overwrites the old value. The auditor asks what existed before the correction — and the answer is gone. Transformative keeps both versions. Always.

📅

When it happened vs when you recorded it

A vehicle was assigned to a route from Monday. The paperwork arrived Wednesday. Traditional systems timestamp it Wednesday and the Monday gap is invisible. Transformative stores both — and flags the gap explicitly.

🖥️

Corrections don't destroy evidence

When a record is corrected — wrong date, missed entry, backdated amendment — the correction is stored alongside the original. An auditor can see both the error and the fix, timestamped and immutable.

🔍

Late arrivals are measured, not hidden

In regulated industries, "did we know in time?" is a different question from "did it happen?" Gap detection answers the second question — automatically, on every record, with no manual intervention required.

🔒

GDPR erasure without breaking the audit ledger

Personal data is encrypted per individual with AES-256. Erasure destroys the key — the records remain intact for audit purposes, personal content becomes permanently unreadable. Right to be forgotten, without right to be invisible.

bi-temporal query — SQL Server zero config
-- Where was unit BRT-12 assigned at 07:30
-- as your system knew it at 09:15?

SELECT unit, assignment, depot
FROM emgVehicle
WHERE ValidFrom <= '07:30'
AND ValidTo > '07:30'
AND RecordedAt <= '09:15'

-- Returns the truth as it was known
-- at that moment in time. Not what
-- was corrected or added later.

✓ Immutable audit ledger
✓ Late-arrival gap detection
✓ GDPR crypto-shredding compatible
PII Protection — Crypto-shredding

Personal fields are encrypted per data subject with AES-256. Erasure destroys the key — the records remain intact in the immutable ledger, but personal content becomes permanently unreadable. GDPR Article 17 compliant without breaking your audit trail.

See the "last Tuesday at 4 PM" answer live

Book a demo and we'll walk you through a live vertical with pre-loaded version history and gap detection. Move the time slider to any past date and watch every record rewind in real time.

What It Looks Like

Connect your data.
The platform does the rest.

Transformative doesn’t ship pre-built verticals. Connect your operational data through the Authority portal and the platform produces a bi-temporal compliance dashboard tailored to your data structure — with AI queries, maps, charts, and full audit history built in automatically. These are examples of what that looks like across different industries.

🚒

Emergency Services

Map your incident database and the engine generates a command-style dashboard tracking Incident Management, Crew Rostering, and Vehicle Deployment, adding a comprehensive historical scrubber for post-incident compliance reviews.

Bi-temporal audit history · Dispatch management
♿️

NDIS & Aged Care

Ingest your client schedules and care notes and the platform builds an interface focused on Support Logs and Care Plans, giving operators an instant way to prove to an auditor exactly what services were active for a participant on any historical date.

NDIS compliance · GDPR / Privacy Act ready
⛑️

Work Health & Safety

Connect your incident reporting tool and the platform maps your Hazard Registers and Corrective Actions, automatically calculating and flagging the gap between when an industrial incident happened and when staff actually recorded it.

ISO 45001 audit trail · Late entry detection
🏛️

Local Government Assets

Connect your asset register and maintenance systems and the platform builds a permanent lifecycle record — every condition assessment, every maintenance event, every change preserved and queryable.

Asset lifecycle · NAMS compatible
⛏️

Mining & Exploration

Connect your exploration activity data and the platform makes it straightforward to reconstruct exactly what expenditure was attributable to exploration in any reporting period — built for R&D tax compliance.

R&D tax compliance · ATO ready
🚌

Fleet & Transport

Connect your telematics and mobile field forms and the platform generates an integrated dashboard with tabs for Route Management, Vehicles, and Trip Logs. Selecting a route record dynamically populates an interactive Geotab Trips companion panel, syncing vehicle speed, trip cards, and live GPS map tracking on a single screen.

Geotab · SQL Ingestor · Paylocity integration

How configuration works

Setup requires understanding your data structure — that’s not a limitation, it’s the point. The onboarding interface automatically analyzes source structures, detects existing relationships such as SQL foreign keys, and recommends the ideal fields to track for real-world vs system time. Configuration is done through the Authority portal with AI assistance, and typically takes anywhere from an hour to a few days depending on data complexity. We train resellers to do this themselves, or supply the service directly.

Get Started

Or book a live walkthrough

Prefer a conversation? Pick a time and we'll walk through your systems, connect to a sample data source, and show you the audit trail against your actual data — typically within a day of the call.

No commitment required  ·  30-minute Zoom call  ·  Australia & International welcome