Overview of the In-Database Deployment Package for Teradata

This section describes how to install and configure the in-database deployment package for Teradata (SAS Formats Library for Teradata and SAS Embedded Process). The in-database deployment packages for Teradata must be installed and configured before you can perform the following tasks:
  • Use the %INDTD_PUBLISH_FORMATS format publishing macro to publish the SAS_PUT( ) function and to publish user-defined formats as format functions inside the database.
    For more information about using the format publishing macros, see the SAS In-Database Products: User’s Guide
  • Use the %INDTD_PUBLISH_MODEL scoring publishing macro to publish scoring model files or functions inside the database.
    For more information about using the scoring publishing macros, see the SAS In-Database Products: User’s Guide
  • Use the SAS In-Database Code Accelerator for Teradata to execute DS2 thread programs in parallel inside the database.
    For more information, see the SAS DS2 Language Reference.
  • Perform data quality operations in Teradata using the SAS Data Quality Accelerator for Teradata.
    For more information, see SAS Data Quality Accelerator for Teradata: User’s Guide.
    Note: If you are installing the SAS Data Quality Accelerator for Teradata, you must perform additional steps after you install the SAS Embedded Process. For more information, see SAS Data Quality Accelerator for Teradata.
  • Run SAS High-Performance Analytics when the analytics cluster is using a parallel connection with a remote Teradata data appliance. The SAS Embedded Process, which resides on the data appliance, is used to provide high-speed parallel data transfer between the data appliance and the analytics environment where it is processed.
    For more information, see the SAS High-Performance Analytics Infrastructure: Installation and Configuration Guide.
The in-database deployment package for Teradata includes the SAS formats library and the SAS Embedded Process. In the fourth maintenance release of SAS 9.4 (November 2016), if you license SAS In-Database Technologies for Teradata, the SAS Data Quality Accelerator for Teradata scripts are also deployed with the SAS Embedded Process.
The SAS formats library is a run-time library that you install on your Teradata system. This installation is done so that the SAS scoring model functions or the SAS_PUT( ) function can access the routines within the run-time library. The SAS formats library contains the formats that are supplied by SAS.
Note: The SAS formats library is not required by the SAS Data Quality Accelerator for Teradata.
The SAS Embedded Process is a SAS server process that runs within Teradata to read and write data. The SAS Embedded Process contains macros, run-time libraries, and other software that is installed on your Teradata system.
Note: If you are performing a system expansion where additional nodes are being added, the version of the SAS formats library and the SAS Embedded Process on the new database nodes must be the same as the version that is being used on already existing nodes.
Note: In addition to the in-database deployment package for Teradata, a set of SAS Embedded Process functions must be installed in the Teradata database. The SAS Embedded Process functions package is downloadable from Teradata. For more information, see Installing the SAS Embedded Process Support Functions.
Last updated: February 9, 2017