ModernisationReplace Informix 4GL, Oracle Forms, Delphi, PowerBuilder or custom J2EE on Airtool — schema-first, incremental cut-over, business runs through migration.Read the methodology
Modernisation

From legacy enterprise stacks to a metadata-driven runtime — without losing the business logic that runs the company.

Schema-first. Database business logic preserved. Metadata-generated UI. Three decades of enterprise database depth — and the same engineering team from assessment through cut-over to ongoing operations.

Schema-first

The legacy schema is the input, not the output. We import it. We do not re-model it. The reference data model continues to be the reference data model.

Database business logic preserved

SPL, triggers, stored procedures stay where they are. We modernise them in place. Translation to imperative Java is where institutional knowledge dies. We don't translate.

Metadata-generated UI

Roughly ninety per cent of the application surface — screens, endpoints, roles, reports — is generated from rows in a Dictionary database. The UI is not coded; it is materialised.

DBA + business analyst, not full-stack team

The customer-side team that delivers a modernisation on Airtool is a database engineer and a business analyst. The full-stack developer scarcity that kills most modernisations is not on our critical path.

Five layers, in the order they happen

A modernisation methodology is only as honest as the order in which it does the work. Ours runs from data outward.

1 · Schema

Already exists in the legacy system. Imported as-is into the dictionary's table-object catalogue. Cross-database type mappings are applied automatically. Foreign keys, constraints, indexes, full-text indexes and seed data are reified as rows the platform can recompile against any of the seven supported OLTP engines.

2 · Database business logic

SPL, triggers, stored procedures and user-defined functions stay in the database tier. The schema-code processor sequences them — CUDR → XUDF → XUDP → PROC → TRIG — with cross-include resolution and per-object timestamp tracking. Modernised in place: same logic, current syntax, current performance, current observability.

3 · Metadata

Tables, screens, REST endpoints, roles, reports, OLAP cubes and validation rules are stored as rows in a Dictionary database. The runtime materialises the application from these rows on demand. Cluster-wide cache invalidation propagates changes in milliseconds via Redis pub/sub.

4 · Batch and middle tier

Server-side JavaScript on a GraalVM Polyglot context, with the platform's standard library — more than forty namespaces covering database access, HTTP, cryptography, cloud APIs, AI / LLM, document generation, image processing, OCR, mail and more. Used only where metadata cannot express the rule. Batch, scheduled, integration, file-handling and AI workloads land here.

5 · UI

Generated from metadata. Vue 3.5, Vuetify 4, TypeScript 5.8, Vite 6 on the browser. Same authoring effort regardless of the application — ERP screen, OLAP dashboard or partner portal — same long-term maintenance cost. Zero hand-written form code, zero hand-written grid code, zero per-screen development.

What your modernised application will look like.

Airtool Apps — our own enterprise application suite — runs on the same platform the modernised version of your legacy stack will run on. Same metadata-generated UI, same supervised runtime, same OLTP and OLAP portability, same AI and MCP perimeter, same observability surface. Apps is the picture of what a finished modernisation looks like in production.

The implication for budgeting and planning is concrete : every platform-core capability — multi-tenancy, audit trail, row and column security, AI inside the perimeter, real-time observability — is inherited automatically by every form, every report, every module. Modernisation isn't translating your legacy stack into custom application code with these features rebuilt; it is lifting your schema and database business logic onto a runtime that already provides them.

Why this order matters

Most modernisations get this exactly backwards. They start with the UI because the UI is what the customer can see. They build the screens first, then realise the business rules behind the screens have to come from somewhere. They translate the rules into application code, and translation is where institutional knowledge is lost.

Our order is the order in which value compounds. The schema is the least negotiable layer — we import it. The database logic is the most expensive to lose — we preserve it. Metadata is the highest-leverage layer — we author it once and the platform reuses it. The middle tier is the smallest deliberate surface area we can get away with. The UI is generated, so it costs nothing per screen.

Source stacks we modernise

Each stack will get its own dedicated landing page with the technical port-mapping detail. Talk to us about anything not on this list — most enterprise database systems map onto our methodology.

Informix 4GL & Genero

