To install the Analytics Library, run the installation scripts supplied with the product using the instructions in the readme.txt file on the installation media.
Contact https://support.teradata.com with any installation issues.
Access Rights for Installation
The following statements grant the rights needed to install the Analytics Library, where dbname is the name of the database on which to install the UDFs and username or rolename is the administrator USER or ROLE who is to perform the installation.
GRANT CREATE FUNCTION ON dbname TO { username | rolename }; GRANT ALTER FUNCTION ON dbname TO { username | rolename }; GRANT EXECUTE PROCEDURE ON SQLJ.REMOVE_JAR TO { username | rolename }; GRANT EXECUTE PROCEDURE ON SQLJ.INSTALL_JAR TO { username | rolename }; GRANT EXECUTE PROCEDURE ON SQLJ.REPLACE_JAR TO { username | rolename }; GRANT CREATE EXTERNAL PROCEDURE ON dbname TO { username | rolename };
Access Rights for Use
If the Analytics Library is not installed in a publicly available account or database on the Teradata Vantageā¢ Analytics Database, each USER or ROLE who needs to run the analytic functions needs the rights granted by the following statements. stats_dbname is the database where the Statistical Test Tables are installed.
GRANT EXECUTE PROCEDURE ON dbname.td_analyze TO { username | rolename }; GRANT EXECUTE FUNCTION ON dbname.tda_dt_calc TO { username | rolename }; GRANT EXECUTE FUNCTION ON dbname.tda_kmeans TO { username | rolename }; GRANT SELECT ON stats_dbname TO { username | rolename };