31 Understanding What's Supported for Teradata
This chapter contains information on database and table features supported by Oracle GoldenGate.
Topics:
- Supported Teradata Data Types
- Supported Objects and Operations for Teradata
- Non-Supported Operations for Teradata
Parent topic: Using Oracle GoldenGate for Teradata
Supported Teradata Data Types
The following table shows the Teradata data types that Oracle GoldenGate supports. Any limitations or conditions that apply follow this table.
Data type | v15.x | v16.x |
---|---|---|
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
|
Yes |
Yes |
- Limitations of Support for Numeric Data Types
- Limitations of Support for Single-byte Character Data Types
- Conditions and Limitations of Support for Multi-byte Character Data
- Limitations of Support for Binary Data Types
- Limitations of Support for Large Object Data Types
- Limitations of Support for Date Data Types
- Limitations of Support for IDENTITY Data Types
Parent topic: Understanding What's Supported for Teradata
Limitations of Support for Numeric Data Types
When replicating these data types from a different type of database to Teradata, truncation can occur if the source database supports a higher precision that Teradata does.
The support of range and precision for floating-point numbers depends on the host machine. In general, the precision is accurate to 16 significant digits, but you should review the database documentation to determine the expected approximations. Oracle GoldenGate rounds or truncates values that exceed the supported precision.
Parent topic: Supported Teradata Data Types
Limitations of Support for Single-byte Character Data Types
Single-byte character types are fully supported within a single-byte Latin character set between other databases and Teradata. A VARCHAR
or CHAR
column cannot have more than 32k-1 bytes. If using UTF-16, this is 16k-2 characters.
Parent topic: Supported Teradata Data Types
Conditions and Limitations of Support for Multi-byte Character Data
Conditions and limitations of support for multi-byte character data are as follows:
-
Install Oracle GoldenGate on a Windows or Linux replication server.
-
Use the Teradata ODBC driver version 12.0.0.x or later.
-
Do not use filtering, mapping, and transformation for multi-byte data types.
-
A
CHAR
orVARCHAR
column cannot contain more than 32k-1 bytes. If using UTF-16, these columns cannot contain more than 16k-2 characters. -
Set the ODBC driver to the UTF-16 character set in the initialization file.
-
When creating Replicat groups, use the
NODBCHECKPOINT
option with theADD REPLICAT
command. The Replicat database checkpointing feature does not support an ODBC driver that is set to the UTF-16 character set. Checkpoints will be maintained in the checkpoint file on disk.
Parent topic: Supported Teradata Data Types
Limitations of Support for Binary Data Types
No limitations. These data types are supported between other source databases and Teradata targets.
Parent topic: Supported Teradata Data Types
Limitations of Support for Large Object Data Types
The following are limitations of support for large object data types.
-
To replicate large objects from other databases to Teradata, use Teradata ODBC driver version 12.0 or higher on the target system. The target must support large objects that are delivered by ODBC.
-
Enable the
UseNativeLOBSupport
flag in the ODBC configuration file. See the Teradata ODBC documentation.
Parent topic: Supported Teradata Data Types
Limitations of Support for Date Data Types
The following are limitations of support for date data types:
-
DATE
,TIME
, andTIMESTAMP
are fully supported when replicated from a different type of source database to Teradata. -
TIME with TIMESZONE
,TIMESTAMP with TIMEZONE
, andINTERVAL
are not supported from a different type of source database to Teradata. -
Oracle GoldenGate supports timestamp data from 0001/01/03:00:00:00 to 9999/12/31:23:59:59. If a timestamp is converted from GMT to local time, these limits also apply to the resulting timestamp. Depending on the timezone, conversion may add or subtract hours, which can cause the timestamp to exceed the lower or upper supported limit.
-
Oracle GoldenGate does not support negative dates.
Parent topic: Supported Teradata Data Types
Limitations of Support for IDENTITY Data Types
IDENTITY
must be configured as GENERATED BY DEFAULT AS IDENTITY
on the target to enable the correct value to be inserted by Replicat.
Parent topic: Supported Teradata Data Types
Supported Objects and Operations for Teradata
This section lists the data operations and database objects that Oracle GoldenGate supports.
-
Oracle GoldenGate supports the maximum number of columns per table that is supported by the database.
-
Truncating operations are supported with the use of the
GETTRUNCATES
parameter with Oracle GoldenGate 12.2.x and greater. -
Limitations on Automatic Heartbeat Table support are as follows:
-
The
ALTER HEARTBEATTABLE
command is not supported and if used is ignored. -
The
ADD HEARTBEATTABLE
command with theFREQUENCY
,PURGE_FREQUENCY
, orRETENTION_TIME
option is not supported. When any of these options are specified with theADD HEARTBEATTABLE
command, a warning is displayed that the option is ignored. -
Since Teradata does not have any internal event/job schedulers, automatic purging of heartbeat history data does not occur. You need to explicitly delete or truncate records periodically from the heartbeat history table.
-
Parent topic: Understanding What's Supported for Teradata
Non-Supported Operations for Teradata
This section lists the data operations that Oracle GoldenGate does not support.
-
Extract (capture)
-
DDL
Parent topic: Understanding What's Supported for Teradata