What are the different mechanisms to connect into the Teradata SQL assistant?
Please explain the above mechanisms.
The mechanisms depend on which data provider you use (.Net Data Provider for Teradata or ODBC) and on what version of those products you are using.
For Teradata.Net it would be: TD2 SPEGNO LDAP
For ODBC you would have to check the documentation as that may vary based on the version you are using.
The mechanisms are used by the data providers - SQL Assistant knows nothing about them itself.