Enable Teradata Connections

This section provides information on how to enable connection to Teradata databases. 

• Teradata provides Datawarehousing & Analytics solutions and Marketing applications. The Teradata database supports all of their Datawarehousing solutions. For more information, see http://www.teradata.com.

• For more information on supported versions, see Enable Relational Connections.

Download and Install Teradata drivers

To enable connectivity, you must download and install the Teradata drivers into an accessible location on the Alteryx® node.

Steps:

1. If you don't have a Teradata developer account, create one here: https://developer.teradata.com/user/register
2. Log in to the account. Navigate to http://downloads.teradata.com/download/connectivity/jdbc-driver
3. Download the JDBC driver in ZIP or TAR form.
4. Copy the downloaded ZIP or TAR file to the Alteryx node.
5. Extract and place the two JAR files into a folder accessible to the Alteryx user.
6. Verify that the Alteryx user is the owner of both of these JAR files and their parent folder.
7. You can apply this change through the Admin Settings Page (recommended) or trifacta-conf.json. For more information, see Platform Configuration Methods.
8. Locate the data-service.classpath. To the classpath value for the drivers directory:
   1. Add a prefix of :.
   2. Add a suffix of /*.
9. Example:

   1. Was:

      /opt/trifacta/drivers/

   2. Updated:

      :/opt/trifacta/drivers/*

10. Whole classpath example:

    1. Was:

       "data-service": { ...
       "classpath": "%(topOfTree)s/services/data-service/build/libs/data-service.jar:%(topOfTree)s/services/data-service/build/conf:%(topOfTree)s/services/data-service/build/dependencies/*"

    2. Updated:

       "data-service": { ...
       "classpath": "%(topOfTree)s/services/data-service/build/libs/data-service.jar:%(topOfTree)s/services/data-service/build/conf:%(topOfTree)s/services/data-service/build/dependencies/*:/opt/trifacta/drivers/*"

11. Save your changes and restart the platform.

Increase Read Timeout

Particular when reading from large Teradata tables, you might experience read timeouts in the Designer Cloud application. 

The default setting is 300 seconds (5 minutes). You should consider raising this limit if you are working with large tables.

For more information, see Configure Photon Running Environment. 

Create Teradata Connection

After you have installed the Teradata drivers, you can create connections to Teradata datastores. These sources are accessed by creating a JDBC connection to them. 

• If you have not done so already, you must enable basic JDBC-based relational connections. See Enable Relational Connections.
• You can create a Teradata connection in one of the following ways:
  • Through the Designer Cloud application. See Create Connection Window.
  • Through the Alteryx Command Line Interface. See CLI for Connections.

Testing

Steps:

1. After you create your connection, load a small dataset based on a table in the connected Teradata database. See Import Data Page. 
2. Perform a few simple transformations to the data. Run the job. See Transformer Page.
3. Export the results. See Export Results Window.
4. Verify the results.

For more information, see Verify Operations.