DataFlux Web Studio :: SAS(R) 9.4 Data Management: Overview

DataFlux Web Studio supports data management functions with three components: Dashboard, Data Monitor, Reference Data Manager.

The Monitor Viewer and Dashboard Viewer components in DataFlux Web Studio provide web interfaces for viewing exceptions to monitored business rules. The exceptions are generated by data monitoring jobs that are created in DataFlux Data Management Studio and are deployed to a DataFlux Data Management Server. These web interfaces are similar to the Monitor Viewer and Dashboard tab in Data Management Studio. However, the web interfaces are available to those who do not have access to DataFlux Data Management Studio.

The SAS monitoring capability supports the ability to detect data anomalies. These anomalies include variances, values inside or outside of ranges, values that violate mathematical calculations, values that vary from historical values, and much more. Once identified, these anomalies are presented to the business user through an intuitive graphical dashboard for further analysis. The dashboard not only displays data violations, but also supports the ability to trend values over time as well as compare current values to historical values.

Graphical displays aid in visualizing and trending issues that have been uncovered during the monitoring of specified business rules. These data quality dashboards provide high-level access and understanding to all data quality issues discovered by the SAS solution.

The Monitor Viewer provides a detailed, interactive view of the exceptions to monitored business rules. The exceptions are generated by data monitoring jobs that are created in DataFlux Data Management Studio. The output of these jobs can be monitored in DataFlux Web Studio, using Monitor Viewer.

The Reference Data Manager is a component of DataFlux Web Studio. It provides a web interface for creating and managing reference data. Examples of reference data include a list of valid values for a product code and a complete list of countries with their associated cities and states. The values are organized into domains. Reference Data Manager domains can be used in Data Management Studio data jobs and in business rules.

Reference Data Manager enables you to build and manage relationships and hierarchies across data elements. Reference Data Manager offers a web-based interface that can be used across departments and lines of business to store and manage different types of hierarchies.

Reference Data Manager allows data governance and data management teams to perform the following tasks:

maintain reference data entities consistently across the organization, with definitions and relationships clearly defined for each entity and the entity values
validate data in any source system using the reference data managed in this application
create reference data required for effective master data management efforts

Using the Reference Data Manager component, you can access a single repository to manage important reference data that is accessed by technical, business, and IT users. This repository is centrally managed, versioned (so that the history and progression of changes to the data can be maintained and managed), and exported to external systems.