Dataphin:Create a GBase 8c data source

Limits

Only users with a custom global role that includes the Create Data Source permission or users with the super administrator, data source administrator, workspace architect, or project administrator system role can create data sources.

Procedure

1. On the Dataphin home page, go to the top menu bar and choose Management Center > Datasource Management.

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

3. On the New Data Source page, in the Relational Database section, select GBase 8c.

   If you have recently used GBase 8c, you can also select GBase 8c from the Recently Used section, or search for it in the search box.

4. On the New GBase 8c Data Source page, configure the connection parameters for the data source.

   1. Configure the basic information for the data source.

      Parameter	Description
      Datasource Name	Naming rules: Can contain only Chinese characters, uppercase and lowercase letters, digits, underscores (_), and hyphens (-). Cannot exceed 64 characters in length.
      Datasource Code	Use the data source code to reference tables in Flink_SQL tasks with the DataSourceCode.TableName or DataSourceCode.schema.TableName format. To access the data source for the current environment, use the variable format ${DataSourceCode}.table or ${DataSourceCode}.schema.table. Develop tables for Dataphin data sources. 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	Description of the data source. Maximum 128 characters.
      Data Source Configuration	Whether to use separate data sources for production and development: Separate data sources: Select Production + Development Data Source. Single data source: Select Production Data Source.
      Tag	Add tags to categorize the data source. Manage data source tags.

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

      If Data Source Configuration is set to Production + Development Data Source, configure connection information for both environments. If set to Production Data Source, configure only the production connection.

      Note

      We recommend using different data sources for production and development to ensure environment isolation. However, you can use the same data source for both by entering identical parameter values.

      Configuration Method: Select JDBC URL (default) or Host.

      JDBC URL configuration method

      Parameter	Description
      JDBC URL	Format: jdbc:gbase8c://host:port/database.
      Schema	Enter the schema associated with the username.
      Username and Password	Username and password for authentication. Ensure the user has the required data permissions.

      Host configuration method

      • Host configuration method

        Parameter	Description
        Server Address	IP address and port number of the server. Click + Add to add entries. Click the icon to delete entries. At least one entry is required.
        dbname	Database name.

      • Parameter settings

        Parameter	Description
        Parameter	Parameter name: You can select an existing parameter name or enter a custom one. Custom parameter names can contain only uppercase and lowercase letters, digits, periods (.), underscores (_), and hyphens (-). Parameter value: Required when a parameter name is selected. Can contain only letters, digits, periods (.), underscores (_), and hyphens (-). Maximum 256 characters. Note Click + Add Parameter to add parameters (maximum 30). Click the icon to delete parameters.
        Schema	Enter the schema associated with the username.
        Username, Password	Username and password to log on to the GBase 8c database.

      Note

      If you switch from Host to JDBC URL after creating the data source, the system automatically combines the server address and port to populate the JDBC URL.

   3. Configure the advanced settings for the data source.

      Parameter	Description
      socketTimeout	Socket timeout for the database, in milliseconds. Default: 1,800,000 ms (30 minutes). Note If the JDBC URL contains a socketTimeout setting, that value takes precedence. For data sources created before Dataphin V3.11, the default is -1 (no timeout).
      connectTimeout	Connection timeout for the database, in milliseconds. Default: 900,000 ms (15 minutes). Note If the JDBC URL contains a connectTimeout setting, that value takes precedence. For data sources created before Dataphin V3.11, the default is -1 (no timeout).
      Connection Retries	Number of automatic retry attempts when a database connection times out. If all retries fail, the connection fails. Note Default: 1. Valid values: 0 to 10. Applies by default to batch integration tasks and global quality rules (requires the asset quality feature). You can override this at the task level for batch integration tasks.

   Note

   Duplicate parameter value precedence:

   • If a parameter is set in the JDBC URL, Advanced Settings, and Host configuration, the value in the JDBC URL takes precedence.

   • If a parameter is set in both the JDBC URL and Advanced Settings, the value in the JDBC URL takes precedence.

   • If a parameter is set in both Advanced Settings and the Host configuration, the value in Advanced Settings takes precedence.

5. Select a Default Resource Group. This resource group runs data source tasks such as SQL statements, batch full-database migrations, and data previews.

6. Click Test Connection or click OK to save the settings and create the GBase 8c data source.

   Test Connection verifies the connection to Dataphin. Clicking OK directly tests connections for all selected clusters automatically. You can create the data source even if connection tests fail.