Create a Hologres compute source

Updated at:

Dataphin supports Hologres as an offline compute source. You can create a Hologres compute source to accelerate offline data processing.

Prerequisites

Hologres is activated. For more information, see Purchase a Hologres instance.

Procedure

  1. On the Dataphin home page, in the top menu bar, choose Planning > Compute Source.

  2. On the Compute Source page, click + Add Compute Source, and then select Hologres Compute Source.

  3. On the Create Hologres Compute Source page, configure the parameters.

    • Basic information

      Parameter

      Description

      Compute Source Type

      Select Hologres.

      Compute Source Name

      The name must meet the following requirements:

      • Can contain only Chinese characters, digits, letters, underscores (_), and hyphens (-).

      • The name can be up to 64 characters in length.

      Compute Source Description

      A brief description of the compute source, up to 128 characters in length.

    • Configuration

      Parameter

      Description

      JDBC URL

      The endpoint of the Hologres compute source, in the format jdbc:postgresql://host:port/dbname.

      Schema

      Enter the schema of the compute engine database.

      Username, Password

      The credentials used to connect to the compute source.

      For a RAM user, enter the AccessKey ID and AccessKey secret. For a self-managed database account, enter the account ID and password.

      Access Method

      Select Public IP or VPC Network.

      • Public IP: For a self-managed database, you must grant public access permissions.

      • VPC Network:

        • Region: The region where the database is located. Only databases in the same region as the Dataphin instance are supported. For example, if your Dataphin instance is in the China (Shanghai) region, you can select only the China (Shanghai) region.

        • VPC ID: Enter the ID of the virtual private cloud (VPC) where the database is located. You can log on to the VPC console to view the ID. The following figure shows an example:

          image..png

        • Instance ID: Enter the VPC-connected instance ID. You can first obtain the corresponding Hologres instance ID from the instance list in the Hologres console. Then invoke GetInstance to obtain VpcInstanceId, which is the VPC-connected instance ID.

          The following figure shows how to obtain the Hologres instance ID:image

  4. Click Test Connection.

    If the connection test fails with the VPC_GRANT_ACCESS_API_ERROR error, see Solution for the VPC_GRANT_ACCESS_API_ERROR error for troubleshooting.

  5. After a successful connection test, click Submit.