Web portals and modern tooling

A modern web portal on top of your SCO system

The information held in your legacy system, in a browser: searchable, filterable and exportable, read live from the database. The application carries on underneath, untouched.

  • Live data, not an overnight copy
  • Secure login, with the SCO server never exposed to the internet
  • Built around the reports you already rely on

Ask about a portal

We reply by email. If a server is down, say so in the first line. You can also write to help@scoexpert.com.

What a portal can do

The pages our customers use every day

These are taken from a portal in daily use on an ERP running on SCO OpenServer. Yours would be built around your own system and the questions your staff ask of it.

Illustration with sample data. A portal page reading live from the legacy system.
Customers

Everything about a customer in one place

Look up any customer and see their balance, history and documents without paging through character screens.

Documents

Invoices and statements on demand

Find any invoice or credit note, and pick the customers who should receive a PDF statement by email.

Credit control

Who owes what, and who to watch

Aged debtors, a credit watch list and customers who have stopped ordering.

Sales

Sales analysis you can filter

Sales analysis and sales by user, filtered on screen and exportable to Excel.

Finance

Cash flow and VAT

A finance overview with a cash-flow forecast, and VAT return figures ready to check and export.

Stock

Stock valuation and purchasing

What is in stock, what it is worth, and what needs ordering.

How it connects

Modern on the outside, untouched underneath

The hard part of a portal on a legacy system is reaching the data safely. That is the part we have already solved.

  1. Your SCO system

    The application and its database, exactly as they are today.

  2. A locked-down service

    A small service on your own network that answers the portal and nothing else.

  3. The portal

    Staff sign in from any current browser. Nothing on the SCO server is exposed to the internet.

  • Live queries against the legacy database, through a modern ODBC driver we built for the purpose
  • A small, locked-down service on your network, reached only through a private encrypted tunnel
  • Secure sign-in, with roles that decide who sees which pages
  • Runs in any current browser, with nothing to install
  • Reports that filter on screen and export to Excel
Beyond portals

Other modern tooling we build on legacy systems

Management reporting

Ledger and sales data extracted on a schedule to a cloud database, for Power BI and management accounts.

Getting data in safely

Tools that load data into the legacy system from spreadsheets, such as bills of materials, with checks before anything is written.

Questions in plain English

An assistant that answers questions about live figures and drafts emails for you to review. It never sends anything itself.

Microsoft 365

Power Automate flows triggered by events on the legacy system, SharePoint libraries for documents and drawings, and Excel exports.

Read the case studies

Questions

Portal questions

Is the data live?

Yes. The portal queries the legacy database directly, so a figure on screen is the figure in the system at that moment. It is not an overnight copy.

Is it safe to connect an old server to a web portal?

The server is not put on the internet. The portal talks to a small, locked-down service on your network through a private encrypted tunnel, and people sign in before they see anything. Roles decide who can see which pages.

Does the application have to change?

No. The portal reads the data the application already holds. The application carries on exactly as before, and staff can use both side by side.

Who is the portal for?

The portals we have built are for a company’s own staff: directors, accounts and the office. If you want your customers or sales representatives to log in as well, tell us and we will scope it.

Which systems and databases can it work with?

The approach is the same every time, whatever the application: reach the data, build an API in front of it, and carry it to the web through a private encrypted tunnel. We have done this on several quite different legacy business systems. Tell us what you run, and we will start with a conversation about what is practical.

Can it replace our printed reports?

Usually, and the result is more useful. At one customer, reports that used to be printed as documents of 50 to 200 pages are now live in the portal, filterable and exportable to Excel.

Next step

Tell us what you wish the system could show you

The report you wait for at month end, the question that takes three screens to answer, the figures you retype into Excel. That is usually where a portal starts.

  • Built around your own system and reports
  • The application is not changed
  • Works alongside document management

Ask about a portal

We reply by email. If a server is down, say so in the first line. You can also write to help@scoexpert.com.