Mapping Studio

Mapping Studio allows you to map physical data assets (such as databases, tables, and columns from an external data catalog) directly to your standardized business glossary terms in Termboard.

Overview

Mapping Studio provides a 3-panel workspace for bridging technical catalog metadata and business terminology:

Logical Data Model / Catalog Panel (Left): View and import source catalog entities and attributes (from CSV uploads, OpenMetadata catalog integration, or sample LDM data).
Mapping Workspace (Center): Match source attributes to target glossary terms, review AI-assisted suggestion scores, filter catalog items, and verify mappings.
Semantic Glossary Terms Panel (Right): Browse all business glossary terms in List View or Hierarchy Tree View, search across name/description/mapped columns, open term details sidebar, or link attributes.

Catalog Input Formats

Mapping Studio supports multiple input sources for loading physical data assets into the studio.

1. CSV Import Format

You can import catalog schemas from any CSV file or spreadsheet export (.csv). The CSV parser is flexible and automatically recognizes column headers using alias matching.

Supported Columns & Header Aliases

Field	Description	Supported Header Aliases (Case-Insensitive)	Default Value if Omitted
Container	Parent entity, table, or domain name	`container`, `entity`, `table`, `tablename`, `domain`, `class`	`DefaultEntity`
Name	Attribute, column, or property name	`name`, `attribute`, `column`, `columnname`, `field`, `property`, `attr`	`Attribute_<index>`
Description	Human-readable documentation or comment	`description`, `desc`, `definition`, `comment`, `doc`	Empty / undefined
Data Type	Physical data type (e.g. `VARCHAR`, `INTEGER`)	`datatype`, `type`, `fieldtype`	Empty / undefined
ID	Unique identifier for the attribute	`id`, `attributeid`, `guid`, `uid`	`<container>.<name>`
Source System	Name of the source database or catalog system	`sourcesystem`, `source`, `system`	`CSV_Import`

CSV Formatting Rules

Delimiter: Standard comma (,).
Quotes: Values containing commas or double quotes should be wrapped in double quotes ("...").
Line Endings: Supports both Unix (\n) and Windows (\r\n).

Example CSV

csv

table, column, datatype, description, system
Customer, customer_id, INT, "Unique primary identifier for customer", Postgres_Prod
Customer, email_address, VARCHAR(255), "Primary contact email address", Postgres_Prod
Customer, created_at, TIMESTAMP, "Timestamp when account was created", Postgres_Prod
Orders, order_id, INT, "Primary key for customer order", Postgres_Prod
Orders, total_amount, DECIMAL(10,2), "Monetary total for order", Postgres_Prod

2. OpenMetadata Catalog Integration

Mapping Studio connects directly to an OpenMetadata server instance to fetch live enterprise catalog metadata:

Server URL: REST API endpoint (e.g. https://catalog.company.com/api).
JWT Token: Authentication token for OpenMetadata API access.
Service Name Filter: Filter assets by specific database services or data models.
Ingestion: Automatically pulls entities (tables) and attributes (columns) with data types, descriptions, and tag annotations.

3. Native Mapping JSON Format

You can load previously exported Mapping Studio JSON project files (.json) to resume a mapping session. The JSON schema contains:

version: Protocol version ("1.0").
sourceItems: Array of loaded catalog entities and attributes.
mappings: Array of attribute-to-term mapping records (status, termId, confidence, matchMethod).
abbreviations: Domain-specific acronym/abbreviation dictionaries.

The right panel displays all business glossary terms currently present on your Termboard canvas.

View Modes

Flat List View: Alphabetical or filtered list of all terms with mapped attribute badges and suggestion scores.
Hierarchy Tree View: Displays parent-child inheritance relationships between terms. Includes Expand All and Collapse All toolbar buttons.

Search & Filtering

Search Target Options: Search within All Fields, Name Only, Description Only, or Mapped Columns Only.
Status Filter Chips: Filter terms by All, Unmapped, or Mapped.

Interactive Tile Actions

Clicking a Term Tile: Clicking anywhere on a term tile opens the Term Details Sidebar on the right side of the screen, allowing you to review definitions, domain profiles, parents, and extra fields.
Link Icon Button (mdi-link-variant): Clicking the green link icon button on the right side of a term tile immediately links the currently selected attribute in the catalog panel to that term.
Mapped Attribute Badges: Clicking a mapped attribute badge on a term tile jumps to and selects that attribute in the catalog list.
Suggested Term Badges: Clicking a 1-click suggestion chip links the attribute to the suggested term with a single click.

AI & Automated LLM Matching

Mapping Studio includes built-in semantic matching powered by WebLLM or backend AI services:

Click Run LLM Matching in the top action bar.
The AI model evaluates catalog attribute names and descriptions against canvas glossary terms.
Candidate matches receive a Confidence Score (e.g., 95%) and match reasoning (exact, semantic, acronym).
High-confidence suggestions are highlighted in orange tiles in the glossary list.
Click Accept Top Suggestions to bulk-verify all top AI recommendations.

Exporting & Data Deliverables

When mapping is complete, you can export your deliverables in multiple standard formats.

1. Excel Workbook (.xlsx)

Exporting to Excel generates a multi-worksheet workbook:

Sheet 1: Mappings:
- Source Attribute ID: Technical attribute identifier.
- Catalog Attribute: Column / attribute name.
- Entity / Container: Table / entity name.
- Mapped Term ID: Linked business term identifier.
- Mapped Term Label: Display label of the business term.
Sheet 2: Catalog Attributes: Complete dictionary of all imported source attributes, data types, descriptions, and source systems.
Sheet 3: Summary: Governance summary metrics including:
- Total Catalog Attributes
- Verified Mappings
- Suggested Mappings
- Unmapped / Ignored Attributes
- Overall Completion Rate (%)

2. JSON Project Export

Export the full session state (source items, mappings, connectors, and domain abbreviations) as a JSON document for version control or automated pipelines.

3. Push to Catalog

If connected to OpenMetadata, click Push Verified to write verified glossary term links directly back into the OpenMetadata catalog backend.

Step-by-Step Workflow Guide

Open Mapping Studio: Launch Mapping Studio from the top toolbar or workspace toggle.
Load Source Data: Upload your database schema CSV or connect to OpenMetadata.
Select Attribute: Click an attribute in the left catalog list to view candidate matches.
Inspect Term Details: Click a term tile in the right list to open the term sidebar and review term definitions.
Link Attribute: Click the Link icon on the term tile to establish a verified mapping.
Run AI Matching (Optional): Click Run LLM Matching to automatically match remaining attributes.
Export Results: Click Export Excel to generate documentation for stakeholders or compliance teams.

Mapping Studio ​

Overview ​

Catalog Input Formats ​

1. CSV Import Format ​

Supported Columns & Header Aliases ​

CSV Formatting Rules ​

Example CSV ​

2. OpenMetadata Catalog Integration ​

3. Native Mapping JSON Format ​

Glossary Navigation & Tile Interactions ​

View Modes ​

Search & Filtering ​

Interactive Tile Actions ​

AI & Automated LLM Matching ​

Exporting & Data Deliverables ​

1. Excel Workbook (.xlsx) ​

2. JSON Project Export ​

3. Push to Catalog ​

Step-by-Step Workflow Guide ​