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
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.
Everything about a customer in one place
Look up any customer and see their balance, history and documents without paging through character screens.
Invoices and statements on demand
Find any invoice or credit note, and pick the customers who should receive a PDF statement by email.
Who owes what, and who to watch
Aged debtors, a credit watch list and customers who have stopped ordering.
Sales analysis you can filter
Sales analysis and sales by user, filtered on screen and exportable to Excel.
Cash flow and VAT
A finance overview with a cash-flow forecast, and VAT return figures ready to check and export.
Stock valuation and purchasing
What is in stock, what it is worth, and what needs ordering.
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.
-
Your SCO system
The application and its database, exactly as they are today.
live queries -
A locked-down service
A small service on your own network that answers the portal and nothing else.
private encrypted tunnel -
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
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.
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.
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