Integrations
Breadcrumbs

Generic JDBC - Teradata

Support

Support from 16.20 to 20.0

Configuration

Vendor

TERADATA

Connection format

The connection URL format is

jdbc:teradata://<database_host>:<port>/<params>

In some cases the port or database may be a problem and the URL can be used in this format jdbc:teradata://<database_host>/DATABASE=<databse>,DBS_PORT=<port>

Permissions

User or role with SELECT permissions on the databases, tables, or views from which metadata is to be extracted or a data sample obtained.

If the table contains UDTs, it will be necessary for the user to also have permissions on the corresponding procedures (SYSUDTLIB.X, where X is the procedure name)

Metadata extraction

Below is the Teradata documentation showing the various fields extracted from tables *:

https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html

Important → For some column types, the length observed in the table may differ from the one extracted by Anjana; please refer to the documentation indicated above.