All Products
Search
Document Center

Hologres:Associate a Hologres instance with a workspace

Last Updated:Feb 21, 2024

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 about how to purchase a Hologres instance, see Purchase a Hologres instance.

    After you purchase a Hologres instance, the system automatically creates a database named postgres and allocates limited resources to this database for management only. You must create a database for your business purpose. You can create a database in the Hologres console in a visualized manner. For more information, see Create a database.

    Note

    Hologres 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.

    Note

    You 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

  1. Log on to the DataWorks console. In the left-side navigation pane, choose Data Modeling and Development > Data Studio. On the page that appears, select a workspace from the drop-down list and click Go to DataStudio.

  2. In the left-side navigation pane, click Data Source.

  3. On the Data Source page, select a Hologres data source and click Associate.

  4. 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.

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: