Supported Copy Methods Between Database Software Versions - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

Teradata to Teradata

Supported operating systems, supported Teradata Database versions, and product version numbers for all Teradata Tools and Utilities are available (at http://www.info.teradata.com) in a single spreadsheet titled Teradata Tools and Utilities Supported Platforms and Product Versions, B035-3119.

The following table lists the Teradata utilities supported for copying data from a source Teradata Database system of the version indicated to a target Teradata Database system of the version indicated.

Table specifications:
  • QueryGrid T2T is supported in Teradata Database 15.00.01 or later.
Teradata Database Source System Teradata Database Target System
  16.10 16.00 15.10 15.00 14.10
16.10
  • ARC
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
16.00
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
15.10
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
15.00
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
14.10
  • ARC
  • TPT
  • JDBC
  • ARC
  • TPT
  • JDBC
  • ARC
  • TPT
  • JDBC
  • ARC
  • TPT
  • JDBC
  • ARC
  • TPT
  • JDBC

Between Teradata and Hadoop

The following tables list supported software versions for copying data between Teradata Database and Hortonworks Data Platform for commodity hardware and Teradata Appliance for Hadoop (HDP), MapR, and Cloudera Hadoop (CDH) systems.

Table specifications:

  • Includes commodity hardware and Teradata Appliance for Hadoop.
  • HDP 2.3–HDP 2.5 and CDH 5.4–CDH 5.9 support systems using the Kerberos protocol.
  • T2H supports QueryGrid versions 1.x and 2.x and is available for Teradata Database 15.00 or later.
  • QueryGrid T2H does not support Teradata Database 16.00 Unicode Pass Through and 1 MB row features. TDCH does not support the Teradata Database 16.00 1 MB row feature. TDCH 1.5 or later supports the Teradata Database 16.00 Unicode Pass Through feature.
Teradata to Hadoop
Teradata Database Source System Teradata Database Target System
  MapR HDP CDH
  4.x and 5.x 2.5, 2.4, and 2.3 5.9, 5.8, 5.7, and 5.4
16.10
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
16.00
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
15.10
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
15.00
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
14.10
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
Hadoop to Teradata
Teradata Database Source System Teradata Database Target System
  16.10 16.00 15.10 15.00 14.10
HDP 2.5, 2.4, and 2.3
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
CHD 5.9, 5.8, 5.7, and 5.4
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
MapR 4.x and 5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x

Between Teradata and Aster

The following tables list supported software for copying data between Teradata Database and Teradata Aster systems.
Teradata to Aster
Teradata Database Source System Teradata Aster Target System
  6.20 6.10 6.00
16.10 No Support No Support No Support
16.00 No Support No Support No Support
15.10 Aster SQL-MR No Support No Support
15.00 Aster SQL-MR Aster SQL-MR No Support
14.10 Aster SQL-MR Aster SQL-MR Aster SQL-MR
Aster to Teradata
Teradata Aster Source System Teradata Database Target System
  16.10 16.00 15.10 15.00 14.10
6.20 No Support No Support Aster SQL-MR Aster SQL-MR Aster SQL-MR
6.10 No Support No Support No Support Aster SQL-MR Aster SQL-MR
6.00 No Support No Support No Support No Support Aster SQL-MR