Teradata
Set up the Teradata source connector using this guide.
Prerequisites
To use the Teradata source connector, you’ll need:
-
Access to a Teradata Vantage instance
Note: If you need a new Vantage instance, install the free Vantage Express version in the cloud. It’s available on Google Cloud, Azure and AWS. You can also run Vantage Express locally using VMware, VirtualBox or UTM.
You’ll need this information to configure the Teradata source:
- Host - The host name of the Teradata Vantage instance.
- Username
- Password
- Database - Specify the database. This is equivalent to the schema in some databases, such as database_name.table_name, when running 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 these 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) |
Performance considerations
Get started
Requirements
You need a Teradata user with read permissions for the database.
Setup guide
Set up the Teradata source connector
-
Log in to your Airbyte Open Source account.
-
Click Sources, 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 Teradata instance’s host domain.
-
For Database, enter the database name. This is equivalent to the schema in some other databases.
-
For User and Password, enter the database username and password.
-
To customise the JDBC connection beyond common options, enter additional supported JDBC URL parameters in the JDBC URL Params field. Add them as key-value pairs separated by the symbol &.
Example: key1=value1&key2=value2&key3=value3
AirByte adds these parameters to the end of the JDBC URL used to connect to your Teradata database.
IP allow list
If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.
Changelog
Expand to review
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 0.2.7 | 2026-10-07 | 88282 | Fix JDBC URL built when a port is configured (host/DBS_PORT=<port>); previously every connection with a port failed with UnknownHostException |
| 0.2.6 | 2025-07-10 | 62926 | Convert to new gradle build flow |
| 0.2.5 | 2025-01-10 | 51485 | Use a non root base image |
| 0.2.4 | 2024-09-05 | 45158 | Fix bug in source teradata |
| 0.2.3 | 2024-12-18 | 49894 | Use a base image: airbyte/java-connector-base:1.0.0 |
| 0.2.2 | 2024-02-13 | 35219 | Adopt CDK 0.20.4 |
| 0.2.1 | 2024-01-24 | 34453 | bump CDK version |
| 0.2.0 | 2023-12-18 | https://github.com/airbytehq/airbyte/pull/33485 | Remove LEGACY state |
| 0.1.0 | 2022-03-27 | https://github.com/airbytehq/airbyte/pull/24221 | New Source Teradata Vantage |