Skip to main content
Port 1025 carries a plain session. Any SSL mode moves the session to 443, where it runs over the gateway’s WebSocket endpoint, and that port cannot be changed. A native Swift driver handles both, with no client library to install.
Teradata connection form

The Teradata connection form

Quick setup

Click Create Connection…, select Teradata, enter the host, username, and password, and click Save & Connect. Any Vantage system that accepts a TD2 logon works; no version is checked. The driver is not in the app. Picking in the Choose a Database sheet offers the download before the form opens, and opening a saved connection installs it without asking. Settings > Plugins > Browse > installs it up front. See Plugins.

Connection settings

Leave Transaction Mode on DEFAULT, which takes whatever the system is configured for, unless a script needs ANSI or TERA case sensitivity and commit rules on the session. A system reachable only through a bastion works over an SSH tunnel.

Connection URL

Import from URL… accepts the scheme; macOS does not route teradata:// links. See Connection URL Reference.

Databases and objects

A database and a user are both namespaces in Teradata, and both appear as top-level databases in the sidebar with their tables and views inside. A tab bound to a second database keeps the same session: DATABASE "name" runs ahead of its statements instead of a reconnect. Identifiers are quoted with double quotes. Teradata has no LIMIT, so a table’s first page comes back with TOP and later pages with QUALIFY ROW_NUMBER().

SSL/TLS

Test TLS on Required (skip verify) rather than Preferred, or a failed handshake looks like a successful connect.

Limitations

  • Foreign keys are never listed. The Structure tab’s Foreign Keys view stays empty for Teradata; read the constraints from its DDL view instead.
  • Macros and stored procedures are not in the sidebar. Query them from the editor.
  • LDAP, Kerberos, and JWT logon fail before the connect is attempted. Use TD2 or TDNEGO.
  • The TLS port is fixed at 443.

Troubleshooting

unsupported: logon mechanism …; only TD2 and TDNEGO are supported

Logon Mechanism holds something the driver does not implement. Set it to TD2 or TDNEGO. A value the driver does not recognize, a mechanism typed in lowercase included, is read as TD2 instead.

Cannot reach the server

The connect gives up after 20 seconds. Confirm the host, and that port 1025 is open from your network, or 443 if an SSL mode is set.

Logon fails

Check the username and password, and that the account is not locked.