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

In-Database Analytic Functions User Guide

prodname
Teradata Warehouse Miner
vrm_release
5.4.5
created_date
February 2018
category
User Guide
featnum
B035-2306-028K
Run the following GRANT statements prior to performing the UDF installation, where dbname is the name of the database where you want to install the UDFs:
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>;

To install the UDFs required by the Miner In-Database Analytic Functions, execute the Install or Uninstall UDFs program item in the Miner group, selecting the Install TD_Analyze Udfs option and supplying the login 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. See Executing Teradata Client Utilities in the Volume 1 of the Teradata Warehouse Miner User Guide.