Teradata

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)

The Teradata source connector supports the following sync modes:

Feature	Supported?
Full Refresh Sync	Yes
Incremental Sync	Yes
Replicate Incremental Deletes	No
Replicate Multiple Streams (distinct tables)	Yes
Namespaces	No (separate connection is needed for different databases)

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

Log into your Airbyte Open Source account.
Click Sources and then click + New source.
On the Set up the source page, select Teradata from the Source type dropdown.
Enter the Name for the Teradata connector.
For Host, enter the host domain of the Teradata instance
For Database, enter the database name (equivalent to schema in some other databases).
For User and Password, enter the database username and password.
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.

Version	Date	Pull Request	Subject
0.1.0	2022-03-27	https://github.com/airbytehq/airbyte/pull/24221	New Source Teradata Vantage