Skip to main content

Entity Mapping

This page provides detailed mappings between Orthogramic Metamodel domains and OpenMetadata entities. Use these mappings to design your integration strategy.

Primary Entity Mappings

Orthogramic → OpenMetadata

Orthogramic DomainOpenMetadata EntityMapping TypeNotes
InformationTable, TopicDirectData assets map to information components
Value StreamPipelineConceptualValue stages map to pipeline tasks
PerformanceDashboard, MetricDirectKPIs map to dashboard metrics
ProductsData ProductDirectData products align directly
StakeholderUser, TeamDirectBusiness owners to OM owners
OrganizationDomain (OM)DirectOrg units to OM domains
PolicyPolicyDirectBusiness rules to governance policies
CapabilitiesCustom PropertyExtensionAdd capability context to assets
TechnologyServiceConceptualTech components to OM services
StrategyGlossary TermExtensionStrategic objectives as terms

Detailed Mappings by Domain

Information Domain → OpenMetadata Data Assets

The Information domain maps most directly to OpenMetadata's core data assets.

Orthogramic AttributeOpenMetadata PropertyMapping Logic
titledisplayNameDirect
descriptiondescriptionDirect
ownerownerResolve to OM User/Team
informationTypetableTypeEnum mapping
dataClassificationtagsMap to classification tags
dataQualitytestSuitesLink to quality tests
custodiandomain.expertsAdd as domain expert
dependencieslineageCreate lineage edges

Information Type Mapping:

Orthogramic TypeOpenMetadata Type
master-dataRegular + "master-data" tag
transactionalRegular + "transactional" tag
referenceRegular + "reference-data" tag
analyticalView or Materialized View
eventTopic

Example Mapping:

{
"orthogramic": {
"title": "Customer Master",
"description": "Core customer information",
"informationType": "master-data",
"owner": "Data Governance Team",
"dataClassification": "confidential",
"custodian": "Customer Data Steward"
},
"openMetadata": {
"displayName": "Customer Master",
"description": "Core customer information",
"tableType": "Regular",
"tags": [
{"tagFQN": "DataClassification.Confidential"},
{"tagFQN": "DataType.MasterData"}
],
"owner": {
"type": "team",
"name": "data-governance"
},
"domain": {
"type": "domain",
"name": "customer-domain"
}
}
}

Value Stream Domain → OpenMetadata Pipeline

Value streams conceptually map to data pipelines, representing the flow of value/data through stages.

Orthogramic AttributeOpenMetadata PropertyMapping Logic
titledisplayNameDirect
descriptiondescriptionDirect
stagestasksMap stages to pipeline tasks
inputssourceUrlReference source tables
outputssinkReference target tables
ownerownerResolve to OM User/Team
performanceIndicatorsCustom propertiesAdd KPI references

Stage to Task Mapping:

{
"orthogramic": {
"valueStreamID": "vs-order-to-cash",
"title": "Order to Cash",
"stages": [
{"name": "Order Capture", "capabilities": ["cap-order-entry"]},
{"name": "Fulfillment", "capabilities": ["cap-inventory", "cap-shipping"]},
{"name": "Invoicing", "capabilities": ["cap-billing"]},
{"name": "Collection", "capabilities": ["cap-accounts-receivable"]}
]
},
"openMetadata": {
"displayName": "Order to Cash",
"pipelineType": "metadata",
"tasks": [
{"name": "order_capture", "displayName": "Order Capture"},
{"name": "fulfillment", "displayName": "Fulfillment"},
{"name": "invoicing", "displayName": "Invoicing"},
{"name": "collection", "displayName": "Collection"}
],
"customProperties": {
"businessValueStream": "vs-order-to-cash",
"businessValue": "Revenue realization"
}
}
}

Stakeholder Domain → OpenMetadata Users/Teams

Stakeholders map to OpenMetadata's ownership model.

Orthogramic AttributeOpenMetadata PropertyMapping Logic
titledisplayNameDirect
descriptiondescriptionDirect
stakeholderTypeuserType /TeamIndividual or team
emailemailDirect
responsibilitiesCustom propertiesAccountability areas
influenceCustom propertiesEngagement level

Stakeholder Type Mapping:

Orthogramic TypeOpenMetadata Mapping
individualUser
groupTeam
roleTeam (role-based)
organizationTeam (org-based)

Example:

{
"orthogramic": {
"stakeholderID": "stk-cfo",
"title": "Chief Financial Officer",
"stakeholderType": "individual",
"email": "cfo@company.com",
"responsibilities": ["Financial Reporting", "Budget Management"]
},
"openMetadata": {
"entityType": "user",
"name": "cfo",
"displayName": "Chief Financial Officer",
"email": "cfo@company.com",
"teams": ["finance-leadership"],
"customProperties": {
"businessStakeholder": "stk-cfo",
"accountabilities": ["Financial Reporting", "Budget Management"]
}
}
}

