Dataphin:Add a Hologres data source

What is Hologres

Hologres is an interactive analytics service developed by Alibaba. To use Hologres with Dataphin for data development, create a Hologres data source.

Permissions

Only users with the Create Data Source permission in a custom global role or the super administrator, data source administrator, domain architect, or project administrator role 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, select Hologres in the Big Data section.

   If you have recently used Hologres, you can also select Hologres from the Recently Used section or use the search box to find it.

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

   1. Configure basic information.

      Parameter	Description
      Datasource Name	Enter a data source name. Requirements: Can contain Chinese characters, letters, digits, underscores (_), and hyphens (-). Cannot exceed 64 characters.
      Datasource Code	Use this code to reference tables in Flink_SQL tasks: data source code.table name or data source code.schema.table name. For environment-aware 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.
      Data Source Description	Enter a brief description. Maximum 128 characters.
      Data Source Configuration	Select the data source configuration: If your data source separates production and development environments, select Production + Development Data Source. If not, select Production Data Source.
      Tag	Categorize data sources with tags. Manage data source tags.

   2. Configure connection parameters.

      Configure connection information for each environment based on your data source configuration: Production + Development data source or Production data source.

      Note

      Use different data sources for production and development to isolate environments. Dataphin also supports using the same data source for both.

      Parameter	Description
      Endpoint	The Hologres instance endpoint. Select one based on your network environment and access method. Endpoints.
      DBName	Find the database name on the Database Management page of the Hologres console. Manage databases.
      Schema	Enter the target schema.
      Access Id, Access Key	Enter the Access ID and Access Key. Ensure the account has the required data permissions.

   3. Configure advanced connection settings.

      Connection Retries: Number of automatic retry attempts when the database connection times out.

      Note

      • Default: 1. Range: 0 to 10.

      • Applies to offline integration tasks and global quality (requires Data Quality module). Task-level retries can be configured separately.

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

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

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