Back to all schema formats

    Schema Formats

    Erwin XML

    Erwin Data Modeler XML repository exports are parsed into the MetaModel preserving entities, attributes, domains, subject areas, and physical-to-logical mappings — so existing enterprise data models become governed Magellan assets without re-modeling.

    The Erwin adapter accepts XML exports from current and prior versions of Erwin Data Modeler. Logical entities, physical tables, attributes, columns, domains, primary/foreign keys, indexes, and subject areas are all preserved with their relationships intact.

    The logical/physical split is preserved in the MetaModel rather than being collapsed. A logical entity `Customer` and its physical realization `dbo.tbl_customer_v2` are linked by a `realizes` edge in the MetaModel, so a Hierarchical Schema Inspection view can render either layer without re-deriving the relationship.

    Erwin domains — reusable type definitions like `MoneyAmount` or `EmailAddress` — become first-class MetaModel domain objects. Re-applying a domain in a downstream mapping inherits its constraints, descriptions, and classification labels automatically, instead of requiring re-annotation per use.

    Each ingest writes a `SchemaIngested` entry with the importer module identifier (`ErwinXmlImporter@x.y.z`), the SHA-256 of the XML bytes, and the assigned schema ULID. The Erwin model GUID is captured as a provenance annotation so a reviewer can correlate Magellan entries with the source Erwin model file.

    When an Erwin model is re-exported and re-ingested after edits in the Erwin tool, the adapter computes the diff against the prior `SchemaVersionPublished` entry and writes `SchemaEvolutionEvaluated`. Additive changes auto-classify as minor; renames and type-narrowing classify as major; both require an Approver before reaching Published.

    Erwin is often the system-of-record for enterprise data architecture. By keeping the Erwin model as the source artifact and the Magellan MetaModel as the governed projection, teams avoid the trap of two parallel models drifting out of sync — the Magellan side is always derivable from a known Erwin export ULID.

    Audit ledger entries written by this capability

    Each action in this capability appends one of the following entry types to the ULID‑keyed, SHA‑256 hash‑chained audit ledger. A reviewer can replay the chain to reconstruct exactly what happened, when, and under which role.

    SchemaIngestedSchemaParsedDomainResolvedSchemaEvolutionEvaluated
    Read the full Audit & Trust architecture

    See erwin xml demonstrated against your data

    Pick a sample dataset or bring your own. We will walk the ledger from ingest through Approver release in a single working session.

    Request a demo