UD4D — Use data for decisions

UD4D AI Accelerator for WhereScape

Change your WhereScape environment faster, without losing sight of what each change affects. The AI Accelerator is independent UD4D software that runs alongside that environment. It traces column-level lineage in seconds, analyzes impact before anything is modified, and automates repetitive WhereScape RED and 3D work, with human approval before any write is executed.

The UD4D AI Accelerator on two tablets: a dry-run plan across Source, Stage, Data Vault and star schema, and the column-level lineage behind it
WHEN IT FITS

When the AI Accelerator is right for you

WhereScape already automates the core of the data warehouse. The AI Accelerator takes automation further into analysis and repetitive tasks that are still handled manually.

  • Tracing one column by hand

    Understanding how a source column moves through Stage, Data Vault and star schema means following it manually, layer by layer.

    Tracing one column by hand
  • Assessing change impact

    Before an object changes, teams need to know what else it affects. Today that means tracing dependencies by hand.

    Assessing change impact
  • Propagating changes

    A single source change requires repetitive updates across multiple warehouse layers.

    Propagating changes
  • Concentrating knowledge in a few people

    When repository knowledge sits with a small number of specialists, onboarding and day-to-day analysis become harder to scale.

    Concentrating knowledge in a few people
KEY CAPABILITIES

Understand, change and govern your WhereScape repository

The UD4D AI Accelerator works directly with your metadata in the WhereScape RED and 3D repositories. It starts by reading your environment and ends with a change that a person has approved.

Environment & deployment awareness

The UD4D AI Accelerator first profiles the target environment before anything else runs, then adjusts what it can safely offer.

  • Profiles the WhereScape RED/3D environment before other tools run
  • Detects whether Data Vault and WhereScape 3D are in use
  • Checks WhereScape RED/3D naming conventions and deployment characteristics
  • Uses the environment profile to guide which capabilities can be applied safely
Lineage & impact analysis

The UD4D AI Accelerator traces where data comes from, where it goes, and what a proposed change could affect before anything is modified.

  • Traces column- and table-level lineage inside WhereScape RED and 3D
  • Cross-checks WhereScape RED and 3D lineage against each other
  • Follows sources, transformations and targets across the warehouse
  • Analyzes downstream impact before a change is made
  • Follows fan-out through formulas, transformations and aggregations
Agentic column propagation

The UD4D AI Accelerator turns a source-column change into a controlled, reviewable update across the WhereScape pipeline.

  • Propagates a new source attribute through WhereScape 3D and RED
  • Carries the change through to the target database
  • Prepares the proposed change as a package for review before execution
  • Supports preview and dry-run before a live write
  • Executes only after the package is approved
Data quality & repository health

The UD4D AI Accelerator identifies metadata problems across WhereScape RED and 3D and supports safe remediation before they become larger issues.

  • Scans WhereScape RED and 3D repositories for invalid data-type modifiers
  • Detects orphaned repository metadata
  • Surfaces metadata inconsistencies across WhereScape RED and 3D
  • Supports controlled cleanup where remediation is available
  • Uses backup and transactional safeguards for write operations
A standards-conformant MCP server

The UD4D AI Accelerator implements the Model Context Protocol as a standard, so the tool layer stays independent of any single AI client.

  • Exposes the UD4D AI Accelerator's tools through the Model Context Protocol
  • Allows any compatible AI client to connect to the same underlying capabilities
  • Keeps the tool layer independent of a single AI client or interface
  • Supports natural-language interaction with repository exploration, lineage, analysis and actions
  • Provides a reusable foundation for additional AI-assisted workflows
Governance & control

The UD4D AI Accelerator operates under human authority, with a defined boundary around what it can see and change.

  • Executes no write until a human approves the prepared change package
  • Works with metadata and transformation SQL only, never your business data
  • Operates through controlled interfaces, without modifying WhereScape RED or 3D themselves
  • Logs every action and re-verifies the result after execution
  • Runs on-premises with your own AI provider of choice
THE MECHANISM BEHIND IT

How the UD4D AI Accelerator works

Environment profiling

Checks readiness before anything else runs.

Clear to proceed

Metadata ingestion

Reads the metadata from the repository.

Raw metadata

Lineage engine

Maps sources, transformations and targets.

Lineage graph

Reasoning / agent layer

Plans the required actions through the MCP.

Change package

Action layer

Prepares the change package for approval.

Execution request

Governance & approval

Human sign-off and actions logged.

Feedback from step “Governance & approval” back to step “Action layer”: approved → executes / rejected → sent back

PROVEN IMPACT

What this changes for your team

Teams answer impact questions faster, spend less time on repetitive repository work, and depend less on a handful of specialists.

  • 85%

    less time to trace column- and table-level lineage and dependencies

  • 75%

    less time needed to automatically propagate a new source column

  • 20–50%

    of annual WhereScape RED and 3D-related work significantly accelerated*

  • 10–20%

    of developer workload directly addressed by lineage and impact analysis*

*Directional estimates based on current user feedback.

COOPERATION MODEL

How we deliver to your WhereScape environment

REQUEST A DEMO

See the UD4D AI Accelerator run on a repository like yours

In a live demo, we trace lineage and propagate a change in a real WhereScape environment, then walk through what it means for your team.

* Required