Teradata

Requirements:

  • Data Hub v9.0 or later

  • Teradata version:

    • 16.20

    • 16.10

    • 15.10

    • 15.00

    • 14.10

Add the Teradata data source

A Teradata data source can be added to a new or existing data model.

Add a Teradata data source to an existing data model:

  1. Open an existing Data Model from RESOURCE EXPLORER.

  2. Expand Data Sources.

  3. Click Add Data Source.

Select source

In the Select Source step:

  1. Under the Databases section, select Teradata.

  2. From the source type pop-up, click Connect on the Teradata entry tagged Data Source.

Connect

To set up the connection between Data Hub and Teradata:

  1. Complete the following fields:

    1. Server - Use the server name if the Teradata server is on the same network as the Data Hub server. Otherwise, a fully-qualified domain name (FQDN) is required.

    2. UserName - Enter a valid Teradata user name with access to the target Server and Database.

    3. Password - Provide the corresponding password for the Teradata user name.

    4. Database - Type the Teradata database name, or select the database from the drop-down list.

  2. Click Test Connection to verify that Data Hub can connect to the Teradata database with the credentials provided.

  3. Click Next to continue to the Select Data step.

Select data

To add tables from the Teradata database to the data model:

  1. Select tables to be added as pipelines using the check box column.

  2. To add the pipelines to the data model, there are three options:

    1. Use Add Pipelines to add tables as individual pipelines.

    2. Select the Add Pipeline as Union of Tables option from Add Pipelines drop-down, to add a single pipeline created from a union of the selected tables.

    3. Click Finish to add tables as individual pipelines and finalise adding the Teradata data source.

      Note

      If all of the tables in the data source are selected, the pipeline will always perform a union on all tables from the data source, even if the table list changes. For example, if the data source contains only tables of sales for USA, UK, and Europe, selecting them all will union the three tables into a single pipeline. If a fourth table with sales for Australia is later added, it will automatically be included in the union for the pipeline.

  3. If Finish was not used to add pipelines, click Finish to complete adding the Teradata data source.

Select Data screen elements

The Select Data screen contains the following elements:

  1. Select All/Clear

    1. If no table check boxes are currently selected, Select All can be used to select all tables in the source database.

    2. If any check boxes are selected, clear (x) can be used to clear all selected tables.

  2. Show selected tables only - Hides all tables where the check box column is currently cleared (not selected).

  3. Hide tables without rows - Hides all source tables that do not contain data.

  4. Add Pipelines - Select Add Pipelines to add all selected tables to the data model as individual pipelines. The drop-down menu provides two options:

    1. Add Pipelines performs the same function as Add Pipelines.

    2. Add Pipeline as Union of Tables creates a single pipeline from the union of the selected tables from this data source.

      Note

      If all of the tables in the data source are selected, the pipeline will always perform a union on all tables from the data source, even if the table list changes. For example, if the data source contains only tables of sales for USA, UK, and Europe, selecting them all will union the three tables into a single pipeline. If a fourth table with sales for Australia is later added, it will automatically be included in the union for the pipeline.

  5. Finish - Adds the selected tables as individual pipelines and finalizes adding the Teradata data source. Once the request has been processed, Data Hub opens the Data Model Overview.

  6. The filter row - The first row of the Select Data table is the filter row. Use the fields to filter rows based on the column contents. To clear all filters entered, either delete the entered text or use the Clear filter icon at the end of the row.

  7. The Select Data step table - A table showing the tables present in the data source.

Select Data table columns

The Teradata Select Data table contains the following columns:

  • The check box column - Select to create a pipeline for this source table.

  • Table - The database table name.

  • Relationships - Shows source tables that share a relationship with the current table. These relationships join the tables, allowing for easier report building.

In this section: