DataFlux Data Management Studio 2.8: User Guide

Overview of DataFlux Software

DataFlux Data Management Studio and Server

DataFlux Data Management Servers provide a scalable server environment for your jobs, profiles, and real-time services. After you upload your jobs and real-time services to the server, authorized users across your enterprise execute them.

In a production environment, you typically run test jobs and small jobs on the DataFlux Data Management Studio host. You upload larger jobs to a DataFlux Data Management Server. The DataFlux Data Management Server provides a scalable server environment for large Data Management Studio jobs. Jobs are uploaded from Data Management Studio to a Data Management Server, where the jobs are executed. For more information, see Data Management Servers Riser Bar.

Authorization Server

SAS Quality Knowledge Bases 

A Quality Knowledge Base (QKB) is a collection of files that store data and logic that define data management operations. SAS software products reference a QKB when performing these operations on your data. There are currently two QKBs available: QKB for Contact Information (CI) and QKB for Product Data (PD).

You can use definitions in a QKB as delivered, or you can use DataFlux Data Management Studio to customize the QKB by modifying definitions or creating new definitions for use with your own business data. Since a QKB is used by DataFlux Data Management Studio, SAS Data Quality Server, and the SAS Data Quality Accelerators, QKB customizations are automatically available to your entire enterprise. For more information, see Managing Quality Knowledge Bases.

DataFlux Web Studio

DataFlux Web Studio is an optional, web-based application. It has separately-licensed modules that enable you to perform data management tasks from a web browser. DataFlux Web Studio Server runs the jobs that support all of the Web Studio modules. Each of the following modules has its own tab in DataFlux Web Studio.

DataFlux Reference Data Manager provides a web interface for creating and managing reference data, such as a list of valid values for a Gender field or a list of valid ZIP codes with their associated cities and states. The values are organized into domains. Reference Data Manager domains can be used in DataFlux Data Management Studio data jobs and in business rules. For more information about domains and data jobs, see Using Reference Data Manager Domain Items in a Job. For more information about domains and business rules, see Create a Rule that Compares Two Fields.

DataFlux Reference Data Manager is separately licensed module in DataFlux Web Studio. It enables you to create collections of reference data that are referred to as domains. The following features in DataFlux Data Management Studio can use these domains:

• the Domains node and Domain List node for data jobs
• the “Compare a field to reference data domain” rule in Business Rule Manager

DataFlux Web Studio is a Flash-based application. Adobe will soon end support for Flash. If you are concerned about the end-of-life for Flash, you can use a new application, SAS Reference Data Manager, to create domains. You can then apply a software patch to DataFlux software so that it can use the new domains. The new domains are stored on the SAS mid-tier, not in a DataFlux repository. For more information about SAS Reference Data Manager, see Optional Configuration Steps for Data Management Platform Integration with Reference Data Manager in DataFlux Data Management Studio 2.8: Installation and Configuration Guide.

DataFlux Monitor Viewer and Dashboard Viewer provide web interfaces for reviewing defined output of business rules, along with exceptions. This output includes items such as rules, triggers, history, dimensions, scores, and trends. The output is generated by data monitoring jobs that are created in 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 DataFlux Data Management Studio, but the web interfaces are available to those who do not have access to DataFlux Data Management Studio. For more information about creating data monitoring jobs, see Monitoring Data.

DataFlux Data Management Studio enables you to create business rules. These rules can be used to monitor the quality of output from data jobs. One way to monitor these jobs is to use the Dashboard Viewer and Monitor Viewer in DataFlux Web Studio. DataFlux Web Studio is a Flash-based application, and Adobe will soon end support for Flash. Accordingly, SAS provides a SAS Visual Analytics report that provides similar information to the Dashboard Viewer and Monitor Viewer.

SAS provides the SAS Visual Analytics report and a predefined DataFlux Data Management Studio process job. Typically, you deploy the pre-defined process job to a DataFlux Data Management Server and run it from there. The job reads monitor and dashboard data from one or more repositories that are managed by the DataFlux Data Management Server. The job writes three tables into a staging database on the SAS Monitor and Dashboard Data Server and loads them into SAS LASR Analytic Server. The tables can be accessed in the new Monitor and Dashboard Governance Report. For more information about these new, optional reports, see "Optional Configuration Steps for the Monitor and Dashboard Governance Report" in DataFlux Data Management Studio 2.8: Installation and Configuration Guide.

Note: In order to use the DataFlux Web Studio modules that are described above, Web Studio and the separate modules must be licensed on the relevant server.

For more information about DataFlux Web Studio, see the DataFlux Web Studio User's Guide and the DataFlux Web Studio Installation and Configuration Guide.

Related Products

See Related Products for information about DataFlux Address Update Add-On, Data Management Server for SAS, SAS Business Data Network, SAS Federation Server, and SAS Lineage.