The TDP variant of TPT uses the channel-attached CLI to interface with the Analytics Database, which requires a channel connection.
The Gateway variant of TPT uses the network-attached CLIv2 to interface with the Analytics Database, which uses the Database Gateway software.
The following table shows differences between the two variants:
| For | TDP Variant | Gateway Variant |
|---|---|---|
| Access to Analytics Database on a cloud | No with direct channel connection | Yes |
| Channel connection | Yes, required | No |
| CLIv2 | Uses channel-attached CLI | Uses network-attached CLIv2 |
| CLIv2 error codes | Uses channel-attached CLI error codes | Uses network-attached CLIv2 error codes |
| Connection string | Not supported | Supported |
| Interface with Gateway software | No | Yes |
| Longer session connection time | No | Possibly |
| <hlq>.ETC.IPNODES member file | Not needed | Yes, required |
| Display of variant in a TPT log | CLIv2 TDP | CLIv2 GTW |
| Supported SQL Engine versions | All supported versions | 17.10.00.00 or later 17.05.05.03 or later 16.20.53.31 or later |
The Gateway variant of TPT can take a longer time to connect sessions, because there is more overhead between the network-attached CLIv2 and the Database Gateway software for authentication and encryption. This overhead does not exist in the TDP variant of TPT.
The Gateway variant of TPT requires COP entries in the <hlq>.ETC.IPNODES member file. The entries must define the IP address and COP alias name for each database node. <hlq> is the site defined high level qualifier data set name.
The TDP variant does not use the <hlq>.ETC.IPNODES member file.
Using the Gateway variant of TPT against un-supported Analytics Database versions might cause unexpected results.
Teradata recommends upgrading to a supported Analytics Database version.