After you create a Hologres data source in DataWorks and associate the data source with DataStudio, you can read data from the Hologres data source in DataWorks and synchronize, develop, and analyze the data.
Prerequisites
A Hologres instance is purchased, and a database is created for the Hologres instance. For more information, see the following topics:
NoteHologres is compatible with PostgreSQL and lets you use the standard PostgreSQL authorization model, which is exactly the same as the permission model in PostgreSQL. Based on the understanding of customer business and practical experience, Alibaba Cloud introduced the simple permission model (SPM) to Hologres to simplify the management of user permissions. For more information, see Overview.
A DataWorks workspace is created. The RAM user who performs the operations is added to the workspace and assigned the administrator role.
NoteYou must make sure that the DataWorks workspace and the Hologres instance are in the same region. Otherwise, the association fails.
A resource group is bound to the workspace, and network connectivity is established.
If you use a Serverless resource group, make sure that the Hologres computing resource can connect to the Serverless resource group.
If you use a legacy resource group, make sure that the Hologres computing resource can connect to the exclusive resource group for integration, the exclusive resource group for scheduling, and the exclusive resource group for services for your scenario.
New DataStudio: Bind a Hologres computing resource
Bind a Hologres computing resource to a workspace in the Public Preview of the New DataStudio.
Go to the Computing Resources page
Log on to the DataWorks console. Switch to the destination region. In the navigation pane on the left, choose . From the drop-down list, select the target workspace and click Go To Management Center.
In the left navigation pane, click Computing Resources.
Bind a Hologres computing resource
On the Computing Resources page, configure the parameters to bind a Hologres computing resource.
Select the type of computing resource to bind.
Click Bind Computing Resource to open the Bind Computing Resource page.
On the Bind Computing Resource page, set the computing resource type to Hologres to open the Bind Hologres Computing Resource configuration page.
Configure the Hologres computing resource.
On the Bind Hologres Computing Resource configuration page, use the following table to configure the parameters.
Parameter
Description
Hologres Instance
Select the Hologres instance that you created. You can also click Create in the drop-down list to purchase a Hologres instance.
Hologres Compute Group
The current Hologres instance supports compute groups. You can also click Create in the drop-down list to create a Hologres compute group.
Database Name
Select the database that you want to use. You can also click Create in the drop-down list to create a database.
Default Access Identity
Development Environment: Only the Executor identity is supported.
Production Environment: The Alibaba Cloud Account, RAM User, RAM Role, or Task Owner identity is supported.
NoteIf you are logged on with an Alibaba Cloud account: You can select any identity.
If you are logged on with a RAM user or RAM role:
If you have the AdministratorAccess policy: You can select any identity.
If you do not have the AdministratorAccess policy: You can only select your own identity.
Authentication Options
No Authentication: No other operations are required.
SSL Authentication: If you select this option, you must enable SSL Encryption on the Data Security page of the Hologres instance.
NoteIf Secure Sockets Layer (SSL) authentication is enabled for the Hologres instance, the instance cannot be used for data development or periodic scheduling tasks.
SSL Encryption Mode
This parameter is required when Authentication Options is set to SSL Authentication. Only the require encryption mode is supported.
Computing Resource Instance Name
Enter a custom name for the computing resource instance. When a task runs, you can select the computing resource for the task based on this name.
Test the connectivity.
In the Connection Configuration section, select the resource group that DataWorks uses to run Hologres tasks. Click Test Connectivity to verify that the resource group can access your Hologres instance. For more information, see Network connectivity solutions.
Click Confirm to complete the Hologres computing resource configuration.
NoteAfter the binding is complete, a Hologres data source with the same name is automatically created in the current workspace's Data Source module.
Legacy DataStudio: Bind a Hologres computing resource
You can bind a Hologres computing resource to a workspace that is not in the Public Preview Of The New DataStudio.
Go to the Computing Resources page
Go to the DataStudio page.
Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose . On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.
In the navigation pane on the left, click the
icon to open the Computing Resources page.
Bind a Hologres computing resource
On the Computing Resources page, configure the parameters to bind a Hologres computing resource.
Select the type of computing resource to bind.
Click Create Computing Resource. The Create Computing Resource page appears.
On the Create Computing Resource page, set the computing resource type to Hologres to proceed to the Create Computing Resource configuration page.
Configure the Hologres computing resource.
On the Create Computing Resource configuration page, configure the parameters according to the following table.
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
You can select Current Alibaba Cloud Account or Other Alibaba Cloud Account.
NoteIf you select Other Alibaba Cloud Account, enter the parameter information about the other account as prompted.
Region
The region where your workspace resides.
Hologres Instance
Select the Hologres instance that you created.
Database Name
Select the database that you want to use.
Default Access Identity
Development Environment: Only the Executor identity is supported.
Production Environment: The Alibaba Cloud Account, RAM User, RAM Role, or Task Owner identity is supported.
NoteIf you are logged on with an Alibaba Cloud account: You can select any identity.
If you are logged on with a RAM user or RAM role:
If you have the AdministratorAccess policy: You can select any identity.
If you do not have the AdministratorAccess policy: You can only select your own identity.
Authentication Options
No Authentication: No other operations are required.
SSL Authentication: If you select this option, you must enable SSL Encryption on the Data Security page of the Hologres instance.
NoteIf SSL authentication is enabled for the Hologres instance, the instance cannot be used for data development or periodic scheduling tasks.
SSL Encryption Mode
This parameter is required when Authentication Options is set to SSL Authentication. Only the require encryption mode is supported.
Test the connectivity.
In the connection configuration section, select the resource group that DataWorks uses to run Hologres tasks. Click Test Connectivity to ensure that the resource group can access your Hologres cluster. For more information, see Network connectivity solutions.
Click Create Computing Resource And Bind To Data Development to complete the Hologres computing resource configuration.
After the binding is complete, a Hologres data source with the same name is automatically created in the Data Source module of the current workspace.
FAQ
What do I do if the connectivity test fails?
Problem description: When a Hologres instance is associated with a workspace, the connectivity test fails.
Cause: The parameters that you configure to associate the Hologres instance are invalid, or the current account has no permissions on the Hologres instance.
Solution:
The instance display name that you configure may already exist in DataWorks. In this case, change the display name.
Check whether the database name is valid.
Check whether the information that you entered includes extra spaces. If the information includes extra spaces, delete the extra spaces.
Check whether the current account is granted the required permissions on the Hologres instance, and whether the current account assumes the administrator role of the current DataWorks workspace.
What to do next
After you associate a Hologres data source with a workspace in DataWorks, you can perform the following operations in DataStudio: