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 allows you to 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, and a Hologres data source is added to the workspace. For more information, see Create a workspace and Add a Hologres data source.
NoteYou must make sure that the DataWorks workspace and the Hologres instance are in the same region. Otherwise, the association fails.
The RAM user is authorized to use DataWorks. This prerequisite must be met if you associate a Hologres instance with a workspace in DataWorks as the RAM user. For more information, see Use DataWorks as a RAM user.
Procedure
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 left-side navigation pane, click Data Source.
On the Data Source page, select a Hologres data source and click Associate.
In the message that appears, click Associate.
After you associate a Hologres instance with a workspace, you can refresh the page and go to the DataStudio page for data development.
For more information about how to associate a Hologres instance with a workspace, see Preparations before data development: Associate a data source or a cluster with DataStudio.
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: