Scoring with User-Defined Functions and the SAS Embedded Process

There are two methods by which format publishing models are processed inside the data source:
  • user-defined functions
    Scoring models are converted by the publishing macros into scoring functions that are similar to any user-defined functions in the data source.
    In-database processing of scoring models by means of user-defined functions is supported by DB2 under UNIX, Greenplum, Netezza, and Teradata.
  • SAS Embedded Process
    The SAS Embedded Process is a SAS server process that is installed and runs inside the data source to read and write data from the data source. The advantage of using the SAS Embedded Process is that a single function or a stored procedure is used instead of multiple, user-defined functions.
    The SAS Embedded Process is supported for Aster, DB2, Greenplum, Hadoop, Netezza, Oracle, SAP HANA, and Teradata scoring models.
    The SAS Embedded Process is one of the deployed components for in-database processing. For more information, see the SAS In-Database Products: Administrator’s Guide.