- Log in to Fivetran Dashboard with valid credentials.
- Navigate to
Destinationsfrom the left menu. - Click on
Add destination. - Search for and select
Teradata. - Provide a name for the destination and click
Add. - Enter the required connection details.
Host: Provide the Teradata instance hostnameLogon Mechanism: TD2Username: Teradata usernamePassword: Teradata passwordDatabase: Target database nameTransaction Mode: SelectANSIorTERA
##### 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.

- Click
Save and Test. Ensure the connection test is successful before proceeding.