Compare Semarchy

Semarchy and Lima master data

Semarchy's Data Platform (formerly xDM, xDI and xDG) is an independent MDM whose hub lives in a customer-owned PostgreSQL, Oracle or SQL Server database, with SemQL for matching, rules and security, and a 30-day trial.

SEMARCHYyour systemscopy into Semarchymatch and steward therepublish to a warehouseconsumers read copiesLIMA MASTER DATAyour systemsread in placegolden viewgrids · pivots · APIs · agentswrite-back, confirmedthe dashed return is the acknowledged write-back to the system that owns the record
Where the rows live, in one picture. Semarchy's lane follows its own documentation; Lima's lane is the master-data design.
9
questions
method
19
numbered sources
dated source
September 17
checked
dated source
2
'when to choose' sections
method
The nine questions

Semarchy and Lima master data, side by side

Every Semarchy cell carries its source number; the sources are listed at the foot of the page.

QuestionSemarchyLima master data
Where the master data livesThe hub is a relational database you own, with source (SD), master (MD) and golden (GD) tables per entity; golden data can be read by SQL directly; a Snowflake Connected App keeps processing inside the Snowflake tenant with 'zero data egress' [1][2][3].Golden records are governed views over the sources, read in place through the federated engine, and materialised only where latency needs it, in your lake, under the same keys. The transactions sit in the same bed, so a merged customer and its orders change together.
Reaching SAP, Oracle and the lakesLoads arrive through a SQL API (load ids), REST and continuous loads; native SAP and Oracle read paths are unpublished; SaaS, Snowflake-native, self-hosted on AWS, Azure, GCP, on-premises and, since September 14, 2026, OpenShift and Rancher [1][4][5].SAP S/4HANA and ECC through released read interfaces and change capture; Oracle Fusion through REST and BI Cloud Connector extracts, E-Business Suite through JDBC and open interfaces; Snowflake, Databricks and Fabric read in place; Salesforce, ServiceNow and Workday through their APIs. Write-back through BAPIs, IDocs, REST and web services, acknowledged and logged.
Golden record: matching and survivorshipA certification process: enrich, validate, match with SemQL rules (fuzzy lookups since 2025.1), consolidate with strategies (custom ranking, longest, most frequent, preferred publisher), then publish and historise; source keys kept as PublisherID.SourceID [6][7][8].Strong keys first (VAT ID, DUNS, GTIN, manufacturer part number), then standardised attribute and address matching, with a language model for the hard pairs; two thresholds per rule (review, merge); survivorship per field by source rank, recency, verification and steward override; unmerge restores the sources; every value keeps its source, rule and time.
Hierarchies and reference dataHierarchies as business views over foreign keys with balanced, ragged and relationship-entity patterns for alternate roll-ups; hierarchy versioning is undocumented; reference entities are ordinary entities [9].Levels and several hierarchies per entity, kept as versions with validity dates and validated against the facts they aggregate; reference data and crosswalks kept as small domains with the same history, rules and security.
Rules, security and auditValidations for mandatory, list of values, unique keys, referential integrity and SemQL row rules; model, entity and attribute privilege grants with SemQL row-level filters (a stated limitation on some views); golden and master data historised with 'as of' reads by batch or date, empty until the model is redeployed after enabling [6][10][11].Column, row and business rules in one language, evaluated on save and on demand, including rules over aggregates and across tables; twelve security layers for read, write and delete; an append-only audit trail with point-in-time reads and logged reads of sensitive columns.
APIs and data servicesREST query, count and named-query endpoints with field selection ($expr), default page size 100; a SQL API for loads and direct SQL on hub tables; generated REST APIs for publishing golden records [12][1].REST, SOAP, SQL (JDBC and ODBC), events and an agent endpoint over one policy engine; the golden-record lookup answers with the record, the cross-reference and live related facts; page sizes and rate limits published per endpoint.
Analytics: pivots, measures, transactionsA Dashboard Builder charts query results and can embed a chart in a form bound to the current record; pivots and measures over transactions are absent [13].Pivots on any hierarchy level with time on the columns and measures in the cells; calculated measures; data entry with disaggregation by weights, equal shares or a time profile; drill-down from a cell to the transactions and to the source row; charts beside grids; natural-language and SQL querying.
Pricing unit and trialPricing is unpublished on the site; a Carahsoft AWS Marketplace private offer lists $705,200 for a 12-month, 20-million base-object contract; a 7-day licence is issued instantly and a 30-day licence on approval; Snowflake Marketplace trials on request [14][15][16].Platform capacity tiers (32C to 128C); domains, records, attributes and users included; the price is written before the work starts; a guided first domain on your data in one day; the showcase estate for demonstrations; a self-service sandbox tier is a decision pending (see the review notes).
Analyst placements 2025–26Gartner Magic Quadrant for MDM Solutions, April 6, 2026: Leader; Gartner Peer Insights Customers' Choice 2024; Forrester TEI: 315% three-year ROI [17][18].Analyst evaluation is the purpose of this page set; placements to date: none. The platform pages are organised on Gartner's eight mandatory features and four implementation styles so a briefing lands in the right market.
When to choose them