Organization Domain → OpenMetadata Domains

Organizational units map to OpenMetadata's domain construct.

Orthogramic AttributeOpenMetadata PropertyMapping Logic
titledisplayNameDirect
descriptiondescriptionDirect
orgTypedomainTypeConceptual mapping
parentparentHierarchy preservation
ownerownerDomain owner

Example:

{
"orthogramic": {
"orgUnitID": "org-retail-banking",
"title": "Retail Banking Division",
"orgType": "division",
"parent": "org-banking-group",
"owner": "Head of Retail Banking"
},
"openMetadata": {
"entityType": "domain",
"name": "retail-banking",
"displayName": "Retail Banking Division",
"domainType": "Source-aligned",
"parent": "banking-group",
"owner": {
"type": "user",
"name": "head-retail-banking"
}
}
}

Policy Domain → OpenMetadata Policies

Business policies map to OpenMetadata governance policies.

Orthogramic AttributeOpenMetadata PropertyMapping Logic
titlenameDirect
descriptiondescriptionDirect
policyTypePolicy rulesTranslate to rule logic
scoperesourcesAssets covered
requirementsrulesSpecific conditions
ownerownerPolicy owner

Example:

{
"orthogramic": {
"policyID": "pol-data-retention",
"title": "Customer Data Retention Policy",
"policyType": "data-governance",
"scope": "All customer PII",
"requirements": [
{"rule": "Delete after 730 days", "enforcement": "mandatory"}
]
},
"openMetadata": {
"entityType": "policy",
"name": "customer-data-retention",
"fullyQualifiedName": "governance.customer-data-retention",
"policyType": "Lifecycle",
"rules": [
{
"name": "PII Retention Limit",
"effect": "deny",
"operations": ["Delete"],
"condition": "matchAnyTag('PII') && retentionDays > 730"
}
],
"customProperties": {
"businessPolicy": "pol-data-retention"
}
}
}

Performance Domain → OpenMetadata Metrics/Dashboards

Performance indicators map to OpenMetadata metrics and can be linked to dashboards.

Orthogramic AttributeOpenMetadata PropertyMapping Logic
titledisplayNameDirect
descriptiondescriptionDirect
measurementTypeCustom propertyClassification
targetValueCustom propertyTarget
currentValueMetric valueCurrent measurement
unitCustom propertyUnit of measure

Example:

{
"orthogramic": {
"kpiID": "kpi-customer-satisfaction",
"title": "Customer Satisfaction Score",
"measurementType": "outcome",
"targetValue": 4.5,
"currentValue": 4.2,
"unit": "score (1-5)"
},
"openMetadata": {
"entityType": "metric",
"name": "customer-satisfaction-score",
"displayName": "Customer Satisfaction Score",
"metricType": "Number",
"customProperties": {
"businessKPI": "kpi-customer-satisfaction",
"measurementType": "outcome",
"target": 4.5,
"unit": "score (1-5)"
}
}
}

Capabilities → OpenMetadata Custom Properties

Capabilities don't have a direct OpenMetadata equivalent but enrich data assets via custom properties.

Custom Property Schema:

{
"customPropertyConfig": {
"businessCapability": {
"propertyType": "string",
"description": "Orthogramic capability ID this asset supports"
},
"capabilityLevel": {
"propertyType": "integer",
"description": "Capability hierarchy level (L1, L2, L3)"
},
"capabilityOwner": {
"propertyType": "string",
"description": "Business owner of the capability"
},
"strategicAlignment": {
"propertyType": "string",
"description": "Strategic objective this capability supports"
}
}
}

Application to Table:

{
"table": {
"fullyQualifiedName": "warehouse.crm.customers",
"customProperties": {
"businessCapability": "CAP-CRM-001",
"capabilityLevel": 2,
"capabilityOwner": "Head of Customer Operations",
"strategicAlignment": "Digital-first customer experience"
}
}
}

Mapping Summary Table

Orthogramic DomainPrimary OM EntitySecondary OM EntitiesCustom Properties
InformationTable, TopicGlossary Term-
Value StreamPipeline-businessValueStream
PerformanceDashboard, Metric-businessKPI
ProductsData Product-businessProduct
StakeholderUser, Team-businessStakeholder
OrganizationDomain-orgUnit
PolicyPolicyTagbusinessPolicy
Capabilities-Glossary TermbusinessCapability
TechnologyService-technologyComponent
StrategyGlossary Term-strategicObjective
Initiatives--businessInitiative
Risk ManagementTag, Policy-riskAssessment