Create a Hologres compute source
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
-
On the Dataphin home page, in the top menu bar, choose Planning > Compute Source.
-
On the Compute Source page, click + Add Compute Source, and then select Hologres Compute Source.
-
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:

-
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:

-
-
-
-
Click Test Connection.
If the connection test fails with the
VPC_GRANT_ACCESS_API_ERRORerror, see Solution for the VPC_GRANT_ACCESS_API_ERROR error for troubleshooting. -
After a successful connection test, click Submit.