Configure Teradata as Destination

1. Log in to the Fivetran Dashboard with valid credentials.
2. Navigate to Destinations in the left menu.
3. Click on Add destination.
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 Documentation for a full list of supported options. 7. Click Save and Test. Ensure the connection test is successful before proceeding.