Migrate From Spreadsheets and ERP

From Spreadsheets and ERP-only master data to Lima master data

Most enterprises run master data on ERP screens and spreadsheets: the ERP validates its own fields, the spreadsheet holds the mappings, hierarchies and the list of who owns what, and a second ERP or a CRM brings a second copy.

Inventorymodel · rules · historyMapentities → domainsLoad historyevery version and mergeRun side by sidesame answers, comparedCut overconsumers read golden viewhistory comes with the records: every version and every merge decision, with its date and its persona fixed price for the first domain, written before the work starts
The five steps from Spreadsheets and ERP. History comes with the records.
5
things to inventory
method
6
concepts mapped
method
1 week
free inventory
offer
4 weeks
first domain to production, per the first-domain plan
estimate
What to inventory

The list the free week produces

How the concepts map

Spreadsheets and ERP on the left, Lima on the right

Spreadsheets and ERPLima master data
Mapping spreadsheetcross-reference, generated from the match
Hierarchy spreadsheetversioned hierarchy
Code-list spreadsheetreference-data domain with crosswalks
Owner liststeward assignment and security
Duplicate check by eyematch rules with two thresholds and a queue
E-mail approvalsproposals and, where levels are needed, a SmartApp
The five steps

InventoryOne week, free: the list above, with owners and consumers.
What to watch

Three things that need care on this path

An illustrative move

Anonymised pattern

A distributor with SAP and Salesforce and 23 spreadsheets ran the first domain in a day: customers from both systems, 6,100 duplicate pairs found, the mapping spreadsheet retired the same week. The hierarchy spreadsheet became a versioned sales hierarchy in week two; the code lists followed.

anonymised pattern · confirm before naming
The trigger, sourced

  1. Gartner press release: lack of AI-ready data puts AI projects at risk, Feb 26 2025 — https://www.gartner.com/en/newsroom/press-releases/2025-02-26-lack-of-ai-ready-data-puts-ai-projects-at-risk
Questions

What happens to the consumers of the old hub?

They move behind a router one at a time: SOAP consumers get a generated WSDL, SQL readers get views with the same names, API consumers get REST with the same shapes.

Can we keep the old hub for reference?

Yes, read-only, for as long as your retention policy needs; its history is already searchable in Lima.

What is the fixed price based on?

The inventory: the count of domains, sources, rules, hierarchies and consumers, written before the work starts.

See your first domain built on your data

Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.