Teradata Vantage Setup Guide Partner-Built Private Preview

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

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 user account with permissions to create or manage destinations

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.

Related articles

description Destination Overview

settings API Destination Configuration

home Documentation Home