ODBC driver supports the deterministic behavior from Teradata database for Pref er/Allow SSL mode. This enhances the utilization of port selection used for database connection.During the process of connecting to a Teradata database, ODBC driver receives information of which port (for example, HTTPS or TDMST) the database actively listens to. Based on this information, there are 3 possible scenarios of information received from the Teradata database:
- TDMST port enabled and HTTPS port disabled ODBC driver, SSLMode=Allow or SSLMode=Prefer
ODBC driver consistently connects to the TDMST port or returns an error.
- HTTPS port enabled & TDMST port disabled ODBC driver, SSLMode=Allow or SSLMode=Prefer
ODBC driver consistently connects to the HTTPS port or returns an error.
- Both TDMST and HTTPS ports enabled
- ODBC driver, SSLMode=Allow
ODBC driver connects to the TDMST port or returns an error indicating that the TDMST port is enabled, but the driver fails to connect to it.
- ODBC driver, SSLMode=Prefer
ODBC driver connects to the HTTPS port or returns an error indicating that the HTTPS port is enabled, but the driver fails to connect to it.
- ODBC driver, SSLMode=Allow
The deterministic behavior of Prefer/Allow SSL mode is dependent on the TLS setting of Teradata Gateway. Currently there are four modes, namely disable, enable, require and nolegacy, that the Teradata Gateway can be set to. You can run the following commands to check or change the setting:
- tdatcmd
- gtwcontrol -h
- gtwcontrol --TLS [disable|enable|require|nolegacy][,trace=yes|no|all]