SAS Master Data Management

Master data management (MDM) is the creation of a single, accurate and unified view of corporate data, integrating information from various data sources into one master record. This master data is then used to feed information back to the applications, creating a consistent view of data across the enterprise. MDM allows for consistent, reliable data to feed operational applications, helping end users access customer, patient, citizen, employee, product, asset, or location data.
SAS Master Data Management performs the following functions:
  • extracts business information from your data sources
  • validates and standardizes the data by using data quality functions described in this chapter
  • captures data errors through user-defined business rules and sequesters the data for review and correction
  • consolidates the information into a single view of the information available from all the data sources
The organizational data that you provide can be customer data, product data, services data, or data for other entity types. SAS MDM applies a rigorous methodology to the problem of integrating disparate enterprise data.
SAS MDM is a combination of software, templates, documentation, data models, and services that provide the functionality and processes necessary to build and maintain a master entity database. An entity can be a customer, product, patient, site, or any business data object that you define. You can also define attributes for each entity. Also, you can use transformations that support data quality and identity management functionality.
The SAS MDM hub is a set of tables and table relationships that contain entity information and required entity keys and linking information. This hub provides end users or applications with a complete view of an entity and its relationships with other entities. In addition, the hub can be used as the single source for creating and maintaining survivor records that can be used in other applications or processes. The original source system IDs are important to other enterprise applications or data sources. They are also maintained in the hub to facilitate linking activities with other data providers or consumers.
The following display shows the interface for creating and editing rules on the Clusters tab for an entity type:
Entity Type Clustering Tab
Entity Type Clustering Tab
Note: SAS MDM includes and is integrated with DataFlux Data Management Platform. Therefore, to use SAS MDM successfully, you must be familiar with DataFlux Data Management Platform.