What's New in SAS 9.3 Data Quality Server

Overview

SAS 9.3 Data Quality Server provides procedures and functions that enable you to administer and run jobs and services on DataFlux Data Management Platform from DataFlux (a wholly owned subsidiary of SAS Institute Inc.). This release of SAS Data Quality Server also contains language elements specific to data extraction definitions.
SAS 9.3 Data Quality Server includes the following enhancements:
  • New functions and procedures that support DataFlux Data Management Server 2.1 and later.
  • Deprecation or replacement of legacy functions and procedures to provide a migration path from DataFlux dfPower Studio to DataFlux Data Management Studio. Some utility functions have also been renamed to reflect this.
  • Inclusion of functions to enable you to process data using extraction definitions.

New Functions and Procedures

Many of the functions and procedures added for this release of SAS Data Quality Server support DataFlux Data Management Server 2.1 and later. These new functions and procedures begin with DM and are not compatible with DataFlux Integration Servers or DataFlux dfPower Studio applications. Additional functions and procedures included in this release of SAS Data Quality Server enable you to customize extraction definitions for use with applications such as Blue Fusion 8.2 and later. Each function and procedure is listed in the following sections along with a brief description.

Server Process and Utility Functions

The following functions are new in SAS 9.3 Data Quality Server and operate with DataFlux Data Management Server 2.1 and later:
  • The DMSRVBATCHJOB function runs a DataFlux Data Management batch job or a DataFlux Data Management process job and returns a job or process identifier, as appropriate.
  • The DMSRVCOPYLOG function copies a log file from a DataFlux Data Management Server to the local machine.
  • The DMSRVDELETELOG function deletes a job’s log file from the DataFlux Data Management Server.
  • The DMSRVJOBSTATUS function returns the status of a job that was submitted to a DataFlux Data Management Server.
  • The DMSRVKILLJOB Function terminates a job that is running on a DataFlux Data Management Server.
  • The DMSRVPROFILEJOB function generates a profile from a Data Management repository.
  • The DMSRVUSER function sets the user name and password relative to the DataFlux Data Management Server.
  • The DMSRVVER function returns the version of the DataFlux Data Management Server.

Extraction Definition Support Functions

Extraction support functions that are new to SAS 9.3 Data Quality Server include the following:
  • The DQEXTINFOGET function returns the token names in an extraction definition.
  • The DQEXTRACT function returns an extracted character value.
  • The DQEXTTOKENGET function returns a token from an extraction character value.
  • The DQEXTTOKENPUT Function inserts a token into an extraction character value and returns the updated extraction character value.
To support the new extraction definition functions, the macro, %DQPUTLOC, now lists extraction definitions along with all other types of definitions.

Server Process Procedures

Procedures new in SAS 9.3 Data Quality Server that work exclusively with DataFlux Data Management Server 2.1 and later include the following:
  • PROC DMSRVADM returns a list of jobs running on a DataFlux Data Management Server.
  • PROC DMSRVDATASVC runs DataFlux Architect and data services.
  • PROC DMSRVPROCESSSVC runs DataFlux Data Management process services.

Interoperability and Legacy Support

SAS 9.3 Data Quality Server is an optimized implementation designed to work as part of a SAS offering for an integrated system or as a component within a DataFlux Data Management Platform configuration. As a component within a DataFlux Data Management Platform configuration, several functions and procedures (identified by names beginning with DM) work exclusively with DataFlux Data Management Server 2.1 and later.
Whereas SAS 9.3 continues to support all DQSRV functions and procedures, the operations will attempt to execute using a Data Management Server by default.
Remember the following as you work with SAS Data Quality 9.3:
  • DMSRV functions and procedures issue an error if a host and port that are serving up a DataFlux Integration Server are specified. This code works with DataFlux Data Management Servers only.
  • All DQSRV functions and procedures run on any version of either DataFlux Data Management Server or DataFlux Integration Server, but will issue a deprecation warning.