Teradata Connections
You can create connections to your Teradata instance from Alteryx Analytics Cloud (AAC).
Supported Environments:
Read: Supported.
Write: Not 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 keywordTOP
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
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 AAC can use them to connect to the database. |
Advanced options: Default Column Data Type Inference | Set to |
Advanced options: Enable SSH Tunneling | If available, the SSH tunneling options allow you to configure SSH tunneling authentication between AAC and your database. Note SSH tunneling is available on a per-connection basis. It may not be available for all connections. For more information, see Configure SSH Tunnel Connectivity. |
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 AAC 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 |
<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"
Using Teradata Connections
Uses of Teradata
AAC can use for the following tasks:
Create datasets by reading from tables.
Before you begin using Teradata
Read Access:
Your administrator must configure read permissions.
Writing to Teradata
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.