Modernize Your Legacy BI
Escape a high-cost legacy BI platform, avoid the cloud trap of shipping your data out just to get charts back, and find a path off a product that is going end of life — with a per-vendor migration guide for each major BI platform.
Most people arrive here for one of three reasons. The licence has become indefensible, the platform wants your data in its cloud, or the version you run is quietly going out of support. Often all three at once.
Table of Contents
- Escape a High-Cost Legacy Platform
- Escape the Cloud Trap
- Your Platform Is Going End of Life
- Migration Guides by Vendor
- What Moving Actually Looks Like
Escape a High-Cost Legacy Platform
Legacy BI is priced as though information should be rationed. Per seat, per core, per processor, per gigabyte — the meter runs on your audience, your hardware, or your data, and it runs forever.
The tell is when somebody in your organisation starts deciding who does not get access to a number because of what the next licence costs. That is the opposite of what the platform was bought to do.
DataPallas is open source and self-hosted, with fair commercial pricing that runs the other way round. It is built around the people who build and administer the reports rather than the people who read them: no per-viewer licence, no core count, no capacity tier, no charge by the gigabyte. Viewers are not a licensed tier at all, so a report that becomes popular does not become expensive and nobody has to ration a number to protect a budget.
Escape the Cloud Trap
You already have a database. It holds every number anyone will ask about, it is backed up, secured, audited, and running on hardware you control.
The modern answer to that is: copy it into our cloud on a schedule, and we will send you pictures of it back. Written down, it stops sounding reasonable — and it is why you end up maintaining an extract, a gateway or bridge, a refresh timetable, a semantic model hosted elsewhere, and a bill that grows with every new viewer.
Put the contradiction side by side and it is hard to unsee. Your CEO says the company's data is its most valuable asset — and means it. Meanwhile that same asset is copied out of the building every few hours onto servers the company does not own, often in another country under another jurisdiction's laws, and what comes back in exchange is a handful of dashboards. You pay a monthly bill for the round trip, and the bill goes up each time somebody new wants to look at a chart.
Nobody would approve that arrangement if it were put to them in those words. It gets approved because it arrives described as a BI platform.
DataPallas installs next to your database and queries it in place. Nothing is extracted to a third party, so there is no gateway to patch, no refresh window where the numbers are stale, and no conversation with your compliance team about where customer records are processed. Under GDPR, HIPAA, financial regulation, or data-residency rules, "the data never left" is a much shorter security review.
Your Platform Is Going End of Life
Every vendor has its own phrase for it — discontinued, end of mainstream maintenance, sustaining support, withdrawn from support, terminal release, no new versions. They all mean the same thing: what you depend on is no longer going anywhere.
Sometimes the date is explicit. Sometimes the product still ships and the signal is quieter: components removed between releases, the free tier withdrawn, the licence rewritten, investment visibly moving somewhere else. Either way, the reports keep working and the ground keeps shifting.
Lifecycle dates move. Every guide below states where a product stood when it was written and names the vendor's own terminology, so you can check your own position against the vendor's published policy rather than taking a blog's word for it.
Migration Guides by Vendor
One guide per platform — where it actually stands, what it costs, what you keep, and how to move one piece at a time instead of switching everything over in a single go.
- Crystal Reports — CR 2016 is already past support and CR 2020 reaches End of Mainstream Maintenance on 31 December 2026, on a platform where
.rptfiles still cannot be version-controlled. - Power BI — a good product whose architecture copies your data into Microsoft's cloud and charges per person who looks at it, with the on-premises edition documented by Microsoft as a subset.
- Tableau — superb at visualisation and priced accordingly, with Salesforce having raised on-premises list prices by up to 33% specifically to remove the saving from self-hosting.
- SQL Server Reporting Services (SSRS) — SSRS 2022 is the last version there will ever be, and Microsoft's replacement is a separate product, Power BI Report Server, which needs a SQL Server 2025 licence or active Software Assurance.
- JasperReports — the Community Server was discontinued on 25 January 2024 and the downloads pulled — your existing
.jrxmltemplates run in DataPallas unchanged. - SAP BusinessObjects — BI 4.3 reaches End of Mainstream Maintenance on 31 December 2026, in a suite that has already deleted Desktop Intelligence, Xcelsius, and Explorer.
- IBM Cognos — 11.2.x was withdrawn from support on 30 April 2026, and upgrading to Cognos 12 means rebuilding every Query Studio, Analysis Studio, and Workspace asset because they were removed outright.
- SSAS & SSIS — still supported, but the feature work has moved to Fabric, and SSRS has already shown how that story finishes.
- Oracle Reports & OBIEE — Oracle Reports is desupported and OBIEE 12c sits in Sustaining Support with no security patches for new vulnerabilities, while the supported path forward runs to $221,250 per processor.
- Qlik Sense & QlikView — capacity pricing since March 2025 means you are billed for gigabytes loaded rather than people reading, and self-hosting is no longer even a listed plan.
- Pentaho — Community Edition was Apache 2.0 through 9.5 and moved to the Business Source License at 10.2, turning a settled question into a legal one.
- MicroStrategy — per-user licences run $600 to $5,000 under one of the most complicated licensing schemes in BI, from a vendor that renamed itself Strategy Inc. in August 2025.
Not on the list? The full comparison index covers every major BI and reporting platform side by side.
What Moving Actually Looks Like
None of these guides ask for a big-bang migration, because none of them need one.
The first phase is almost always distribution. DataPallas will burst and deliver documents produced by any tool, so your existing platform keeps generating exactly as it does today while DataPallas takes over splitting output by recipient, scheduling it, and delivering it. That moves a genuine production workload off the legacy licence within a week, with nothing rewritten and nothing to unwind.
The second phase is the reports themselves — worst one first, at a pace you set. Templates are HTML and CSS rather than a proprietary binary, and the Hey AI, Help Me… button will write the first draft from your existing query. Whatever you configure through the UI is saved as plain text, so your reporting finally lives in version control alongside the rest of your code.