Advanced Analytica Advanced Analytica: IBOM
← All connectors
Teradata logo

Source connector

Teradata

Set up Teradata as a source and move its data into your chosen destination.

Version 0.2.7 community alpha

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:

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

Get started

Requirements

You need a Teradata user with read permissions for the database.

Setup guide

Set up the Teradata source connector

  1. Log in to your Airbyte Open Source account.

  2. Click Sources, 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 Teradata instance’s host domain.

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

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

  8. 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
VersionDatePull RequestSubject
0.2.72026-10-0788282Fix JDBC URL built when a port is configured (host/DBS_PORT=<port>); previously every connection with a port failed with UnknownHostException
0.2.62025-07-1062926Convert to new gradle build flow
0.2.52025-01-1051485Use a non root base image
0.2.42024-09-0545158Fix bug in source teradata
0.2.32024-12-1849894Use a base image: airbyte/java-connector-base:1.0.0
0.2.22024-02-1335219Adopt CDK 0.20.4
0.2.12024-01-2434453bump CDK version
0.2.02023-12-18https://github.com/airbytehq/airbyte/pull/33485Remove LEGACY state
0.1.02022-03-27https://github.com/airbytehq/airbyte/pull/24221New Source Teradata Vantage
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.