NEC Housing tools

The tools we built to survive NEC Housing, free for yours.

NEC Housing runs to well over a thousand tables, joins that were never declared as foreign keys, and reference codes that mean different things in different domains. These are the four tools we use to work in it every day: a schema wiki and join-path finder, a 3D explorer, curated guides, and a Business Objects extractor. Free to use, behind a sign-in that protects the mined join data.

Schema Wiki & join-path finder

Find the join NEC never shows you.

NEC Housing has well over a thousand tables, and the joins you actually report on are rarely declared foreign keys. Search every HOU and FSC table, read the real relationships including the inferred ones, then point at any two tables and get the SQL for the route between them. The verbatim NEC column descriptions sit next to each field, so you stop guessing what a column holds.

Search 1,577 live NEC Housing tables, with system and empty tables already stripped out.
See declared and trusted joins, including the ones with no foreign key behind them.
Generate the shortest SQL join path between any two tables, with waypoints when you need them.

Open the Wiki

3D Explorer

The whole schema, as one map you can move through.

A table list tells you what exists. It does not tell you how the schema hangs together. The Explorer renders the entire NEC join graph in 3D: grab and drag nodes, search for a table and fly to it, click one to light up its neighbourhood, then route from one table to another and read the SQL inline.

The full NEC join graph as an interactive 3D force-graph.
Search, focus and drag to see how the spine tables cluster.
Route from one table to another and see the path lit in 3D, with the SQL alongside.

Open the Explorer

Guides

The knowledge that usually walks out the door.

The person who knows how your housing data really fits together is one resignation away from taking it with them. Our guides write that knowledge down: how repairs, voids, tenancies and properties actually flow through NEC, the gotchas that quietly drop rows, and the joins that hold up to audit. Curated, authoritative, and kept in the building.

Plain-English walkthroughs of the work orders, tenancies and properties spines.
The status codes, reference values and join gotchas that skew the numbers.
Written by practitioners who report on this schema, not a vendor manual.

Open the Guides

Business Objects extractor

Get your reporting logic out of Business Objects.

Years of refined report logic sit locked inside SAP BusinessObjects .rep and .wid files. Migrating off the platform should not mean rebuilding it from memory. Drop a file in and the extractor pulls the SQL and query objects straight out, in your browser, so nothing leaves your machine. Optional Claude clean-up turns the raw output into readable, portable SQL.

Reads .rep and .wid files entirely in the browser: no upload, nothing stored.
Pulls out the SQL and query objects behind each report.
Optional AI clean-up for SQL you can take straight into Power BI.

Open the extractor

Members area

Sign up free and put the tools to work.

Create your account with Google or Microsoft. New members are approved by us, so the mined join data stays with people who work in the sector, and there is no charge, now or later. Prefer to talk first? Book a conversation.