Teradata

Note

We have a detailed howto for your first steps with SQL databases in DSS.

You might want to start with that Howto. The rest of this page is reference information for Teradata.

DSS supports the full range of features on Teradata:

  • Reading and writing datasets
  • Executing SQL recipes
  • Performing visual recipes in-database
  • Using live engine for charts

Installing the JDBC driver

The Teradata JDBC driver can be downloaded from Teradata website.

The driver is made of two JAR files:

  • terajdbc4.jar
  • tdgssconfig.jar

To install:

  • Copy both JAR files to the lib/jdbc driver of DSS
  • Restart DSS

Connecting using LDAP authentication

By default, the Teradata connector uses the TD2 authentication mechanism. To use other kinds of authentication mechanism, enable the “Use custom JDBC URL”.

Enter “jdbc:teradata://YOUR-TERADATA-HOSTNAME/” as both the “connection URL” and “displayed URL”.

Add Advanced JDBC properties as documented in the Teradata JDBC driver documentation.

To login using LDAP, add the following properties:

  • LOGMECH = LDAP
  • LOGDATA = username@@password

Using per-user-credentials with LDAP authentication

First, get familiar with per-user-credentials: Connections security

Switch the connection to “per-user credentials mode”. Then add the following properties:

  • LOGMECH = LDAP
  • LOGDATA = %{pucUser}@@%{pucPassword}

The %{pucUser} and %{pucPassword} will be replaced by the per-user-credential login and password at runtime.