Teradata System Compatibility | Teradata Data Mover - Database Compatibility - Teradata Data Mover

Teradata® Data Mover Compatibility Matrix

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.xx
17.xx
16.xx
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
vmo1585854456434.ditamap
dita:ditavalPath
ft:empty
dita:id
zra1585854093975
Database Version Data Mover
20.00 and 20.01 17.20+ 17.12+ 17.11 17.10 17.05.00.01 17.05 17.00 16.20+
VantageCloud Lake Yes
Analytics Database 17.20 Yes Yes Yes
Analytics Database 17.10+ Yes Yes Yes Yes Yes Yes
Analytics Database 17.05+ Yes Yes Yes Yes Yes Yes Yes
Analytics Database 17.00+ Yes Yes Yes Yes Yes Yes Yes Yes
  • Data Mover 16.20.00 comes installed with ARC 16.20.00.02. However, ARC 16.20.00.02 is not compatible with Analytics Database 16.20. You must perform an in-place upgrade to ARC 16.20.00.04 or upgrade to Data Mover 16.20.12.00 or later. See KB0023567 at https://support.teradata.com.
  • Support for Teradata Database 16.xx.xx.xx has been dropped for all versions of Data Mover.

Data Mover 20.00.00.00 and 20.01.00.00 Supported Copy Methods

Source Database Target Database
VantageCloud Lake Analytics Database 17.20 Analytics Database 17.10 Analytics Database 17.05 Analytics Database 17.00
VantageCloud Lake
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.20
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.10
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.05
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.00
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T

Data Mover 17.20.00.00+ Supported Copy Methods

Source Database Target Database
VantageCloud Lake Analytics Database 17.20.01.03 Analytics Database 17.20 Analytics Database 17.10 Analytics Database 17.05 Analytics Database 17.00 Analytics Database 16.20+ Teradata Database 16.10+
VantageCloud Lake -
  • TPT
  • JDBC
  • T2T
- - - - - -
Analytics Database 17.20.01.03
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.20 -
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.10 -
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.05 -
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.00 -
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 16.20+ -
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Teradata Database 16.10+ -
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
​​For database versions earlier than 16.00, DSA is only available when the force_utility is specified as DSA.
To copy data to or from VantageCloud Lake, you need Data Mover 17.20.01.03 or later.

Data Mover 17.12.00.00+ Supported Copy Methods

Source Database Target Database
Analytics Database 17.20 Analytics Database 17.10 Analytics Database 17.05 Analytics Database 17.00 Analytics Database 16.20+ Teradata Database 16.10+ Teradata Database 15.10+
Analytics Database 17.20
  • DSA*
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.10
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.05
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.00
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 16.20+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Teradata Database 16.10+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Teradata Database 15.10+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
Data Mover 17.12.01.00 does not support the use of DSA as a copy method for source/target Analytics Database 17.20 with Cloud Bridge. You can disable the Cloud Bridge feature to use DSA. For database versions earlier than 16.00, DSA is only available when the force_utility is specified as DSA.

Data Mover 17.05.00.01, 17.10, 17.11, and 17.12 Supported Copy Methods

Source Database Target Database
Analytics Database 17.10 Analytics Database 17.05 Analytics Database 17.00 Analytics Database 16.20+ Teradata Database 16.10+ Teradata Database 15.10+
Analytics Database 17.10
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.05
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.00
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 16.20+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Teradata Database 16.10+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Teradata Database 15.10+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
​For database versions earlier than 16.00, DSA is only available when the force_utility is specified as DSA.

Data Mover 17.05.00.00 Supported Copy Methods

Source Database Target Database
Analytics Database 17.05 Analytics Database 17.00 Analytics Database 16.20+ Teradata Database 16.10+ Teradata Database 15.10+
Analytics Database 17.05
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 17.00
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Analytics Database 16.20+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Teradata Database 16.10+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
Teradata Database 15.10+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • ARC is no longer supported as a copy method as of Data Mover 17.00.
  • For database versions earlier than 16.00, DSA is only available when the force_utility is specified as DSA.

Data Mover 17.00 Supported Copy Methods

Source Database Target Database
Analytics Database 17.00 Analytics Database 16.20+ Teradata Database 16.10+ Teradata Database 15.10+ Teradata Database 15.00+
Analytics Database 17.00
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
Analytics Database 16.20+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
Teradata Database 16.10+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
Teradata Database 15.10+
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
Teradata Database 15.00+
  • DSA
  • TPT
  • JDBC
  • DSA
  • TPT
  • JDBC
  • DSA
  • TPT
  • JDBC
  • DSA
  • TPT
  • JDBC
  • DSA
  • TPT
  • JDBC
  • ARC is no longer supported as a copy method as of Data Mover 17.00.
  • The QueryGrid Teradata to Teradata (T2T) connector is supported in Teradata Database 15.10.00 or later.
  • For database versions earlier than 16.00, DSA is only available when the force_utility is specified as DSA.

Data Mover 16.20 Supported Copy Methods

Source Database Target Database
Analytics Database 16.20+ Teradata Database 16.10+ Teradata Database 15.10+ Teradata Database 15.00+ Teradata Database 14.10+
Analytics Database 16.20+
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • TPT
  • JDBC
Teradata Database 16.10+
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • TPT
  • JDBC
Teradata Database 15.10+
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • ARC
  • DSA
  • TPT
  • JDBC
  • T2T
  • TPT
  • JDBC
  • TPT
  • JDBC
Teradata Database 15.00+
  • ARC
  • DSA
  • TPT
  • JDBC
  • DSA
  • TPT
  • JDBC
  • DSA
  • TPT
  • JDBC
  • DSA
  • TPT
  • JDBC
  • TPT
  • JDBC
Teradata Database 14.10+
  • ARC
  • DSA
  • TPT
  • JDBC
  • ARC
  • DSA
  • TPT
  • JDBC
  • ARC
  • DSA
  • TPT
  • JDBC
  • ARC
  • DSA
  • TPT
  • JDBC
  • ARC
  • DSA
  • TPT
  • JDBC
  • Data Mover 16.20 comes installed with ARC 16.20.00.02. However, ARC 16.20.00.02 is not compatible with Analytics Database 16.20. You must perform an in-place upgrade to ARC 16.20.00.04 or upgrade to Data Mover 16.20.12.00 or later. See KB0023567 at https://support.teradata.com.
  • The QueryGrid Teradata to Teradata (T2T) connector is supported in Teradata Database 15.10.00 or later.
  • For database versions earlier than 16.00, DSA is only available when the force_utility is specified as DSA.