What's New in SAS Scoring Accelerator 1.6 for Netezza

Overview

The SAS Scoring Accelerator 1.6 for Netezza has the following new features.

availability of the Score Code Export node software in SAS Enterprise Miner
ability to determine the case of variables in the generated sample SQL code
ability to specify an install database for the SAS_COMPILEUDF function
support for the Netezza TwinFin system
replacement of SFTP with the Netezza External Table interface

Score Code Export Node Software Availability

In the December 2009 release, the Score Code Export node software is available in SAS Enterprise Miner. In previous versions of the SAS Scoring Accelerator for Netezza, the software was provided in a ZIP file.

Ability to Determine the Case of Variables in the Generated Sample SQL Code

In the May 2010 release, a new argument, IDCASE, was added to the %INDNZ_PUBLISH_MODEL macro. The IDCASE argument specifies whether the variable names in the generated sample SQL code (SampleSQL.txt file) appear in uppercase or lowercase characters.

Ability to Specify the Install Database for the SAS_COMPILEUDF Function

In the May 2010 release, a new argument, DBCOMPILE, was added to the %INDNZ_PUBLISH_MODEL macro. The DBCOMPILE argument specifies the name of the database where the SAS_COMPILEUDF function is published.

Support for Netezza TwinFin Systems

In the June 2010 release, the SAS/ACCESS Interface to Netezza and the SAS Scoring Accelerator for Netezza support the Netezza TwinFin system. The new Netezza TwinFin system adds supports for shared libraries. The shared library technology makes the scoring functions more efficient and robust.

A new publishing macro %INDNZ_PUBLISH_JAZLIB was added to register the SAS 9.2 Formats Library as a shared library in a database. This new macro is supported only on the Netezza TwinFin system.

A new argument, DBJAZLIB, was added to the %INDNZ_PUBLISH_MODEL macro. The DBJAZLIB argument specifies the name of the database where the SAS 9.2 Formats Library for Netezza is published as a shared library. This new argument is supported only on the Netezza TwinFin system.

File Transfer with Netezza External Table Interface

In the June 2010 release, the use of SFTP for file transfer during the publishing process has been replaced with the Netezza External Table Interface. As a result, the SERVERUSERID= parameter for the INDCONN macro variable and the INITIALWAIT and FTPTIMEOUT arguments for the %INDNZ_PUBLISH_MODEL macro are no longer needed.

SAS Model Manager Support

In the November 2010 release, you can use the SAS Scoring Accelerator for Netezza in conjunction with SAS Model Manager Version 2.3 to manage and deploy scoring models in Netezza.