5.4.6 - In-Database Analytic Function Setup - Teradata Warehouse Miner

In-Database Analytic Functions User Guide

prodname
Teradata Warehouse Miner
vrm_release
5.4.6
created_date
November 2018
category
User Guide
featnum
B035-2306-118K
Run the following GRANT statements as necessary prior to performing the UDF installation, where dbname is the name of the database where you want to install the UDFs:
GRANT CREATE FUNCTION ON <dbname> to <dbname>;
GRANT ALTER FUNCTION ON <dbname> to <dbname>;
GRANT EXECUTE PROCEDURE on SQLJ.REMOVE_JAR to <dbname>;
GRANT EXECUTE PROCEDURE on SQLJ.INSTALL_JAR to <dbname>;
GRANT EXECUTE PROCEDURE on SQLJ.ALTER_JAVA_PATH to <dbname>;
GRANT CREATE EXTERNAL PROCEDURE ON <dbname> to <dbname>;

To install the UDFs required by the TWM In-Database Analytic Functions, run the Install or Uninstall UDFs program item in the TWM group, selecting the Install TD_Analyze Udfs option and supplying the logon information including Hostname, User ID, Password, and Database into which to install the UDFs.

The Install or Uninstall UDFs program creates and installs the UDFs using the BTEQ which must be installed on the client system. BTEQ requires an entry in the Hosts file to connect properly. For information on executing Teradata client utilities, see Teradata Warehouse Miner User Guide: Volume 1, Introduction and Profiling (B035-2300).