Capabilities Federated display

Read the systems, warehouses and lakes where they are, by the level of authorisation.

Lima's query engine reads SAP, Oracle, Salesforce, Workday, ServiceNow, Snowflake, Databricks and Fabric in place.

SAP S/4HANAreleased read interfacesOracle FusionREST · BICC · JDBCSalesforcesObjects APISnowflakewarehouseDatabricksUnity CatalogServiceNow · Workdaytables · web servicessource permission, as the readerthe source returns only what this person may seeLIMA FEDERATED ENGINEone plan across all sourcespushes filters and aggregates downjoins on the golden cross-referenceapplies the 12 platform layerscaches where latency needs it, labelledlogs every readgrids · pivots · APIs · SQL · agentseverything reads through the same engine
One plan across the sources. The source returns only what this person may see; the platform applies its own layers on top; every read is logged.
7
systems read in place
connector library
2.1 s
for a query joining four systems on the showcase estate
showcase
1
governed replica per slow source, in your lake
product
100%
of reads logged with the policy that allowed them
product
Step by step

What happens when a grid asks for the open orders of a golden supplier

The request names golden idsThe grid asks for open purchase orders for golden supplier L-00731 with five columns and a date filter.
Live, cached or replicated

Three freshness contracts, chosen per source and labelled per column

ContractWhen to use itWhat the reader sees
Livethe source answers in seconds and allows the load: ERP tables through released interfaces, lakes, most applicationsthe source's current rows; 'live' on the column
Cachedthe source is slow or rate-limited but the rows change rarely: reference lists, hierarchiesrows cached for a stated number of minutes; 'cached 15 min' on the column
Governed replicathe source is too slow or too limited to query live at the needed scale or history: mainframes, SaaS APIs with tight limits, years of historyrows from the replica the Backbone keeps in your lake; 'replica · certified batch 412' on the column

A replica is one copy, in your lake, under the same keys, security and audit as everything else. The Backbone keeps it current and reports the difference between source and replica.

Authorisation, passed through

The source decides first; the platform decides second

Lima reads a source under the person's own identity where the source supports it (single sign-on, impersonation, delegated tokens), and under an integration user with the person recorded in the log elsewhere. In the first case the source itself limits the rows; in the second the platform applies the same limits from the mapped roles.

The twelve platform layers then apply: tenant, domain, table, hierarchy branch, row filter, column read, column write, column delete, cell mask, purpose and time window. The security page lists them in order.

01Identity and SSO02Tenant03Source authorisation passed through04Domain05Table or entity06Hierarchy branch07Row filter08Column (read)09Column (write)10Column (delete)11Cell mask12Purpose and time windowevaluated top to bottom; the first refusal winsWHAT A STEWARD SEESlegal nameread · writeVAT IDreadbank account•••• 4471credit limithiddenpayment termsread · writeowner (person)readdelete recordrefusedthe reason for every refusal is logged
The layers evaluated top to bottom; the first refusal wins; every refusal is logged with its reason.
Terms on this page

Federated readA query that reads a source where it is, with the reader's own permission checked by the source.
PushdownSending filters, sorts and aggregates to the source so only the needed rows travel.
Governed replicaA copy kept in your lake for a source that is too slow or too limited to query live, under the same keys, security and audit.
Freshness contractThe stated rule for how current a column is: live, cached for a number of minutes, or replica with its batch.
Questions

Does federated reading load the ERP?

Filters and aggregates are pushed down, reads use released interfaces, and the connector respects the extraction caps agreed with the basis team. The Backbone's scale page lists the caps per system.

What about sources with no live interface?

They get a governed replica in your lake, refreshed by the Backbone, and the column says so.

Can BI tools read the same way?

Yes, through SQL (JDBC and ODBC) with the same policy, so a dashboard sees what the grid sees.

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.