Dataphin:Create a GoldenDB data source

Permission requirements

You must have the Create Data Source permission in a custom global role, or one of the following system roles: super administrator, data source administrator, domain architect, or project administrator.

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 GoldenDB in the Relational Database section.

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

4. On the Create GoldenDB Data Source page, configure the data source parameters.

   1. Configure the basic information of the data source.

      Parameter	Description
      Data Source Name	Naming rules: It can contain only Chinese characters, letters, digits, underscores (_), and hyphens (-). Maximum length: 64 characters.
      Datasource Code	Reference tables in Flink_SQL tasks using data source code.table name or data source code.schema.table name. For environment-based access, use ${data source code}.table or ${data source code}.schema.table. Development method for Dataphin data source tables. 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.
      Version	Supported version: GoldenDB v5.
      Data Source Description	Description of the GoldenDB data source. Maximum 128 characters.
      Data Source Configuration	Select based on whether your data source separates production and development environments: Separate production and development data sources: select Production + Development Data Source. Shared data source for both environments: select Production Data Source.
      Tag	Categorize data sources with tags. Manage data source tags.

   2. Configure connection parameters.

      If you selected Production + Development Data Source, configure connection details for both environments. If you selected Production Data Source, configure only the production connection.

      Note

      For environment isolation, configure separate data sources for production and development. Dataphin also supports using the same data source with identical parameters for both.

      Parameter	Description
      JDBC URL	Format: jdbc:mysql://host:port/dbname. Example: jdbc:mysql//192.168.*.212:3309/dataphin.
      Username and Password	Database login credentials.

   3. Configure advanced settings.

      Parameter	Description
      connectTimeout	Database connection timeout in milliseconds. Default: 900,000 (15 minutes). Note If connectTimeout is set in the JDBC URL, that value takes precedence. For data sources created before Dataphin V3.11, the default is -1 (no timeout limit).
      socketTimeout	Database socket timeout in milliseconds. Default: 1,800,000 (30 minutes). Note If socketTimeout is set in the JDBC URL, that value takes precedence. For data sources created before Dataphin V3.11, the default is -1 (no timeout limit).
      Connection Retries	Automatically retries the database connection on timeout. If all retries fail, the connection fails. Note Default: 1. Valid range: 0 to 10. Applies by default to offline integration tasks and global quality (requires asset quality to be enabled). You can override retries at the task level for offline integration tasks.

5. Select a Default Resource Group for running database SQL, offline database migration, and data preview tasks.

6. Click Test Connection to verify connectivity, or click OK to save the data source directly.

   Clicking Test Connection verifies connectivity to Dataphin. Clicking OK auto-tests all selected clusters but saves the data source even if tests fail.