Supported Copy Methods | Teradata Data Mover - Supported Copy Methods between Database Software Versions - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
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 https://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:
  • The QueryGrid Teradata to Teradata (T2T) connector is supported in Teradata Database 15.10.00 or later.
  • For Teradata Database versions earlier than 16.00, DSA is only available when the force_utility is specified as DSA.
Teradata Database Source System Teradata Database Target System
  16.20 16.10 15.10 15.00
16.20
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
16.10
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
15.10
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
15.00
  • ARC
  • DSA
  • TPT
  • JDBC
  • ARC
  • DSA
  • TPT
  • JDBC
  • ARC
  • DSA
  • TPT
  • JDBC
  • ARC
  • DSA
  • 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.4–HDP 2.6, CDH 5.4–CDH 5.9, and CDH 5.11–CDH 5.15 support systems using the Kerberos protocol.
  • QueryGrid Teradata to Hadoop (T2H) supports QueryGrid version 2.x.
  • QueryGrid Teradata to Hadoop (T2H) connector 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 Target System
  MapR

4.x and 5.x

HDP

2.6, 2.5, and 2.4

CDH

5.15, 5.14, 5.13, 5.12, 5.11, 5.9, 5.8, 5.7, and 5.5

16.20
  • TDCH 1.5.4
  • TDCH 1.5.5
  • T2H
  • TDCH 1.5.5
  • T2H
16.10
  • TDCH 1.5.4
  • TDCH 1.5.4
  • T2H
  • TDCH 1.5.4
  • T2H
15.10
  • TDCH 1.5.4
  • TDCH 1.5.4
  • T2H
  • TDCH 1.5.4
  • T2H
15.00
  • TDCH 1.5.4
  • TDCH 1.5.4
  • T2H
  • TDCH 1.5.4
  • T2H
Hadoop to Teradata
Source System Teradata Database Target System
  16.20 16.10 15.10 15.00
HDP 2.6, 2.5, and 2.4
  • TDCH 1.5.5
  • T2H
  • TDCH 1.5.4
  • T2H
  • TDCH 1.5.4
  • T2H
  • TDCH 1.5.4
  • T2H
CHD 5.15, 5.14, 5.13, 5.12, 5.11, 5.9, 5.8, 5.7, and 5.5
  • TDCH 1.5.5
  • T2H
  • TDCH 1.5.4
  • T2H
  • TDCH 1.5.4
  • T2H
  • TDCH 1.5.4
  • T2H
MapR 4.x and 5.x
  • TDCH 1.5.4
  • TDCH 1.5.4
  • TDCH 1.5.4
  • TDCH 1.5.4

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
16.20 Aster SQL-MR
16.10 Aster SQL-MR
15.10 Aster SQL-MR
15.00 Aster SQL-MR
Aster to Teradata
Teradata Aster Source System Teradata Database Target System
  16.20 16.10 15.10 15.00
6.20 Aster SQL-MR Aster SQL-MR Aster SQL-MR Aster SQL-MR