Page tree

Release 8.7.1


Contents:

   

Contents:




You can create connections to your  Teradata  instance from  Designer Cloud Powered by Trifacta® Enterprise Edition

Supported Environments:

Operation

Designer Cloud Powered by Trifacta Enterprise Edition

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteSupportedSupportedSupported


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 the Connect String Options, the parameters must be separated by commas:

     

    Database=DBC,DBC_PORT=1025

Prerequisites

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:

PropertyDescription
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.


Enable Data Encryption

When enabled, the data exchanged between the Teradata JDBC driver and the database is encrypted.

User NameThe username used to connect.
PasswordThe password associated with the username.
Test Connection

After you have defined the connection credentials type, credentials, and connection string, you can verify that the Designer Cloud application  can use them to connect to the database.

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.

Connection NameDisplay 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  Designer Cloud Powered by Trifacta Enterprise Edition to the connection:

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

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:

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/8.7/index.html#operation/createConnection

Using Teradata  Connections

Uses of  Teradata

Designer Cloud Powered by Trifacta Enterprise Edition 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.

This page has no comments.