All Products
Search

This Product

    Dataphin:Create a Teradata data source

    Document Center

    Dataphin:Create a Teradata data source

    Last Updated:Jun 23, 2026

    Create a Teradata data source to enable Dataphin to read business data from or write data to Teradata.

    Background information

    Teradata is a large-scale data warehouse system. To use Teradata with Dataphin for data development or to export Dataphin data to Teradata, you must first create a Teradata data source. For more information, see Teradata official website.

    Permissions

    Only custom global roles with the Create Data Source permission and system roles such as super administrator, data source administrator, domain architect, and project administrator can create data sources.

    Procedure

    1. In the top navigation bar of the Dataphin homepage, choose Management Center > Datasource Management.

    2. On the Datasource page, click +Create Data Source.

    3. On the Create Data Source page, in the Relational Database section, select Teradata.

      If you have recently used Teradata, you can also select it from the Recently Used section, or search for it by entering keywords in the search box.

    4. On the Create Teradata Data Source page, configure the connection parameters.

      1. Configure the basic information of the data source.

        Parameter

        Description

        Datasource Name

        The name must meet the following requirements:

        • It can contain only Chinese characters, letters, digits, underscores (_), or hyphens (-).

        • It cannot exceed 64 characters in length.

        Datasource Code

        The data source code lets you reference tables in Flink_SQL tasks by using the data source code.table name or data source code.schema.table name format. To automatically access the data source based on the current environment, use the variable format ${data source code}.table or ${data source code}.schema.table. For more information, see Dataphin data source table development method.

        Important

        • The data source code cannot be modified after it is configured.

        • You can preview data on the object details page in the asset directory and asset checklist only after the data source code is configured.

        • In Flink SQL, only MySQL, Hologres, MaxCompute, Oracle, StarRocks, Hive, SelectDB, and GaussDB data warehouse service (DWS) data sources are currently supported.

        Data Source Description

        A brief description of the data source. It cannot exceed 128 characters.

        Data Source Configuration

        Select the data source to configure:

        • If your business data source distinguishes between production and development data sources, select Production + Development Data Source.

        • If your business data source does not distinguish between production and development data sources, select Production Data Source.

        Tag

        You can categorize data sources using tags. For information about how to create tags, see Manage data source tags.

      2. Configure the connection parameters between the data source and Dataphin.

        If you select Production + Development data source, configure the connection information for both environments. If you select Production data source, configure the connection information for the production environment only.

        Note

        Typically, production and development data sources should use separate configurations for environment isolation. However, Dataphin also supports configuring them as the same data source with identical parameter values.

        Parameter

        Description

        JDBC URL

        The format of the connection URL is jdbc:teradata://host:port/dbname.

        Username, Password

        The username and password used to log on to the Teradata database.

      3. Configure advanced settings for the connection between the data source and Dataphin.

        Connection Retries: The number of automatic retry attempts when a database connection times out. If the connection still fails after all retries, it is considered failed.

        Note

        • The default number of retries is 1, and you can configure a value between 0 and 10.

        • The retry count applies by default to offline integration tasks and global quality (requires the asset quality module to be enabled). You can also configure task-level retry counts separately in offline integration tasks.

    5. Select a Default Resource Group to run tasks for this data source, such as database SQL, offline migration, and data preview.

    6. Click Test Connection or click OK to save the Teradata data source.

      Test Connection verifies that the data source can connect to Dataphin. If you click OK directly, the system automatically tests the connection for all selected clusters, but the data source is created even if all selected clusters fail to connect.