Teradata Connections

You can create connections to your Teradata instance from the Designer Cloud Powered by Trifacta platform.

Supported Environments:

Operation	Designer Cloud Powered by Trifacta platform	Amazon	Microsoft Azure
Read	Supported	Supported	Supported
Write	Supported	Supported	Supported

Limitations

Tables inside the DBC database are not listed due to technical constraints; however you can access the tables through custom SQL.
Custom SQL is supported. The Custom SQL should be in the following format:
```
SELECT * FROM <DATABASE_NAME>.<Table_NAME>;
```
- When using custom SQL, the keyword LIMIT is not supported by Teradata. Use the keyword TOP to get the required number of rows similar to the following:
```
SELECT TOP <NUMBER_OF_ROWS> * FORM <DATABASE_NAME>.<TABLE_NAME>;
```
In theConnect String Options, the parameters must be separated by commas:
```
Database=DBC,DBC_PORT=1025
```

Prerequisites

Additional setup is required. For more information, see Enable Teradata Access.

Create Teradata Connection

To create this connection, in the Connections page, select the Databases tab. Click the Teradata card. See Connections Page.

Modify the following properties as needed:

Property	Description
Host	Enter the host name of Teradata. Example value: buick1.teradata.ws
Port	Set this value to the port number through which to access Teradata. By default, this values is set to 1025.
Connect String Options	(Optional) You can specify additional options used to connect as a string value. Connect string options are submitted in the following format: option1=value1,option2=value2
Enable Data Encryption	When enabled, the data exchanged between the Teradata JDBC driver and the database is encrypted.
User Name	The username used to connect.
Password	The password associated with the username.
Test Connection	After you have defined the connection credentials type, credentials, and connection string, you can verify that the Trifacta Application can use them to connect to the database.
Advanced options: Default Column Data Type Inference	Set to `disabled` to prevent the product from applying its own type inference to each column on import. The default value is `enabled`.
Advanced options: Enable SSH Tunneling	This feature is not available.
Connection Name	Display name of the connection.
Connection Description	(Optional) Description of the connection, which appears in the application.

Connection URL

The properties that you provide are inserted into the following URL, which connects the Designer Cloud Powered by Trifacta platform to the connection:

jdbc:teradata://<host>/DBS_PORT=<port>,<connect-string-options>

where:

Parameter	Description
<host>	Host URL of the database server.
<port>	Port number for the database server. Typically, this value is `1025` for Teradata.
<connect-string-options>	Connect string options, which are submitted in the following format: option1=value1,option2=value2

Parameter

Description

<host>

Host URL of the database server.

<port>

Port number for the database server. Typically, this value is 1025 for Teradata.

<connect-string-options>

Connect string options, which are submitted in the following format:

option1=value1,option2=value2

The Connection URL is mostly built up automatically using cluster configuration for the platform.

Use Data Encryption

When Data Encryption is enabled for the connection, the following is automatically appended to the connect string options:

,ENCRYPTDATA=ON

Driver Information

This connection uses the following driver:

Driver name: com.teradata.jdbc.TeraDriver
Driver version: com.teradata:terajdbc4:17.00.00.03
Driver documentation: https://developer.teradata.com/connectivity/reference/jdbc-driver

Create via API

This connection can also be created using the API.

"vendor": "teradata",
"vendorName": "Teradata",
"type": "jdbc"

For more information, see https://api.trifacta.com/ee/9.7/index.html#operation/createConnection

Using Teradata Connections

Uses of Teradata

The Designer Cloud Powered by Trifacta platform can use for the following tasks:

Create datasets by reading from tables.

Writing back to Teradata.

Before you begin using Teradata

Read Access:

Your administrator must configure read permissions.

Writing to Teradata

Supported.

SQL Syntax

The following syntax requirements apply to this connection.

Object delimiter: double-quote or no delimiter

Example syntax:

Double quotes can be used around database names, table names, or column names.

Note that references to specific values must be single-quoted for columns of String data type.

SELECT "column1","column2" FROM "databaseName"."tableName" WHERE "column3" = 'my_value';

For more information on SQL in general, see Supported SQL Syntax.

In this section: