Hologres:Associate a Hologres instance with a DataWorks workspace

Go to the Computing Resource page

1. Log on to the DataWorks console. Switch to the target region. In the left navigation pane, click More > Management Center. Select the target workspace from the drop-down list and click Go To Management Center.

2. In the left navigation pane, click Computing Resource.

Configure and associate the computing resource

1. Click Associate Computing Resource to open the Associate Computing Resource panel. Set the computing resource type to Hologres.

2. On the Associate Hologres Computing Resource panel, configure the following parameters.

   Parameter	Description
   Hologres instance	Select your Hologres instance. To create one, click Create in the drop-down list to purchase a Hologres instance.
   Hologres virtual warehouse	Select a virtual warehouse. To create one, click Create in the drop-down list to create a Hologres compute group.
   Database name	Select the database to use. To create one, click Create in the drop-down list to create a database.
   Default access identity	The identity used to run tasks. In the development environment, only Executor is supported. In the production environment, Alibaba Cloud Account, Alibaba Cloud RAM User, Alibaba Cloud RAM Role, and Task Owner are supported. If you log on with an Alibaba Cloud account or a RAM user/role that has the AdministratorAccess policy, you can select any identity. Otherwise, you can only select your own identity.
   Authentication method	Select No Authentication or SSL Authentication. If you select SSL Authentication, you must enable SSL Encryption on the Data Security page of the Hologres instance. When SSL authentication is enabled, the instance cannot be used for data development or periodic scheduling tasks.
   SSL encryption	Required when Authentication method is set to SSL Authentication. Only the require encryption mode is supported.
   Computing resource instance name	Enter a custom name for this computing resource. Tasks use this name to identify which computing resource to run on.

3. In the connection configuration section, select the resource group DataWorks uses to run Hologres tasks. Click Test Network Connectivity to verify the resource group can reach your Hologres instance. For details on connectivity options, see Overview of network connection solutions.

4. Click OK.

After the association is complete, DataWorks automatically creates a Hologres data source with the same name in the Data Sources list of the workspace.

Go to the Computing Resource page

1. Log on to the DataWorks console. In the top navigation bar, select the target region. In the left navigation pane, choose Data Development and O&M > Data Development. Select the target workspace from the drop-down list and click Go to Data Development.

2. In the left navigation pane, click Computing Resource.

Configure and associate the computing resource

1. Click Create Computing Resource. In the Create Computing Resource wizard, select Hologres.

2. Configure the following parameters.

   Parameter	Description
   Data source name	Enter a custom name for the computing resource.
   Authentication method	Only Alibaba Cloud Account and RAM Role is supported.
   Alibaba Cloud Account	Select Current Alibaba Cloud Account or Another Alibaba Cloud Account. If you select Another Alibaba Cloud Account, also fill in UID of Alibaba Cloud Account and RAM Role.
   Region	The region where your workspace resides.
   Hologres instance	Select your Hologres instance.
   Database name	Select the database to use.
   Default access identity	The identity used to run tasks. In the development environment, only Executor is supported. In the production environment, Alibaba Cloud Account, Alibaba Cloud RAM User, Alibaba Cloud RAM Role, and Task Owner are supported. If you log on with an Alibaba Cloud account or a RAM user/role that has the AdministratorAccess policy, you can select any identity. Otherwise, you can only select your own identity.
   Authentication method	Select No Authentication or SSL Authentication. If you select SSL Authentication, you must enable SSL Encryption on the Data Security page of the Hologres instance. When SSL authentication is enabled, the instance cannot be used for data development or periodic scheduling tasks.
   SSL encryption	Required when Authentication method is set to SSL Authentication. Only the require encryption mode is supported.

3. In the connection configuration section, select the resource group DataWorks uses to run Hologres tasks. Click Test Network Connectivity to verify the resource group can reach your Hologres instance. For details, see Overview of network connection solutions.

4. Click Create and Associate Computing Resource with DataStudio.

After the association is complete, DataWorks automatically creates a Hologres data source with the same name in the Data Sources list of the workspace.

Instance name already exists

If an instance display name already exists in DataWorks, change the display name and try again.

Invalid database name

Verify the database name is correct and exists in the Hologres instance.

Extra spaces in field values

Check whether any field values contain leading or trailing spaces and remove them.

Insufficient permissions

Verify your account has the required permissions on the Hologres instance and the administrator role in the DataWorks workspace.