Saltar al contenido principal
Learn how to build the future of AI at Possible 2025.Register now

Connect to Teradata VantageCloud Using DBeaver and SSO (Browser Logon)

Overview​

This guide demonstrates how to connect to Teradata VantageCloud using DBeaver with secure browser-based SSO authentication.

This method uses the Teradata JDBC driver and the LOGMECH=BROWSER setting to enable a federated login experience, commonly used in enterprise environments.

It also provides recommended DBeaver settings to optimize the experience for Teradata users familiar with SQL Assistant.

Prerequisites​

  • Access to a Teradata VantageCloud instance configured for browser-based SSO

  • A valid enterprise login (e.g., @company.com credentials)

  • DBeaver installed (Community or PRO version)

    Download from DBeaver Community or DBeaver PRO

Create a Teradata Connection with SSO​

  1. Open DBeaver and click the plug icon (Add Connection Plug Icon) in the upper left, or navigate to Database -> New Database Connection.

  2. In the Select your database screen, type teradata, select the Teradata connector, and click Next.

    Select Teradata connector

  3. Change Connect by value from Host to URL.

  4. In the JDBC URL field, paste the following URL (replace the YOUR-TERADATA-HOST to your VantageCloud host):

Replace <YOUR-TERADATA-HOST> with the hostname of your Teradata gateway or VantagCloud environment.

Important: Do NOT enter a username or password. Authentication will occur through your browser.

JDBC Connection Settings

  1. Click Test Connection.

  2. If prompted, download and install the Teradata JDBC driver. (You may not be prompted if the driver is already installed from previous use.)

Browser Login

  1. A browser window will open and redirect you to your organization's SSO login page. Log in with your enterprise credentials.

  2. Once authenticated, a browser window will open and close very quickly with the following message:

Authentication Complete

  1. DBeaver should confirm a successful connection. Click OK and then Finish.

Connection Test

DBeaver is now able to connect to Teradata!

Running Teradata Queries in Dbeaver​

To begin querying:

  • Right-click your Teradata connection and select Connect
  • Open a new SQL script window and write your query.

Connect

Click the upper orange arrow to execute the SQL query, or press Command + Return (macOS) or Ctrl + Enter (Windows).

Query

Disable "Blank line is statement delimiter"​

Prevents DBeaver from ending queries at empty lines.

Navigate to:

Window -> Preferences -> Editors -> SQL Editor -> SQL Processing -> Delimiters ->

Set Blank line is a statement delimiter to Never.

SQL Processing Settings

Disable Removal of Trailing Query Delimiters​

Ensures semicolons are preserved when queries are executed.

Navigate to: Window -> Preferences -> Editors -> SQL Editor -> SQL Processing -> Delimiters

Uncheck Remove trailing query delimiter.

SQL Processing Settings

Enable Line Numbers​

Navigate to: Window -> Preferences -> Editors -> Text Editors

Check Show line numbers.

Enable Line Numbers

Disable Insert Table Aliases​

Navigate to:

Window -> Preferences -> Editors -> SQL Editor -> Code Completion

Set Insert table aliases to N/A.

Table Aliases

Use Column Names Instead of Labels​

Navigate to:

Window -> Preferences -> Editors -> Data Editor

Check Use column names instead of column labels.

Column Names

How-to​

Display the Sum, Min, Max, etc. of a Column​

After running a query, click the Calc button under the Panels menu on the right side of the Answer Set.

Calc

You may see existing calculations such as Count. Click the plus (+) sign to add more.

Add Calculation

Change Shortcut Keys​

To reassign keyboard shortcuts (e.g., run a query with F5 instead of Ctrl+Enter):

  1. Go to Window → Preferences
  2. Search for Keys in the search bar and select Execute SQL query
  3. In the Binding section:
    • Remove Ctrl+Enter
    • Press the desired key (e.g., F5)
    • Click Apply and Close

Change Shortcut Keys

FAQ​

QuestionAnswer
How do I copy both headers and data from results?Select the data, press Ctrl+Shift+C, then click OK
How can I get all rows of data from a query?DBeaver limits results to 2k rows by default. Right-click the results and select Read All Rows or change the limit in settings Select ALL Rows in Query
How do I duplicate a connection?Right-click the existing connection and choose Copy/Paste
How do I run multiple DDL/DML statements?Use Execute SQL Script instead of Execute SQL Query
How do I change the date format in results?Teradata defaults to YYYY-MM-DD. To change formats, follow DBeaver’s Managing Data Formats guide
How can I run parameterized SQL queries (prompted SQL)?Go to Editors → SQL Editor → SQL Processing, then enable:
• Anonymous SQL parameters
• Enable parameters in DDL and $$..$$ blocks

Example: SELECT * FROM my_table WHERE column = :PARAM;
How do I rename a connection?Right-click the connection and choose Rename

Summary​

This guide demonstrated how to connect to Teradata Vantage using browser-based SSO in DBeaver. This method enables secure enterprise login without manually entering credentials. It also provided recommended DBeaver settings to optimize the experience for Teradata users familiar with SQL Assistant.

También de interés