Teradata (3.2)

Owned by Yeok Hong Ng (Deactivated)
Last updated: Jul 28, 2023
1 min read

This section contains information that is specific to the database type Teradata.

Supported Functions

The Teradata database can be used with:

  • Database Table Related Functions (APL)
  • Database Collection Agent
  • Prepared Statements
  • SQL Collection Agents

Preparations

A database driver is required to connect to a Teradata database. This driver must be stored in the Platform. Follow these if Teradata was not set up during the installation of the Platform:

  1. Set up a persistent file system.

  2. A driver, provided by your IBM contact, is required to access the Teradata database. This driver must be stored on a host (Platform) that will connect to an Teradata database.

  3. Copy the Teradata files into the directory MZ_HOME/persistent/3pp on the platform-0 pod.

    Example - Copy the Teradata files into the directory

    $ kubectl cp <jar file> platform-0:/opt/mz/persistent/3pp -n <namespace>

  4. Restart the platform and EC pods.

    Example - Restart the platform and EC pods

    $ kubectl delete pod platform-0 -n <namespace>
  5. Restart the Desktop.