Supported Copy Methods Between Database Software Versions - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.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 to Teradata
Teradata Database Source System Teradata Database Target System
  16.00 15.10 15.00 14.10 14.00
16.00
  • ARC
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • TPT
  • JDBC
15.10
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • TPT
  • JDBC
15.00
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • ARC
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • TPT
  • JDBC
14.10
  • ARC
  • TPT
  • JDBC
  • ARC
  • TPT
  • JDBC
  • ARC
  • TPT
  • JDBC
  • ARC
  • TPT
  • JDBC
  • TPT
  • JDBC
14.00
  • 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), or Cloudera Hadoop (CDH) systems.

Table specifications:

  • Includes commodity hardware and Teradata Appliance for Hadoop.
  • HDP 2.3 and CDH 5.4 also support systems using the Kerberos protocol.
  • SQL-H is the supported QueryGrid utility prior to Teradata Database 15.00.
  • QueryGrid T2H support for Teradata Databases 15.10 and later, utilizing Teradata Database 15.00 connectors.
  • 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
Source System Target System
Teradata Database MapR HDP CDH
  4.x and 5.x 2.4 2.3 2.2 5.8 5.7 5.4
16.00
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
15.10
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
15.00
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • T2H
14.10
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
14.00
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
Hadoop to Teradata
Source System Target System
  Teradata Database
  16.00 15.10 15.00 14.10 14.00
HDP 2.4
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • TDCH 1.5.x
HDP 2.3
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • TDCH 1.5.x
HDP 2.2
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
CDH 5.8
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
CDH 5.7
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
  • TDCH 1.5.x
CDH 5.4
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • T2H
  • TDCH 1.5.x
  • 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
Source System Target System
Teradata Database Teradata Aster
  6.20 6.10 6.00
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
14.00 Aster SQL-MR Aster SQL-MR Aster SQL-MR
Aster to Teradata
Source System Target System
Teradata Aster Teradata Database
  16.00 15.10 15.00 14.10 14.00
6.20 No Support Aster SQL-MR Aster SQL-MR Aster SQL-MR Aster SQL-MR
6.10 No Support No Support Aster SQL-MR Aster SQL-MR Aster SQL-MR
6.00 No Support No Support No Support Aster SQL-MR Aster SQL-MR