Creating and Managing SAS Data Quality Accelerator Stored Procedures in the Teradata Database

Overview

SAS data quality functionality is provided in the Teradata database as Teradata stored procedures. The sepdqacctera package installs three scripts in the Teradata database in addition to deploying SAS Data Quality Accelerator binaries:
  • a stored procedure creation script named dq_install.sh
  • a stored procedure removal script named dq_uninstall.sh
  • a user authorization script named dq_grant.sh
The scripts are created in the /opt/SAS/SASTKInDatabaseServer/9.4/TeradataonLinux/install/pgm directory of the Teradata database server.
Run the dq_install.sh shell script to create the stored procedures. For more information, see Creating the Data Quality Stored Procedures. Then, run dq_grant.sh to grant users access to the stored procedures. See Granting Users Authorization to the Data Quality Stored Procedures.
For information about dq_uninstall.sh, see Removing the Data Quality Stored Procedures from the Database.
The dq_install.sh, dq_uninstall.sh, and dq_grant.sh shell scripts must be run as the root user.
Copyright © SAS Institute Inc. All rights reserved.