Configure a Teradata Vantage connection in DBeaver
Author: Adam Tworkiewicz
Last updated: Septeber 12th, 2022
Access to a Teradata Vantage instance.
If you need a new instance of Vantage, you can install a free version called Vantage Express in the cloud on Google Cloud, Azure, and AWS. You can also run Vantage Express on your local machine using VMware, VirtualBox, or UTM.
DBeaver installed. See DBeaver Community or DBeaver PRO for installation options.
Add a Teradata connection to DBeaver
Start the new connection wizard by clicking on the plug icon () in the upper left corner of the application window or go to
Database → New Database Connection.
Select your databasescreen, start typing
teradataand select the Teradata icon.
On the main tab, you need to set all primary connection settings. The required ones include
With DBeaver PRO, you can not only use the standard ordering of tables but also hierarchically link tables to a specific database or user. Expanding and collapsing the databases or users will help you navigate from one area to another without swamping the Database Navigator window. Check the
Show databases and users hierarchicallybox to enable this setting.
In many environments Teradata Vantage can only be accessed using the TLS protocol. When in DBeaver PRO, check
Use TLS protocoloption to enable TLS.
Optional: SSH tunneling
If your database cannot be accessed directly, you can use an SSH tunnel. All settings are available on the
SSH tab. DBeaver supports the following authentication methods: user/password, public key, SSH agent authentication.