Connecting to Teradata

This section contains details for Teradata connections.

General information

FieldDescription
Data sourceTeradata
Supported versions16.20.00.13
Connection stringjdbc:teradata://
Packaged?

Yes

Certified?

Yes

Supported features
Pushdown

No

Estimate job

Yes

Analyze data

Yes

Schedule

Yes

Processing capabilities
Pushdown

No

Spark agent

Yes

Yarn agent

Yes

Parallel JDBC

Yes

Java Platform version compatibility
JDK 8

Yes

JDK 11

Yes

Minimum user permissions

In order to bring your Teradata data into Collibra Data Quality & Observability, you need the following permissions.

  • Read access on your Teradata database tables.
  • ROLE_ADMIN assigned to your user in Collibra DQ.

Recommended and required connection properties

RequiredConnection PropertyTypeValue

Yes

NameTextThe unique name of your connection. Ensure that there are no spaces in your connection name.

Yes

Connection URLString

The connection string path of your Teradata connection.

When referring to the example below, replace the ${value} sections of the connection URL with your actual value.

Example jdbc:teradata://${host}/database

Yes

Driver NameString

The driver class name of your Teradata connection.

com.teradata.jdbc.TeraDriver

Yes

PortInteger

The port number to establish a connection to the datasource.

The default port is 0

No

Source NameStringN/A

No

Target AgentOptionThe Agent that submits your Spark job for processing.

Yes

Auth TypeOption

The method to authenticate your connection.

Note The configuration requirements are different depending on the Auth Type you select. See Authentication for more details on available authentication types.

Yes

Driver PropertiesString

The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true

Add the following driver property: RBAC=USR_RBAC_CCB_PDQOWL_INTL

Authentication

This data source supports the following authentication type:

Username/Password

RequiredFieldDescription

Yes

UsernameThe username of your Teradata account.

Yes

PasswordThe password of your Teradata account.