When Semarchy is the better choice

Choose Semarchy when a hub in your own database with direct SQL access is the intended architecture, when SemQL-style configuration suits a technical team, and when a Snowflake-native deployment or a sovereign self-hosted option matters. Its 30-day trial and '12 weeks to production' record are real advantages for a team that wants to prove the model before buying [15][19].

What Lima adds

When Lima master data is the better choice

Lima suits the enterprise whose master data should be governed on the rows in place across SAP, Oracle, the CRM and the lakes, with the transactions in the same bed: the golden record and its orders in one query, rules over totals, pivots on golden dimensions with data entry and disaggregation, drill-downs to the source row, and a headless lookup that answers with live related facts. Twelve security layers and an append-only audit trail apply to every door, and the price is written before the work starts.

The domain catalogue shows thirty domains with, for each, the objects read in place in SAP S/4HANA, Oracle Fusion, Salesforce, Workday, ServiceNow, Snowflake and Databricks and the interface used for the write-back.

Sources

Checked on September 17, 2026

Facts change; re-check the sources at each review and re-date the page.

  1. Semarchy tutorial: load data via SQL, checked Sep 17 2026 — https://www.semarchy.com/tutorials-content/load-data-via-sql/
  2. Semarchy platform page, checked Sep 17 2026 — https://semarchy.com/platform/
  3. Business Wire: Semarchy Snowflake Connected App, Jun 2 2026 — https://www.businesswire.com/news/home/20260602311860/en/Semarchy-Launches-Snowflake-Connected-App-for-Governed-Data-Products-and-Enterprise-AI
  4. Semarchy press release: self-hosted options, Sep 14 2026 — https://semarchy.com/press-releases/semarchy-expands-self-hosted-options/
  5. Semarchy press release: Data Platform launch, Sep 9 2025 — https://semarchy.com/press-releases/new-semarchy-data-platform-launch/
  6. Semarchy docs: certification process, checked Sep 17 2026 — https://www.semarchy.com/doc/semarchy-xdm/xdm/5.3/Design/data-certification/certification-process.html
  7. Semarchy docs: survivorship, checked Sep 17 2026 — https://www.semarchy.com/doc/semarchy-xdm/xdm/5.3/Design/matching/survivorship.html
  8. Semarchy release notes 2025.1, checked Sep 17 2026 — https://www.semarchy.com/doc/semarchy-xdm/xdm/latest/Install/release-notes/2025.1.html
  9. Semarchy docs: configure hierarchies, checked Sep 17 2026 — https://www.semarchy.com/doc/semarchy-xdm/xdm/5.3/Design/applications/configure-hierarchies.html
  10. Semarchy docs: model privileges and row-level security, checked Sep 17 2026 — https://www.semarchy.com/doc/semarchy-xdm/xdm/latest/Design/security/model-privileges.html
  11. Semarchy docs: data historization, checked Sep 17 2026 — https://www.semarchy.com/doc/semarchy-xdm/xdm/5.3/Design/logical-model/data-historization.html
  12. Semarchy docs: consume data with REST, checked Sep 17 2026 — https://www.semarchy.com/doc/semarchy-xdm/xdm/5.3/Integrate/consume-data-with-rest.html
  13. Semarchy docs: Dashboard overview, checked Sep 17 2026 — https://www.semarchy.com/doc/semarchy-xdm/xdm/2023.3/Dashboard/overview.html
  14. AWS Marketplace: Semarchy (Carahsoft private offer), checked Sep 17 2026 — https://aws.amazon.com/marketplace/pp/prodview-w4zxibe5t3wru
  15. Semarchy trial downloads, checked Sep 17 2026 — https://semarchy.com/trial-downloads/
  16. Semarchy Snowflake partner page, checked Sep 17 2026 — https://semarchy.com/partners/snowflake/
  17. Semarchy press release: 2026 Gartner MQ Leader, Apr 9 2026 — https://semarchy.com/press-releases/semarchy-named-a-leader-in-the-2026-gartner-magic-quadrant-for-master-data-management/
  18. Semarchy: Forrester TEI study, 2025 — https://semarchy.com/reports/forrester-tei-study/
  19. Semarchy blog: MDM implementation, updated Jan 6 2026 — https://semarchy.com/blog/mdm-implementation/

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.