Download Teradata JDBC Driver

Download the Teradata JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Teradata JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Teradata. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Teradata driver uses its own syntax — see the connection details below.

The Teradata JDBC driver

Teradata is an enterprise-class parallel relational database designed for very large data warehouses and analytical workloads. It is widely used in retail, finance, and telecommunications for multi-petabyte BI and predictive analytics at scale.

The Teradata JDBC URL

• Required File(s): terajdbc4.jar, tdgssconfig.jar
• Java Driver Class: com.teradata.jdbc.TeraDriver
• JDBC URL: jdbc:teradata://HOST/DBS_PORT=PORT
• Website: Teradata

Download Teradata JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager. You can also download the official JDBC driver from the Teradata website.

Connecting to a Teradata System

Teradata's URL is unlike the others: parameters go after the host as comma-separated NAME=value pairs rather than as a path and a query string.

1. Start with the host alone. jdbc:teradata://host connects on the default port, 1025, to the user's default database. That is enough for a first connection.
2. Add the port and database only if you need them. The Custom Port / Database entry in the Connection Mode combo builds jdbc:teradata://host/DBS_PORT=1025,DATABASE=mydb. Note the syntax — a slash, then NAME=value pairs separated by commas. A colon and a port number after the host, as most other JDBC URLs use, is not valid here.
3. Expect COP name resolution. Teradata clients traditionally resolve hostcop1, hostcop2 and so on to spread sessions over the nodes. Where those names are not in DNS, connect to a node address directly.
4. Open port 1025 in the server's firewall. The database listens on port 1025 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
5. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

DbSchema and Teradata

DbSchema connects to Teradata using the TeraDriver and renders primary index definitions, partitioning, and PI/SI relationships in the schema diagram. Use the SQL Editor to write Teradata-specific SQL including BTEQ-style macros and volatile tables.