Internal project, anonymized

Metadata Governance Platform

Central management and quality assurance of metadata across a grown Access and MySQL landscape.

Industry

Data management

Problem

Several line-of-business applications accessed the same Access and MySQL data without shared validation rules or traceable access rights. Every new application increased the risk of conflicting data.

Solution

Governance platform with central management of data structures, validation rules, and access rights via ODBC connections and stored procedures. Every connected application now works from the same validated data.

Result

Consistent, validated data across all connected applications and less manual rework from data problems.

Tools

Access, MySQL, ODBC, Stored Procedures, VBA