Legacy Data Access
One person holds the terminal commands, the ODBC passwords and the mental model of your 2004 system. When they leave — retirement, resignation, illness — everything they knew leaves with them. An agent on that server captures the data and the access before that day: a read-only web dashboard your whole team can use, no migration, no open ports, no disruption.
Unlock Your DataWhat Happens the Day That Person Leaves?
In every sysadmin forum on the internet, the same story appears in different costumes: an entire operation running on one undocumented database, and one person who understands it. When that person is suddenly unavailable, the business discovers what "single point of failure" actually means. It is rarely announced. It just happens.
The retirement that was never handed over
Thirty years of 'I'll write it down one day'. The successor watches the commands being typed but never learns why. Six months after the leaving party, nobody can produce last year's stock valuation.
The resignation with two weeks' notice
Garden leave, NDAs, a contractor quote to 'document the system' that never gets approved. The knowledge was never in the documentation — it was in the person.
Illness, or worse
The story sysadmins tell each other with a shudder: the employee who passed away, and the Access database nobody can open. It is the worst version of this problem, and it is not rare.
The auditor who calls during the holiday
'Pull seven years of records' is a routine compliance request — unless the only person who can boot the legacy box and work the export is on a boat. The deadline doesn't care.
What the business actually loses isn't the data
The data is still on the disk. What leaves is the interpretation: which of those three product tables is live, which column was deprecated in 2011, why that nightly job can't be cancelled, which figures the auditors were given last year. A database without its interpreter is not an asset — it's an unexploded device.
And it's a risk everyone else can see. Due diligence, insurance renewals and lender reviews all ask the same question: if that person left tomorrow, could you produce the numbers? "Bus factor: one" is a line in a risk register — or a reason the deal falls through.
The agent fixes both halves. It captures the data into a queryable replica and turns the tribal knowledge into something documented: schema walkthrough, query definitions, saved reports. The dashboard makes the knowledge ambient — available to everyone — instead of personal, held by one person.
The Essential-Data Trap
Compliance events
Audit, tax inquiry, insurance claim, legal discovery — 'pull 7 years of records' means booting the legacy box and praying it still runs.
Vendor hostage situations
Proprietary formats, per-export fees, or a vendor that's gone — the data exists but isn't yours in any usable sense.
Key-person risk
Only Dave knows the terminal commands for the 2004 system. Dave retires, and the data becomes legend.
Business blockers
M&A diligence, insurance renewals, bank lending — all demand historical data the company can't easily produce.
How It Works
Agent on the server
A lightweight Windows service installs beside your legacy app — SQL Server, Access, proprietary formats, file shares. It makes outbound connections only: no open ports, no VPN, no firewall changes.
Continuous replica
Your data is continuously extracted to a queryable cloud copy — change-tracking, not dumps. Read-only, scoped, audited. The production system never takes the load.
Web dashboard
A modern web interface gives your team the data in a browser — search, reports, saved queries. From a phone on-site or a laptop at home, without 'dialing in' to anything.
Siloed Applications
Line-of-business apps, on-prem ERPs, practice management, legacy POS — anything holding data you can't reach without RDP.
Queryable Web Surface
Saved queries, dashboards and search over your data — employees get the answers, not a connection to the database.
Escape Hatch
Encrypted backup and a portable replica — vendor goes dark, app hits end-of-life, machine dies: your data is already safe elsewhere.
Better Than the Alternatives
VPN / RDP
Network-level access — broad, risky, needs client config, and still just gives a connection. You get the pipe, not the data.
BI tools (Power BI, Tableau)
Need the database network-reachable or a gateway plus per-user licences — and they're for analysts, not staff who need an answer now.
Custom internal portal
A six-figure dev project before it answers a single question — most companies just don't build it, so the data stays trapped.
The agent way
Outbound-only agent + replica + web dashboard. Data-level access — scoped, read-only, mobile-friendly — without exposing the server at all.
Systems This Covers
Industries With Trapped Data
Same architecture, vertical-tuned — each industry's specific systems, compliance posture and reporting needs.
Construction & Contractors
Sage 300 CRE (Timberline), Viewpoint Vista, ProContractor, Jonas — job costing & accounting
Job costing, AP/AR, certified payroll, equipment and contract records live in a construction ERP on the office server — reachable only from the back office. A small agent gives PMs, estimators and owners a live, read-only dashboard from the job site or the office.
Explore Construction & ContractorsDental Practices
Dentrix, Eaglesoft, SoftDent, Open Dental — practice management records
Your patient records, schedules, ledgers and treatment history live in a practice management system on the office server — reachable only from the front desk. A small agent on that server gives dentists, DSOs and accountants a live, read-only dashboard from anywhere.
Explore Dental PracticesDentrix
Henry Schein One practice management — on-prem G6/G7 and Enterprise installs
Dentrix keeps production numbers, ledgers, schedules and treatment history on the office server — reachable only at the front desk. A small agent beside the Dentrix install surfaces a live, read-only web dashboard: the numbers you normally call the practice for, on any browser.
Explore DentrixERPNext (Self-Hosted)
ERPNext & Frappe on-premise — MariaDB-backed installs
Your accounting, stock, HR and manufacturing data lives in a self-hosted ERPNext install — reachable only through the Frappe UI on your network or via remote access. A small agent reads the MariaDB layer directly and gives your team a live, read-only web dashboard — without migrating to Frappe Cloud or re-platforming.
Explore ERPNext (Self-Hosted)Hotels & Hospitality
Opera on-prem, Fidelio, Protel, roomMaster — reservations, folios & night audit
Reservations, folios, housekeeping status and night-audit records live in a property management system on the back-office server — reachable only from the front desk. A small agent gives owners, GMs and multi-property groups a live, read-only dashboard from anywhere.
Explore Hotels & HospitalityLaw Firms
Tabs3, PCLaw, TimeSlips, Practice Master — billing & trust accounting records
Your billing, trust accounting, matter history and time records live in practice management software on the office server — the system partners can only see from their desk. A small agent gives fee-earners, finance and compliance a live, read-only dashboard without touching production.
Explore Law FirmsOdoo (Self-Hosted)
Odoo Community & on-premise Enterprise — PostgreSQL-backed installs
Your sales, inventory, accounting and manufacturing data lives in a self-hosted Odoo install — reachable only through the Odoo UI on your network or via remote access. A small agent reads the PostgreSQL layer directly and gives your team a live, read-only web dashboard — without migrating to Odoo Online or buying extra licences.
Explore Odoo (Self-Hosted)Optometry Practices
Compulink, OfficeMate, Crystal PM — patient & optical inventory records
Patient records, frames inventory, insurance billing and exam history live in a practice management system on the office server — reachable only from the practice. A small agent gives optometrists, managers and buying groups a live, read-only dashboard from anywhere.
Explore Optometry PracticesIndependent Pharmacies
PioneerRx, Liberty, QS/1, Rx30 — dispensing & claims records
Dispensing records, inventory, third-party claims and controlled-drug logs live in a pharmacy system on the store server — reachable only from behind the counter. A small agent gives owners, PICs and multi-store groups a live, read-only dashboard from anywhere.
Explore Independent PharmaciesSage Users
Sage 50 Accounts, Sage Payroll, Sage 200, Sage One archives
Your ledgers, payroll records, invoices and VAT history live in Sage on the office PC or server — reachable only from that machine or via remote desktop. A small agent reads the data directly and gives your team, accountants and auditors a live, read-only web dashboard — no VPN, no forced move to Sage Cloud.
Explore Sage UsersSAP Business One
SAP B1 on-premise — SQL Server & HANA installs, ~70K SMBs worldwide
Your financials, inventory, sales and production data live in an SAP Business One install on your own server — reachable only through the thick client or remote desktop. A small agent reads the SQL Server or HANA layer directly and gives your team a live, read-only web dashboard — no S/4HANA migration required.
Explore SAP Business OneTally Users
Tally ERP 9 & Tally Prime — ledgers, vouchers, GST & stock records
Your ledgers, vouchers, GST returns and stock records live in Tally on the office PC — reachable only from that machine or via workarounds like Tally.NET or remote desktop. A small agent reads the data directly and gives owners, CAs and auditors a live, read-only web dashboard — from anywhere, on any device.
Explore Tally UsersVeterinary Practices
AVImark, Cornerstone, Impromed — patient & billing records
Patient histories, invoices, inventory and lab results live in a practice management system on the clinic server — reachable only from the practice. A small agent gives vets, managers and corporate groups a live, read-only dashboard from anywhere.
Explore Veterinary PracticesQuickBooks
Desktop, Mac & multi-company access — the flagship vertical
Hosted-QuickBooks alternative: a local agent puts Pro, Premier and Enterprise company files in a read-only web dashboard — no RDP, no migration.
Explore QuickBooks AccessLegacy Data Access FAQ
Does the legacy system stay in place?+
Yes — the agent lives beside it, not instead of it. The app keeps doing its job; the agent just makes its data reachable. No migration, no disruption.
Is this safe for production systems?+
Safer than VPN access — the dashboard is read-only and scoped, so staff get data not network access. Queries hit the replica, not the live system, so your 2004 box doesn't absorb the load.
What if the vendor is gone or the software is abandoned?+
That's exactly the case this is built for. The replica extracts the data before the emergency — vendor shutdown, end-of-life, machine death — so the answer to 'where did it go' is 'it's already copied.'
What systems can it read?+
Anything with readable storage — SQL Server, MySQL, Access files, proprietary formats with documented structures, file shares. If it can be read, it can be surfaced; adapters are per-system config, not a rebuild.
What if the person who knows the system has already left?+
Then it's a reverse-engineering exercise, and it's usually still doable. We reconstruct the schema, identify the live tables and columns, recover query and report definitions, and document what we find as we build the replica. The dashboard that comes out of it is often the first time anyone has been able to ask the data a question in years.
Does this help with succession planning, audit or insurance?+
That's increasingly why clients buy it. The replica and its documentation are exactly what an auditor, an insurer or an acquirer wants to see: the records are producible, the knowledge is written down, and the bus factor is no longer one. It converts a personal dependency into a company asset.
Stop Calling Dave
If the answer to a business question lives on a server nobody can reach, that's a fixable problem. Show us the system — we'll show you the dashboard.