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.
Copyright © SAS Institute Inc. All rights reserved.