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 Connection Types.

This connection supports reading and writing. You can create multiple Teradata connections in the 

Limitations

• By default, Teradata does not permit the publication of datasets containing duplicate rows. Workarounds:

  • Your final statement for any recipe that generates results for Teradata should include a Remove duplicate rows transformation. 
    
    

    Info
    NOTE: The above transformation removes exact, case-sensitive duplicate rows. Teradata may still prevent publication for case-insensitive duplicates.

  • It's possible to change the default writing method to Teradata to enable duplicate rows. For more information, contact 

    D s support

    . 

Download and Install Teradata drivers

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

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 

   D s node

   .
5. Extract and place the two JAR files into a folder accessible to the 

   D s item
   item user

   .
6. Verify that the 

   D s item
   item user

    is the owner of both of these JAR files and their parent folder.

7. D s config

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:

      Code Block
      /opt/trifacta/drivers/

   2. Updated:

      Code Block
      :/opt/trifacta/drivers/*

10. Whole classpath example:

    1. Was:

       Code Block
       "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:

       Code Block
       "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 

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

For more information on creating a Teradata connection, see Create Connection Window.

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. Verify the results.

For more information, see Verify Operations.