Configure Teradata as Destination

Teradata Developer Guides

ft:locale
en-US
ft:lastEdition
2026-08-18
  1. Log in to Fivetran Dashboard with valid credentials.
  2. Navigate to Destinations from the left menu.
  3. Click on Add destination. fivetran_add_destination.png
  4. Search for and select Teradata.
  5. Provide a name for the destination and click Add.
  6. Enter the required connection details.
  7. Host: Provide the Teradata instance hostname
  8. Logon Mechanism: TD2
  9. Username: Teradata username
  10. Password: Teradata password
  11. Database: Target database name
  12. Transaction Mode: Select ANSI or TERA

##### Optional Connection Parameters

You can provide additional JDBC or destination-specific parameters to customize the connection. These fields are optional and may not be required for all environments:

##### SSL Mode: Controls the SSL encryption level. Common values:

 - `DISABLE`: No SSL
 - `ALLOW`: SSL if available
 - `REQUIRE`: Enforce SSL
 - `VERIFY_CA`: Enforce SSL and validate certificate authority
 - `VERIFY_FULL`: Enforce SSL, validate certificate authority, and perform hostname verification

##### JDBC Parameters: For example:

 - `CHARSET=UTF8`: Sets the character encoding.
 - `ENCRYPTDATA=TRUE`: Enables data encryption in transit.
 - Refer to [Teradata JDBC Driver](https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html) Documentation for a full list of supported options.
 ![fivetran_setup_teradata.png](../images/fivetran_setup_teradata.png)
  1. Click Save and Test. Ensure the connection test is successful before proceeding.