Installing or Uninstalling PMML Scoring UDFs - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
apa1503087321277.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
Users of the Teradata Profiler product may skip this section.

The Teradata Data Set Builder for SAS and Analytic Data Set (ADS) Generator products, and products that are built upon them, offer Predictive Model Markup Language (PMML) scoring functions that require that certain User Defined Functions (UDFs) be installed in Teradata.

  1. Execute the Install or Uninstall UDFs program item in the Teradata Warehouse Miner program group.

    This program creates the UDFs by locating the Teradata Client Utility BTEQ. If it exists on the system, you can proceed with the load. Otherwise, an error occurs.

  2. You will be prompted to select which UDF install or uninstall function to perform and to enter the Hostname, Userid, Password and Database (which should be the Metadata Database) to load the UDFs into.

    This requires an appropriate entry in the Hosts file to connect properly. See Executing Teradata Client Utilities. The BTEQ utility is then invoked to create all of the necessary UDFs.

    Any existing UDFs with the same names will be replaced during the execution of the PMML install function.
  3. If the UDFs fail to install properly, even though the BTEQ utility, Hosts file entry, and proper database permissions are all in place, an alternative method of installation can be attempted. From the command line, change the current directory:

    cd <TWM product directory>\Scripts\UDF Install and Scripts

  4. Issue the following command: InstallUdfs -c ASCII.

    This will lead to the prompts described above.