Advanced Analytica Advanced Analytica: IBOM
← All connectors
Teradata Vantage logo

Destination connector

Teradata Vantage

Send governed data into Teradata Vantage with a clear, practical setup guide.

Version 1.0.0 community alpha

Teradata

Set up the Teradata destination connector using this guide.

Prerequisites

To use the Teradata destination 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 destination:

  • Host - The host name of your Teradata Vantage instance.
  • Authorization Mechanism - The Logon Mechanism, which determines the connection’s authentication and encryption capabilities. The default value is TD2. The connector supports TD2, LDAP and BROWSER authentication mechanisms.
  • User - The username for connecting to the Teradata Vantage instance. The user needs permission to create tables and write data.
  • Password - The password for connecting to the Teradata Vantage instance.
  • SSL modes - The connection mode for the database. See Teradata JDBC documentation for more information. Select Enable SSL Connection to use SSL mode.
  • Default Schema Name - The schema, or multiple comma-separated schemas, to set in the search-path. These schemas resolve unqualified object names in statements executed over this connection.
  • JDBC URL Params (optional)
  • Query Band (optional) - The query band is a set of name-value pairs assigned to a Teradata database session. It identifies the source of SQL requests from Airbyte. You can customise the query band with relevant details, including application name, organisation and user identifiers. Format each entry as key=value and separate entries with semicolons (;). Example: appname=myApp;org=myOrganization;

Refer to this guide for more details

Sync overview

Raw table output schema

Each stream maps to a separate raw table in Teradata. By default, raw tables are created in the airbyte_internal schema. You can override this schema in the configuration. Each table contains these columns:

  • _airbyte_raw_id: A unique uuid that Airbyte assigns to each processed event. This is the primary index column. Its Teradata column type is VARCHAR(256).
  • _airbyte_extracted_at: A timestamp showing when the event was pulled from the data source. Its Teradata column type is TIMESTAMP WITH TIME ZONE.
  • _airbyte_loaded_at: A timestamp showing when the row was processed into the final table. Its Teradata column type is TIMESTAMP WITH TIME ZONE.
  • _airbyte_data: A json blob containing the event data. Its Teradata column type is JSON.
  • _airbyte_meta: A json blob containing per-row error and change handling data. Its Teradata column type is JSON.
  • _airbyte_generation_id: A metadata field that increments each time you execute a refresh. Its Teradata column type is BIGINT.

Refer to this guide for more details

Final table data type mapping

Airbyte TypeTeradata Type
stringVARCHAR
numberFLOAT
integerBIGINT
booleanSMALLINT
objectJSON
arrayJSON
timestamp_with_timezoneTIMESTAMP WITH TIME ZONE
timestamp_without_timezoneTIMESTAMP
time_with_timezoneTIME WITH TIME ZONE
time_without_timezoneTIME
dateDATE

Schema map

Performance considerations

Supported sync modes

Sync modeSupported?
Full Refresh - OverwriteYes
Full Refresh - AppendYes
Full Refresh - Overwrite + DedupedYes
Incremental Sync - AppendYes
Incremental Sync - Append + DedupedYes

Get started

Requirements

You need a Teradata user with these permissions:

  • Permission to create tables and write data.
  • Permission to create schemas, for example:

Create this user by running:

CREATE USER airbyte_user  as perm=10e6, PASSWORD=<password>;
GRANT ALL on dbc to airbyte_user;

You can use an existing user. However, creating a dedicated user for Airbyte is strongly recommended.

Setup guide

Set up the Teradata destination connector

  1. Log in to your Airbyte Open Source account.

  2. Click Destinations, then click + New destination.

  3. On the Set up the destination page, select Teradata from the Destination type dropdown.

  4. Enter the Name for the Teradata connector.

  5. For Host, enter the Teradata instance’s host domain.

  6. For Default Schema, enter the Default Schema name. The default value is public.

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

  8. To customise the JDBC connection, enter additional supported JDBC URL parameters in the JDBC URL Params field. Enter them as key-value pairs separated by &. Example: key1=value1&key2=value2&key3=value3

    These parameters are added to the end of the JDBC URL. The AirByte uses this URL to connect to your Teradata database.

  9. To customise the query band, enter a set of name-value pairs in the Query Band field. These pairs can be set for the current database session.

Namespace support

This destination supports namespaces. The namespace maps to a Teradata database.

Changelog

Expand to review
VersionDatePull RequestSubject
1.0.02025-04-03https://github.com/airbytehq/airbyte/pull/56985Upgrade to DV2 output format
0.2.12025-03-26https://github.com/airbytehq/airbyte/pull/56414Migrated unit and integration tests to Kotlin
0.2.02025-03-24https://github.com/airbytehq/airbyte/pull/56362Added LDAP and SSO authentication mechanism
0.1.92025-03-17https://github.com/airbytehq/airbyte/pull/55800Added Query Band Support
0.1.82025-03-14https://github.com/airbytehq/airbyte/pull/55771Migration to Kotlin
0.1.72025-03-07https://github.com/airbytehq/airbyte/pull/55183Upgrade teradata jdbc driver to 20.00.00.43
0.1.62024-06-24https://github.com/airbytehq/airbyte/pull/39455Fix for Parameter 2 length size
0.1.52024-01-12https://github.com/airbytehq/airbyte/pull/33872Added Primary Index on _airbyte_ab_id to fix NoPI issue
0.1.42023-12-04https://github.com/airbytehq/airbyte/pull/28667Make connector available on Airbyte Cloud
0.1.32023-08-17https://github.com/airbytehq/airbyte/pull/30740Enable custom DBT transformation
0.1.22023-08-09https://github.com/airbytehq/airbyte/pull/29174Small internal refactor
0.1.12023-03-03https://github.com/airbytehq/airbyte/pull/21760Added SSL support
0.1.02022-12-13https://github.com/airbytehq/airbyte/pull/20428New Destination 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.