Connect Teradata data with any data source.

Teradata is a multi-cloud data platform for enterprise analytics companies that provides solutions for business challenges from beginning to end. With Teradata, you have the ability to manage large and varied data workloads now and in the future. The company offers data platforms, applications, and services for data warehousing and analytics.

Load data into Teradata Read the docs

Sources: 590+
Standard support: 1.0.0

Overview

What is the Airbyte Teradata connector?

The Airbyte Teradata connector loads data from 590+ Airbyte sources into Teradata, with full refresh and incremental sync on a schedule you control.

01
Load from any source
Move data into Teradata from 590+ Airbyte sources on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
Cloud or self-hosted
Run the Teradata connector on OSS.

Setup

Live in nine steps

First, navigate to the Airbyte website and log in to your account.
Once you are logged in, click on the "Destinations" tab on the left-hand side of the screen.
Scroll down until you find the Teradata destination connector and click on it.
You will be prompted to enter your Teradata database credentials, including the host, port, username, and password.
Once you have entered your credentials, click on the "Test Connection" button to ensure that Airbyte can successfully connect to your Teradata database.
If the connection is successful, click on the "Save" button to save your Teradata destination connector settings.
You can now create a new pipeline in Airbyte and select Teradata as your destination connector.
Follow the prompts to configure your pipeline and map your source data to your Teradata database.
Once your pipeline is configured, you can run it to start transferring data from your source to your Teradata database.

Configuration fields

Teradata configuration fields
Field	Type	Description
host*	string	Hostname of the database.
disable_type_dedupe	boolean	Disable Writing Final Tables. WARNING! The data format in _airbyte_data is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
drop_cascade	boolean	Drop tables with CASCADE. WARNING! This will delete all data in all dependent objects (views, etc.). Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.
jdbc_url_params	string	Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
logmech	object	Not documented.
query_band	string	Defines the custom session query band using name-value pairs. For example, 'org=Finance;report=Fin123;'
raw_data_schema	string	The database to write raw tables into
schema	string	The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public".

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Teradata connector questions

What data can I load into Teradata with Airbyte?

Airbyte moves data from any supported source into Teradata on a schedule you control, with full refresh and incremental sync where the destination supports it.

Does the Teradata connector support incremental sync?

Yes. The Teradata destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.

Where can I run the Teradata connector?

Run the Teradata connector on OSS.

Didn't find your answer? Talk to sales