From the Informix mainframes that still process billions of transactions a year. Schema imports natively. SPL ports as SPL. CDC and data-blade capabilities preserved on Informix; or migrated cleanly to PostgreSQL or SAP HANA where the workload demands.

Oracle Forms / Forms 6i

Replace the Forms client tier without rewriting the application. PL/SQL stays. Triggers stay. The screens become metadata. Roles, security models and integration contracts migrate cleanly. Optionally, the Oracle database stays — the application just stops being a Forms application.

Delphi

Two-tier client/server estates with thick-client business logic. We extract the rules, normalise them, move them to the database tier where they belong, and rebuild the UI on metadata. The tier model changes; the data model doesn't.

PowerBuilder

DataWindows, PowerScript, decades of accreted application surface. Ports the data model first, the rules second, the screens last — every step independently demonstrable, every step gated by the customer.

Custom legacy J2EE

Bespoke Spring / EJB / Struts applications that have outlived their architects. We replace the framework with the platform; you keep the SQL, the integration contracts and the audit history.

Custom ERPs and bespoke 'internal SAP' rewrites

The most expensive modernisations and the most rewarding. Decades of business knowledge encoded in proprietary systems — preserved in the database tier, exposed by metadata-generated UI, governed by the platform's audit and AI surfaces.

Why the platform makes it possible

The methodology is not separable from the platform. Every layer depends on a specific Airtool capability that does not exist in generic application servers or visual-builder frameworks.

The schema importer depends on the dictionary's multi-engine portability and its declarative table-object model. Database business-logic preservation depends on the schema compiler's SPL/trigger sequencing and per-object timestamp tracking. Metadata depends on the runtime's Redis-coordinated cluster cache and the supervised execution model. The middle tier depends on GraalVM Polyglot's controlled execution policies and the platform's standard library. The generated UI depends on the metadata model itself.

We do not sell modernisation as a service that happens to use a platform. We sell modernisation as the natural consequence of the platform's architecture — applied by the engineers who wrote that architecture.

Database flexibility — OLTP and OLAP

Seven OLTP engines for the modernised application; three OLAP engines for analytical workloads. Pick what fits — we do not lock the choice at the start of the programme.

OLTP · PostgreSQL

The default modern target. Open, deeply tested with the platform, full Tier-1 DBA depth from our team. Logical replication and CDC streaming to the analytical tier (Vertica, ClickHouse). First-line recommendation for greenfield modernisations and most lift-with-replatform programmes.

OLTP · Informix

Where the legacy estate is already on Informix and the operations depth justifies staying. We are the deepest Informix shop in our market — full Tier-1 DBA, CDC streaming, data blades, Java extensions. The migration becomes a modernisation of the application tier with the database tier preserved.

OLTP · Oracle · DB2 · SQL Server · MySQL · SAP HANA

Supported as application targets where the customer's existing estate or licensing landscape requires. Tier-2 development depth on these (full application engineering; DBA-grade operations referred to vendor or partner) — see the Database engineering service line for the honest competence map.

OLAP · Vertica · ClickHouse · BigQuery

Native SQL generation against the customer's chosen analytical engine — not generic SQL the engine then has to translate. Analytical workloads route automatically through the platform's data-access layer; the application sees one query surface.

What changes for the engineering team

A typical modernisation programmeAn Airtool modernisation
Team profileFull-stack developers, scarce, expensive✓ Database engineer + business analyst (customer side); platform team (us)
Schema strategyRe-modelled, not imported✓ Imported as-is into the dictionary
Database business logicTranslated into Java imperative code✓ Preserved in the database tier, modernised in place
UI strategyHand-coded per screen✓ Generated from metadata, zero per-screen cost
Cut-overBig-bang at the end of a 24–36 month project✓ Incremental, parallel-run, business runs through migration
Database choiceLocked at the start✓ Switchable on the same platform; seven OLTP engines plus three OLAP
AI integration after go-liveSeparate project, separate vendor✓ In scope by default — MCP server, RAG, governed SQL agents

Talk to an architect about the migration plan.

Discovery call within 48 hours. Architecture review within four weeks. Pilot within one quarter.