The trees that group products for sales, planning, sourcing and reporting, kept as versioned hierarchies with one leaf per golden item.
Objects are read through the Salesforce APIs (REST, Bulk, Change Data Capture); the rows stay in Salesforce.
| Object | Read from | Fields the domain uses | Freshness |
|---|---|---|---|
| Product family | Product2.Family (picklist) · custom hierarchy objects | Family · Hierarchy_Node__c | live; Change Data Capture where enabled |
| Price books | Pricebook2 | Name · IsActive | live; Change Data Capture where enabled |
The first object above carries the strong keys; the standardised attributes come from the same rows. A leaf can sit in several hierarchies at once; each hierarchy has its own version history.
Writes are upserts through the REST API on the external id; every call returns the record id or the error, and Lima logs both.
| Interface | Used for | Result |
|---|---|---|
picklist values through the Metadata API; hierarchy objects upserted | golden values approved for write-back: hierarchy nodes; leaf assignments; attributes by node | the id or error Salesforce returns, stored beside the change |
Write-back is off per object until a test write succeeds, and approval rules can require a person per object. Reconciliation compares the source row with the golden value on a schedule.
Salesforce profiles and sharing rules are mapped to Lima policies once; a user sees here what they see in Salesforce.
Product classification on
Other domains on Salesforce
The golden record reads the objects above in place. History the pivot needs at scale is landed in your lake by the Backbone, under the same keys, security and audit.
Grant the read access and the write interfaces listed above and agree the refresh method. Nothing is installed in Salesforce.
Yes. Write-back stays off per object until a test write succeeds; the golden view, the API and the pivots work from day one on reads.
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.