Create a Teradata Connection with SSO

1. Open DBeaver and click the 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.

1. Change Connect by value from Host to URL.

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

jdbc:teradata://<YOUR-TERADATA-HOST>/LOGMECH=BROWSER,BROWSER_TAB_TIMEOUT=0 

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.

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.)

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:

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

DBeaver is now able to connect to Teradata!

ssh -i ~/.ssh/tunneluser_key.pem \
  -L 1025:<Teradata-INTERNAL-IP>:1025 \
  -N <SSH-USER>@<JUMP-SERVER>

ssh -i "$env:USERPROFILE\.ssh\tunneluser_key.pem" `
  -L 1025:<TERADATA-INTERNAL-IP>:1025 `
  -N <SSH-USER>@<JUMP-SERVER>