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)
Refer to this guide for more details
Supported sync modes
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) |
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
-
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.
Changelog
Expand to review
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 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 |