Integration Views

Integration Views

Integration views expose entity data as real SQL views in the [mdm] schema, making them queryable by external systems (BI tools, ETL pipelines, APIs).

View types:

• Flat — Columns from a single entity only
• Hierarchy — Denormalized view including parent entity columns (e.g., Business Unit + Zone + Country combined)

Create a view:

1. Go to Settings → Integration Views
2. Click New view
3. Select: Entity, View Type, and Name
4. Optionally exclude columns
5. Click Save — the SQL view is automatically deployed to [mdm].[viewName]

Copyable query: Each view shows a ready-to-use SQL snippet (e.g. SELECT * FROM [mdm].[vw_Branch_Flat]) on the list, edit, and detail screens. Click to copy.

A column snapshot is taken when the view is created. This snapshot is used to detect drift.

Drift Detection & Sync

When entity metadata changes (attributes added, removed, or renamed), integration views may become out of sync. This is called "drift".

Severity levels:

• Error (red) — Columns have been removed. The view is broken.
• Warning (orange) — New columns are available, or types have changed.

Drift is shown in:

• A warning banner on the Integration Views list
• A badge on the Notification Bell (top-right)
• The Dashboard drift warnings section

To resolve drift:

1. Click a view name to open its detail page
2. Review the changes: removed columns, new columns, type changes
3. Click Sync to update the view's snapshot and redeploy the SQL view

Sync All Views: From the Integration Views list, click Sync all views to resolve all drift at once. A confirmation dialog shows exactly what will change for each view before you confirm. All affected SQL views are redeployed automatically.