Installing IBM SPSS Modeler Server Scoring Adapter for Teradata

If you have a previous version of the scoring adapter for Teradata installed, first you must uninstall it as follows:

  1. Locate the executable file named Uninstall IBM SPSS Modeler Server Scoring Adapter for Teradata in the Teradata scoring adapter's installation directory. It's in a folder named Uninstall IBM SPSS Modeler Server Scoring Adapter for Teradata.
  2. Run the executable file either from the console or by using the graphical user interface (GUI). Follow the instructions in the uninstaller to uninstall the scoring adapter.
  3. If you receive a message that some items could not be removed, go to the root directory where the adapter had been (the cfscoring directory, for example) and run the command rm -rf on the listed directories that were not removed. This will remove them.
  4. Proceed with the following steps to install the new version of the scoring adapter.

Depending on the configuration of your database you can install either from the console or by using a graphical user interface (GUI); however, the first step is the same for both methods:

  • Log in as either root or DBA user and run the install.bin install script. You must have access permissions for the installation folder to do this. The installing user must also have CREATE FUNCTION permissions.

Console Installation

  1. Introduction details are displayed. Press Enter to continue.
  2. Licensing information is displayed. Read the license, type Y to accept it, and press Enter to continue.
  3. You are prompted to type the installation location. The default installation location is shown; however, if your installation is different, type the revised location and press Enter.
  4. Enter the database TDPID. Press Enter to continue.
  5. Enter the user name. Press Enter to continue.
  6. Enter the password. Press Enter to continue.
  7. A pre-installation summary is displayed to confirm your entries so far. Press Enter to continue.
  8. A message is displayed to say the installation routine is ready to run. Press Enter to continue.
  9. A progress bar is displayed whilst the installation routine runs. When the installation is complete, press Enter to exit from the installer.
  10. If the Components table exists in your database a confirmation message is displayed. Either enter Y to continue creating tables and functions in your database, or enter N to skip this step. Note: If you skip this step you must manually create tables and functions later using initdb.sh, which is stored in the <installation path>\setup folder.

GUI Installation

  1. Introduction details are displayed. Click Next to continue.
  2. Licensing information is displayed. Read the license, select the option to accept it, and click Next to continue.
  3. You are prompted to select the installation location. The default installation location is shown; however, if your installation of is different, click Choose to browse for the revised location. When the correct location is shown, click Next.
  4. Enter the database TDPID, name, and password and click Next to continue.
  5. A pre-installation summary is displayed to confirm your entries so far. Click Install to continue.
  6. A progress bar is displayed whilst the installation routine runs. When the installation is complete, click Done to exit from the installer.
  7. If the Components table exists in your database a confirmation message is displayed. Either click Yes to continue creating tables and functions in your database, or click No to skip this step. Note: If you skip this step you must manually create tables and functions later using initdb.sh, which is stored in the <installation path>\setup folder.

When you have completed these steps the scoring adapter is ready to receive work.

Note: The UDFs and COMPONENTS table are installed into the default database of the user who installs the scoring adapter.

Sharing the scoring adapter

To share the scoring adapter for use by other Teradata users:

  1. Grant the following privileges to the user:
    • SELECT and EXECUTE FUNCTION on the database where the scoring adapter is installed.
    • INSERT on the COMPONENTS table on the database where the scoring adapter is installed.
  2. When a database connection is made to Teradata with the scoring adapter installed, open the Database Preset dialog box, enable Use Server Scoring Adapter Schema and select the schema from the Server Scoring Adapter Schema drop down list.
    Note: The Database Preset dialog box varies for different databases and is not supported by scripting; therefore, this step can only be done in SPSS® Modeler Client.

Preventing SQL errors for date or time entries

If the ODBC driver for the Date or Time format is set to Integer, and your input table contains fields that are coded as Date, Time, or Timestamp; Teradata displays a SQL error message and is unable to process those fields.

To prevent this error from happening follow these steps:

  1. Open the ODBC Data Source Administrator.
  2. Open the DSN that uses the Teradata driver.
  3. Click on Options >> to open the Teradata ODBC Driver Options dialog box.
  4. On the top right side of the dialog box, set the Date Time Format to AAA.
  5. Save your changes.
  6. In IBM® SPSS Modeler Server, remove the connection and then reconnect to the DSN that uses the Teradata driver.
Note: On Unix/Linux, the option is called: DateTimeFormat.

Teradata drivers and null datetime_now values

When using the DataDirect Teradata driver, the SQL_COLUMN_TYPE may return a null value. The alternative is to use the native Teradata driver.