Skip to main content
connector logo

Teradata

Availability: Airbyte Cloud: ❌, Airbyte OSS: ✅
Support Level: Community
Latest Version: 0.1.0
Definition Id: aa8ba6fd-4875-d94e-fc8d-4e1e09aa2503

This page guides you through the process of setting up the Teradata source connector.

Prerequisites

To use the Teradata source connector, you'll need:

  • Access to a Teradata Vantage instance

    Note: If you need a new instance of Vantage, you can install a free version called Vantage Express in the cloud on Google Cloud, Azure, and AWS. You can also run Vantage Express on your local machine using VMware, VirtualBox, or UTM.

You'll need the following information to configure the Teradata source:

  • Host - The host name of the Teradata Vantage instance.
  • Username
  • Password
  • Database - Specify the database (equivalent to schema in some databases i.e. database_name.table_name when performing queries).
  • JDBC URL Params (optional)
  • SSL Connection (optional)
  • SSL Modes (optional)

Refer to this guide for more details

Supported sync modes

The Teradata source connector supports the following sync modes:

FeatureSupported?
Full Refresh SyncYes
Incremental SyncYes
Replicate Incremental DeletesNo
Replicate Multiple Streams (distinct tables)Yes
NamespacesNo (separate connection is needed for different databases)

Performance considerations

Getting started

Requirements

You need a Teradata user which has read permissions on the database

Setup guide

Set up the Teradata Source connector

  1. Log into your Airbyte Open Source account.

  2. Click Sources and then click + New source.

  3. On the Set up the source page, select Teradata from the Source type dropdown.

  4. Enter the Name for the Teradata connector.

  5. For Host, enter the host domain of the Teradata instance

  6. For Database, enter the database name (equivalent to schema in some other databases).

  7. For User and Password, enter the database username and password.

  8. To customize the JDBC connection beyond common options, specify additional supported JDBC URL parameters as key-value pairs separated by the symbol & in the JDBC URL Params field.

    Example: key1=value1&key2=value2&key3=value3

    These parameters will be added at the end of the JDBC URL that the AirByte will use to connect to your Teradata database.

CHANGELOG

VersionDatePull RequestSubject
0.1.02022-03-27https://github.com/airbytehq/airbyte/pull/24221New Source Teradata Vantage