The Teradata connector allows data to be cataloged, queried, transformed and to create tables in Teradata. This can be used to quickly and easily join data between different systems like Teradata and Hive, or between different Teradata instances.

The Teradata connector is available for all the Promethium Enterprise plan.

Connect Teradata

Connecting to Teradata is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select Teradata and enter the information for your Teradata.

Teradata Connection

Teradata connection details can be case-sensitive. Ensure that data is entered with the correct case for your Teradata.

Field

Description

Data Source Name

Give the Teradata connection a unique name for easy identification.

Description

Optional. A meaningful description for this connection.

Host Name

Enter the host name for your Teradata database. For example: db.company.com

DB Port

Enter the port number for your Teradata database.

User Name

Enter the username associated with your Teradata account.

Password

Enter the password associated with your Teradata account.

Data Source Topic

Optional. Categorize the Teradata connection. For example, Marketing.

What Happens Next - Finish Teradata Connection

Click the Connect button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your Teradata, then make the data easily searchable and usable.

Click Data Explorer from the menu and begin exploring the data in your Teradata database.

Teradata Data Catalog Promethium

FAQs

  • Is my data moved or copied out of Teradata?

    No. Your data stays in Teradata and isn't moved to Promethium.

  • What options are available for publishing datasets?

    Datasets can be published as a view, as a table in Teradata or as a dbt model.

  • Is this a Production-level connector?

    Yes. The Teradata connector is designed for all-sized Datasets.

Watch how to video

Did this answer your question?