Configure a Teradata Vantage connection in DBeaver
Overview
This how-to demonstrates how to create a connection to Teradata Vantage with DBeaver.
Prerequisites
- Access to a Teradata Vantage instance.
Remarque
If you need a test instance of Vantage, you can provision one for free at https://clearscape.teradata.com
- 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
. -
On
Select your database
screen, start typingteradata
and select the Teradata icon. -
On the main tab, you need to set all primary connection settings. The required ones include
Host
,Port
,Database
,Username
, andPassword
.AstuceIn Teradata Vantage, when a user is created a corresponding database with the same is created as well. DBeaver requires that you enter the database. If you don't know what database you want to connect to, use your username in the
database
field.AstuceWith 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 hierarchically
box to enable this setting.AstuceIn many environments Teradata Vantage can only be accessed using the TLS protocol. When in DBeaver PRO, check
Use TLS protocol
option to enable TLS. -
Click on
Finish
.
Optional: Logon Mechanisms
The default logon mechanism when creating a DBeaver connection is TD2. To add other logon mechanisms, follow the steps below:
-
Navigate to the database menu and click on Driver Manager.
-
From the list of driver names, select Teradata and click "Copy".
-
In the "URL Template" field, define your selected logon mechanism.
jdbc:teradata://\{host}/LOGMECH=LDAP,DATABASE=\{database},DBS_PORT=\{port}
-
Click "OK".
-
The new driver is now available to create connections with the selected logon mechanism.
-
The process for setting up a new connection with the alternative mechanism is the same as described above for adding a new connection.
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.
Summary
This how-to demonstrated how to create a connection to Teradata Vantage with DBeaver.
If you have any questions or need further assistance, please visit our community forum where you can get support and interact with other community members.