Metastudio DRM is a tool for data warehouse or master data dictionaries.
Central place for automated validation and versioning of reference data
on premises and cloud.
All data warehouse or master data dictionaries in one place
Data warehouse or master data dictionaries are organized into a central, hierarchical structure of folders and objects. You can see all reference data in one tree with appropriate user rights.
Data dictionaries managment on premises and in cloud
Infrastructure in the age of total digititalization is changing rapidly. More and more data is processed in the cloud. You can manage dictionaries in one place, regardless of where they are implemented.
Advanced validation of dictionary data
Validation based on regular expressions, value lists. Implemented syntax validators, e.g. sql, SAS scripts.
Interface built on the basis of user experience. Examples of solutions: data display configuration, “as in Excel” data editing, the ability to create related dictionary data, documentation or reports, displaying hierarchical dictionaries.
Integration with external user authentication systems
Integration with LDAP or Windows Active Directory at the Single Sign-On level. A permission system that allows you to control the level of user access to individual folders and objects of a reference data repository.
Automatic registration of the history of reference data changes
Audit of actions performed by users at the level of the user account, facility, date and time, and type of event. Possibility of subscribing to automatic notifications via e-mail about important actions performed by users on the indicated facilities.
Customer Success Stories
Metastudio DRM allows our business users intuitive work with dictionary data. This solution gives us the possibility to create advanced control schemes for entering data and to verify data warehouse configuration for a specific moment in time. An important feature for us is the validation of the syntax of automatically generated data loading processes.
The key task of the data warehouse at the Bank is to support processes related to mandatory reporting and risk estimation. Business requirements necessitate frequent changes to the data warehouse configuration. Metastudio DRM fully met this requirements and is an important element of the bank’s data warehouse architecture. This tool reduces the risk of introducing incorrect configuration by technical users and quickly determines who, when and what changes in warehouse parameters introduced and what consequences they had for the reporting data.