Installing SAS Data Quality Accelerator Stored Procedures in the Teradata Database

Overview

The SAS in-database deployment package for Teradata (sepcoretera) installs three scripts in the /opt/SAS/SASTKInDatabaseServerforTeradata/12.00000/install/pgm directory of the Teradata database server:
  • a stored procedure creation script named dq_install.sh
  • a user authorization script named dq_grant.sh
  • a stored procedure removal script named dq_uninstall.sh
You will need to run the dq_install.sh script to create the data quality stored procedures in the Teradata database and the dq_grant.sh script to grant users permission to execute the data quality stored procedures.
The dq_uninstall.sh script is provided to enable you to remove the data quality stored procedures from the database. You must remove any data quality stored procedures that have already been installed from the Teradata database before upgrading or reinstalling either SAS Data Quality Accelerator for Teradata or the SAS Embedded Process.
Note: All three scripts must be run as the root user.

Using the dq_install.sh Script

The dq_grant.sh shell script is provided to enable the Teradata system administrator to grant users authorization to the data quality stored procedures. The dq_install.sh script is located in the /opt/SAS/SASTKInDatabaseServerforTeradata/12.00000/install/pgm directory of the Teradata database server.
The dq_install.sh script requires modification before it can be run. The Teradata administrator must edit the shell script to specify the site-specific Teradata server name and DBC user logon credentials for the DBC_PASS=, DBC_SRVR=, and DBC_USER= variables.
Running dq_install.sh puts the data quality stored procedures into the SAS_SYSFNLIB database and enables the accelerator functionality.
Here is the syntax for executing dq_install.sh:
./dq_install.sh <-l log-path>

log-path

specifies an alternative name and location for the dq_install.sh log. When this parameter is omitted, the script creates a file named dq_install.log in the current directory.

The next step in the installation is to grant users permission to execute the stored procedures.

Using the dq_grant.sh Script

The dq_grant.sh shell script is provided to enable the Teradata system administrator to grant users authorization to the data quality stored procedures. The dq_grant.sh script is located in the /opt/SAS/SASTKInDatabaseServerforTeradata/12.00000/install/pgm directory of the Teradata database server.
The dq_grant.sh script requires modification before it can be run. The Teradata administrator must edit the shell script to specify the site-specific Teradata server name and DBC user logon credentials for the DBC_SRVR=, DBC_USER=, and DBC_PASS= variables.
Here is the syntax for executing dq_grant.sh:
./dq_grant.sh <-l log-path> user-name

log-path

specifies an alternative name and location for the dq_grant.sh log. When this parameter is omitted, the script creates a file named dq_grant.log in the current directory.

user-name

is the user name to which permission is being granted. The target user account must already exist in the Teradata database.

The authorizations granted by dq_grant.sh augment existing authorizations that the target user account already has in the Teradata database.
You can verify that authorization was granted successfully for a user by logging on to the database as the user and issuing the following command:
call sas_sysfnlib.dq_debug();
The command will fail if the user does not have permission. Otherwise, it will have no effect.
The data quality stored procedures are not yet ready to use. A QKB must be installed in the Teradata database for the data quality stored procedures to be usable.
Last updated: February 9, 2017