Dataphin:Create a TDengine data source

Permission requirements

Only custom global roles with the permission to create data sources and users who are assigned the super administrator, data source administrator, domain architect, or project administrator role can create data sources.

Procedure

1. On the Dataphin homepage, click Management Hub > Datasource Management in the top navigation bar.

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

3. On the Create Data Source page, select TDengine in the Big Data section.

   If you have recently used TDengine, you can also select TDengine in the Recently Used section. You can also enter keywords in the search box to quickly search for TDengine.

4. On the Create TDengine Data Source page, configure the basic information of the data source.

   Parameter	Description
   Datasource Name	Enter a name for the data source. The name must meet the following requirements: It can contain only Chinese characters, letters, digits, underscores (_), and hyphens (-). The name can be up to 64 characters in length.
   Datasource Code	After you configure the data source code, you can reference tables in the data source in Flink_SQL tasks using the Data source code.Table name or Data source code.schema.Table name format. To automatically access the data source in the corresponding environment based on the current environment, access the data source using the variable format ${Data source code}.table or ${Data source code}.schema.table. For more information, see Develop Dataphin data source tables. Important The data source code cannot be modified after it is configured successfully. After the data source code is configured successfully, you can preview data on the object details page in the asset directory and asset inventory. In Flink SQL, only MySQL, Hologres, MaxCompute, Oracle, StarRocks, Hive, and SelectDB data sources are currently supported.
   Version	You can select 2.x or 3.x.
   Data Source Description	Enter a brief description of the data source. The description cannot exceed 128 characters.
   Data Source Configuration	Select the data source that you want to configure: If the data source distinguishes between production and development data sources, select Production + Development Data Source. If the data source does not distinguish between production and development data sources, select Production Data Source.
   Tags	You can categorize and tag data sources based on tags. For information about how to create tags, see Manage data source tags.

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

   If you select Production + Development Data Source for Data Source Configuration, you need to configure the connection information for both Production + Development Data Source. If you select Production Data Source, you only need to configure the connection information for the Production Data Source.

   Note

   In most cases, the production data source and development data source should be configured as different data sources to isolate the development environment from the production environment and reduce the impact of the development data source on the production data source. However, Dataphin also supports configuring them as the same data source with identical parameter values.

   1. Configure the parameters in the Cluster Configuration section.

      Parameter	Description
      JDBC URL	Enter the JDBC connection address of the target database. The connection address format is jdbc:TAOS-RS://host:port/dbname.
      Username, Password	Enter the username and password for logging on to TDengine.
      httpConnectTimeout	The httpConnectTimeout duration of the database. The default value is 900,000 milliseconds (15 minutes). A value of -1 indicates no limit.
      httpSocketTimeout	The httpSocketTimeout duration of the database. The default value is 1,800,000 milliseconds (30 minutes). A value of -1 indicates no limit.

6. Select a Default Resource Group. This resource group is used to run tasks related to the current data source, including database SQL, offline database migration, and data preview.

7. Click Test Connection or directly click OK to save and complete the creation of the TDengine data source.

   When you click Test Connection, the system tests whether the data source can connect to Dataphin properly. If you directly click OK, the system automatically tests the connection for all selected clusters. However, even if all selected clusters fail the connection test, the data source can still be created normally.