Description:
Overview:
=========
TIBCO ActiveMatrix Adapter for ActiveDatabase version 6.1 now includes support of Teradata Database when using TeraJDBC and Teradata ODBC drivers against Teradata Database version 12.x and 13.0, 13.1.


Support Limitations:
====================
The following features are not supported for Teradata Database:

  -Publisher load balancing.

  -Fault tolerance

  -INTERVAL datatype.

Triggers can not be deleted after deleting Publication service. Use Teradata Administrator to drop the triggers as the workaround.

Request-Response service can not reply detailed data record.

The publishing table name can not be longer than 18 characters.


Support Requirements:
=====================
Clients must use the Teradata JDBC driver and Teradata ODBC drivers provided by Teradata. These are either downloadable or are contained in the Teradata Tools and Utilities package that comes as part of the Teradata Database license.

JDBC:

Teradata JDBC Driver 13.10.00.10

ODBC:

Windows-i386 version 13.10.00.01

         Windows 2003

LINUX-version 13.10.00.01

         RHEL 5.3

Solaris-SPARC version 13.10.00.01

         Solaris 10

Solaris-x86 13.10.00.01

         Solaris 10 x86

HP-UX-PA version 13.10.00.01

         HPUX 11i

HP-UX-ia64 version 13.10.00.01

         HPUX Itanium

AIX-Power version 13.10.00.01

         AIX 5.3


Installation and Configuration:
===============================
Follow the instructions of TIBCO ActiveMatrix Adapter for Database Installation and TIBCO ActiveMatrix Adapter for Database Configuration and Deployment to install and configure the adapter. The additional settings are as follows:

All Platforms:
  Use Teradata Administrator to modify the property of column ADB_ERROR_TIME as ADB_ERROR_TIME TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) instead of ADB_ERROR_TIME TIMESTAMP(6) NOT NULL in Exception table script.

Microsoft Windows:
  
  check the Run in Quiet Mode option in DSN configuration.

UNIX:

-HPPA: add '--enable-readline=no' option when building unixODBC project.
        (command as: ./configure --prefix=/home/adb/unixODBC --enable-readline=no  --enable-gui=no)

-Itanium: DSN must be configured with 64-bit driver at: /opt/teradata/client/13.10/odbc_64/lib/tdata.so

-solaris (64-bit): use Teradata odbc_32 library instead of odbc_64 library.

-AIX: execute the following steps before it works.

       1. Export unixODBC lib path and Teradata lib path to LIBPATH environment variable.
          (Command for example, run: export LIBPATH=/adapters/trdtqa/unixODBC/lib:/opt/teradata/client/ODBC_32/lib)

       2. Archive the Teradata file odbcinst.so into file libodbcinst.a which is in unixODBC lib.
          (command for example, run: ar  -v –q  ~/unixODBC/lib/libodbcinst.a   /opt/teradata/client/ODBC_32/lib/odbcinst.so)


Known Issues:
=============
AADB-3484
Summary:    When executing stored procedure, the Request-Response service returned the following error message:
            Syntax error, expected something like '(' between the word 'ADBSP_InsWithoutPara' and ';'.

Workaround: In TIBCO Designer, modify the default value of Request-Response service AESchma SQL property from {call ADBSP_InsWithoutPara} to {call                        ADBSP_InsWithoutPara()}.

TIBCO ActiveMatrix (R) Adapter for ActiveDatabase version 6.1 now includes support of Teradata Database when using TeraJDBC and Teradata ODBC drivers against Teradata Database version 12.x and 13.0, 13.1.