PowerBuilder

PowerBuilder modernization, with the DataWindows understood.

PowerBuilder built a generation of client/server business applications, and plenty of them still run companies today. We read the application, DataWindows and all, into a model and generate a modern web application from it, 90%+ automated, then prove the result behaves like the original.

Who this is for

A PowerBuilder application the business still depends on.

This is for teams whose PowerBuilder application works, but has become something they maintain around instead of improve.

  • A PowerBuilder line-of-business application that still runs part of the business every day.
  • The developers who built it are retiring, and new hires do not learn PowerBuilder or PowerScript.
  • The business logic lives inside DataWindows and embedded SQL, where no documentation ever reached.
  • Users want it on a browser or a tablet, and the Windows client cannot get there.
Why now

Why PowerBuilder, specifically.

PowerBuilder is not abandoned software. The pressure comes from somewhere else.

The product is supported, the talent pool is not

Appeon has kept PowerBuilder moving since taking it over from SAP in 2016, so this is not a countdown to an end-of-support date. The constraint is people. PowerScript and DataWindow experience sits with developers who are near retirement, and nobody is learning it on the way in.

The DataWindow is the asset and the problem

The DataWindow is why PowerBuilder applications were built so fast, and it is why they are hard to leave. Retrieval, validation, computed fields and update logic are bound together inside it. A hand rewrite has to find all of that and work it out again, screen by screen.

Client/server is the wrong shape now

A Windows client talking straight to the database was the right architecture in 1998. It makes remote access, mobile use, API integration and modern security review harder than they need to be, and every one of those is now a standing requirement.

Staying current is its own project

Keeping a large PowerBuilder application on a current release, a current compiler and a supported database driver is recurring work with no visible benefit to the business. That budget buys nothing except the right to stand still.

Your options

Four ways to deal with a PowerBuilder application.

Two questions decide most of it: how much undocumented logic sits in the DataWindows, and do you need this in a browser?

  1. Stay and upgrade

    Keep the application on current PowerBuilder releases. Reasonable as a bridge, and it does nothing about hiring.

  2. Rewrite by hand

    Works on a small application. On a large one, every DataWindow has to be reverse-engineered before a line of replacement code is correct.

  3. Rebuild as a web app

    Worth it when the business process itself is changing. Highest effort, and you take on the full risk of rebuilding the business logic.

  4. Automated conversion

    Read the real PowerBuilder source and generate a modern equivalent. Usually the lowest-risk route for a large application you need to keep running.

How we do it

Read it, model it, generate from the model.

A hand rewrite works your business rules out again from documentation and memory, which is where undocumented behavior gets lost. We carry them across from the real source instead.

01

Map the whole codebase

Code Analyzer reads every line of the PowerBuilder source: every window, DataWindow, user object and PowerScript function, along with the data access and the business rules buried inside them. From that we build a model of how the application actually behaves. Gaps are surfaced, not guessed.

02

Generate from the model

Code Transformer maps the model onto a modern architecture and generates a modern web application, 90%+ automated. Generating from the model gives you an application built the way someone would build it today, instead of old workarounds in a new language. Our engineers handle the custom pieces no automated conversion can reach, with AI assistance, and check the result against your original system.

03

Prove it matches

Side-by-side testing runs the new system and the old one on the same inputs and compares what comes out. The business rules held in the model give a second, separate check that does not rely on the tests alone. Automated test coverage is built alongside the transformation.

Manufacturing

Twenty years in production, moved to the web in half the time.

A manufacturing company had run its PowerBuilder system for more than 20 years. Documentation was incomplete and the engineers who knew it best were retiring, so maintaining it was getting riskier every year.

Automated analysis recovered accurate documentation from the source code, and the application was transformed into a standard web application. The migration took half the usual time, and ongoing maintenance costs dropped 40%.

What you get

A modern application you own outright.

Standard, conventional code

TypeScript and React by default, or Vue and similar frameworks where your standards call for it. Readable by any web developer you hire.

No proprietary runtime

There is no Vivify runtime under your application and no license you must keep paying to run your own software.

Code your team owns

You can host it, maintain it, and extend it yourselves, with no dependency on us to keep it running.

Responsive on any device

A web application that works across desktop, tablet, and mobile instead of a Windows-only install.

A track record across major enterprises

PowerBuilder

Common questions.

Is PowerBuilder still supported?

Yes. Appeon acquired PowerBuilder from SAP in 2016 and continues to release new versions. Support is not the reason to move. The reasons are hiring, the client/server architecture, and the cost of keeping a large application current.

What happens to our DataWindows?

They are read, not redrawn. Code Analyzer reads the DataWindow definitions along with the rest of the source: the retrieval, the computed fields, the validation and the update logic. That behavior goes into the model and is generated into the new application, instead of being worked out again by hand.

How much of a PowerBuilder application can be converted automatically?

In our projects, conversions from stacks like PowerBuilder, VB6, and Nexaweb run at 90%+ automation. The remainder, the custom pieces no automated conversion can handle, is done by our engineers with AI assistance and checked against the original system.

Do we have to move the database too?

Not necessarily. The application can keep talking to the same database. We also convert database code in its own right, including Oracle PL/SQL to PostgreSQL, if a platform move is part of the plan.

How do we know the new application behaves like the old one?

Business rules move across through a model built from your real code, rather than being re-typed by hand. We then check the result two ways: side-by-side testing on the same inputs, and the business rules held in the model as a separate check.

Where does a PowerBuilder modernization project start?

Usually with the free assessment: a complete dependency map, risk scoring, an effort model and a costed migration plan, produced from your own source code. If you would rather see output first, we can run a paid proof of concept on a representative slice of your application.

Find out what your PowerBuilder application contains, and what it will take to move it.

The assessment is free and built from your own source code. If you would rather see output first, we can run a paid proof of concept on a representative slice of the application.