Solutions Archiving and cold-data offload

Cold data out. Answers still in.

Move closed periods and cold history out of HANA and ECC into lower-cost storage tiers with retention rules, and keep every row answerable through the fabric. Databases get smaller, licence and hardware bills follow, batch runs get faster, and audit access works the way it always did.

Complete business documents move together, so a purchase order and its items, history and texts stay consistent wherever they live.
HOT · HANA / ECCcurrent + last two fiscal periodsMEMORY-PRICEDWARM · lakehouse tablesyears 1–7 · Parquet · fabric reads liveOBJECT STORAGE, COLUMNARCOLD · archive storageyear 7+ · legal hold · restore on demandCENTS PER GB-MONTHOFFLOAD POLICY: CLOSED PERIODS, COMPLETED DOCUMENTS, AGEcomplete documents move together · counts proved on both sides · removal from source through SAP archiving objectsONE QUESTION · READ ACROSS ALL THREE TIERS · 0 BYTES MOVEDSMALLER HANA FOOTPRINT · FASTER BATCH RUNS · SMALLER S/4HANA TARGET · AUDIT ACCESS UNCHANGED
Hot data stays where the ERP needs it. Warm and cold history move to tiers priced for what they are, and one question still reads across all three.
80 GB/day
moved in production on the engine
~30 min
220M rows · 615 tables · ~30 GB on 64 vCPU
3 tiers
hot, warm and cold, chosen per table and period by retention class
0 bytes
moved to answer a question across tiers — the fabric reads in place
product
30–70%
smaller migration volumes reported when history is offloaded ahead of S/4HANA
retirement specialists · vendor-stated 2026
Dec 31, 2027
ECC maintenance end; HANA sizing for S/4HANA is decided before then
SAP
Why it pays

Memory-priced databases fill up with history

HANA is sized and priced by memory. Closed fiscal years, completed orders, delivered shipments and old change logs sit in that memory at the same price as this morning's transactions. Moving them to storage priced for history shrinks the database, speeds the nightly runs that scan it, and cuts the size of the S/4HANA system you migrate to.

A smaller HANA footprint

Closed periods and completed documents leave memory; the hot database holds what operations and planning use.

product
Faster batch runs

MRP, month-end and reporting jobs scan fewer rows because the history they never need is elsewhere.

product
A smaller S/4HANA target

Retirement specialists report 30–70% less data to migrate when history is offloaded first.

retirement specialists · vendor-stated 2026
Audit access unchanged

Auditors query the offloaded periods through the fabric with the same vocabulary and the same access policy.

product
How offload works

Policy, move, prove, remove

Set the offload policy what qualifiesClosed fiscal periods, completed and delivered documents, records past an age threshold. Policies are rules in Lima with an owner; they run on a schedule.
Move complete documents together extractA document and its dependent tables move as a unit — header, items, history, texts, attachments — so the offloaded copy is consistent and readable on its own.
Prove the counts on both sides reconcileRecord counts and control totals per table and per period, compared between source and tier; variances become exceptions with owners.
Remove from the source through SAP's own archiving objects keep SAP consistentDeletion from ERP tables follows SAP's archiving objects and lifecycle rules, so the ERP stays consistent; Lima schedules the run and holds the evidence on both sides.
Keep it answerable serveThe fabric reads hot, warm and cold tiers in one query. ChatLima, dashboards and agents see the full history with the access policy applied.
Tiering

Three tiers, chosen by retention class

TierWhat lives thereStorageHow it is readCost signal
HotCurrent data plus the last two fiscal periodsHANA / ECCThe ERP itself; the fabric for questionsMemory-priced
WarmYears one to seven: consulted by finance, planning and auditLakehouse tables (Parquet) in Snowflake, Databricks, Fabric or S3The fabric, live, in the same query as hot dataObject storage, columnar
ColdYear seven onward, legal holds, records kept for statutory reasonsArchive-class object storageThe fabric on demand; restore into any target when neededCents per gigabyte-month
Relative cost signals only; your cloud provider's price list applies. Retention classes and tier assignments are rules you own.
Retention rules

Rules that run themselves

Retain for a period, then expire

Ten years for financial documents, seven for HR records, whatever your policy says — per table, per period, with an audit trail of every expiry.

Legal hold

A hold suspends expiry and erasure for the records it covers until it is lifted by the person who set it.

Erase on request

GDPR erasure runs against archived records with evidence attached; the 47-minute workflow from the showcase estate applies.

Restore on demand

Any dataset reloads into S/4HANA, a warehouse or a file target through the same engine, reconciled the same way.

Beside SAP ILM

Compliance status where it is mandated, usable history everywhere else

SAP's Information Lifecycle Management can hold the retention status auditors look for; Lima holds the same history in a form people can query. The two run side by side, fed by the same scheduled offload.

One rule for both

ILM for the compliance flag; Lima for everything that must stay usable. The same pattern serves a full system retirement when the ERP itself is switched off.

Lifecycle

Offload is scheduled extraction into tiers with counts proved; the fabric serves the result.

One engine underneath every page in this family. It reads from any source and writes to any target, runs batch loads or change-data streams, handles a nightly delta or a multi-terabyte migration, and is licensed by capacity, so the bill stays the same however many rows move. Lima's fabric answers questions on data in place; Lima Backbone moves, transforms and returns data on a deadline. When to federate and when to pipeline · The Backbone hub.

Terms on this page

Plain definitions

OffloadMoving data that operations rarely touch out of the expensive database into cheaper storage, while keeping it readable.
TierA class of storage with its own cost and speed; hot for the ERP, warm for the lakehouse, cold for archive storage.
Archiving objectSAP's own definition of which tables make up a business document and how it may be removed from the database consistently.
Closed periodA fiscal period that finance has closed; its documents change no more and qualify for offload.
Retention classThe rule that says how long a category of records is kept and on which tier.
FabricLima's query layer that reads data where it sits — ERP, lakehouse or archive — with one access policy.
Questions we hear

Asked before the first load.

Does offloaded data stay reportable?

Yes. The fabric reads hot, warm and cold tiers in one query, so dashboards, ChatLima and agents see the full history. Access policy applies to every tier the same way.

How do you keep documents consistent?

Complete business documents move together with their dependent tables, following SAP's archiving objects. A purchase order never ends up with its items on one tier and its header on another.

Who decides what moves?

Your offload policy: closed periods, completed documents, age thresholds. It is a rule with an owner, and it runs on a schedule with an audit trail.

What does it cost to keep the cold tier?

Archive-class object storage from your cloud provider, at its published rate. Lima's subscription is sized by capacity and includes the scheduled offload runs.

Can we bring a period back?

Restore reloads any dataset into the ERP, a warehouse or a file target, reconciled the same way it was offloaded.

Is this the same as decommissioning?

Offload keeps the ERP running with less inside it. Decommissioning extracts everything and switches the system off. Both use the same engine and the same reconciliation.

Scope an offload

Policy in week one, first closed periods moved and proved in week three, retention rules running by week four.