Teradata Vantage Setup Guide Partner-Built In Dev

Follow the steps in this guide to connect Teradata Vantage to Fivetran.

NOTE: This destination is partner-built. For any questions related to the Teradata Vantage destination connector and its documentation, contact Teradata Vantage by raising an issue in the Teradata Vantage Fivetran destination GitHub repository.

Prerequisites

• A Teradata Vantage instance. If you need a test instance of Teradata Vantage, you can provision one for free at https://clearscape.teradata.com
• A Teradata Vantage database user with the following permissions:
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • CREATE
  • ALTER
  • CREATE DATABASE (if database configuration is not specified)
• A Fivetran account with the Create Destinations or Manage Destinations permissions.

Setup instructions

Complete Fivetran configuration

1. Log in to your Fivetran account.

2. Go to the Destinations page, and then click + Add Destination.

3. Enter a Destination name for your destination, and then click Add.

4. Select Teradata as the destination type.

5. Specify the following configuration details for you Teradata Vantage workspace/cluster:

   • host
   • username
   • password
   • database
   • tmode
   • logmech

6. (Optional) Enable SSL and specify SSL configuration details.

   When using SSLMODE as VERIFY-CA or VERIFY-FULL, a PEM file containing Certificate Authority (CA) certificates is required. It is mandatory to modify this PEM file by replacing all newline characters with \n and converting it into a single string, you can use the following Python program:

   with open("<existing PEM file location>", "r") as f:
      pem_content = f.read()
    escaped_pem = pem_content.replace("\n", "\\n")
   with open("<modified PEM file location>", "w") as f:
     f.write(escaped_pem)
   

   The modified file will now contain the certificate as a single string. This string can be passed to the "SSL Server's Certificate" field when adding a newTeradata Destination.

7. (Optional) Specify additional Driver Parameters. Refer to Teradata Vantage documentation for a list of supported parameters.

8. Click Save & Test.

Fivetran tests and validates the Teradata Vantage connection configuration. Once the connection configuration test is successful, you can sync your data using Fivetran connectors to the Teradata Vantage destination.