DataGrip is a development tool that allows you to connect an application to multiple databases. DataGrip facilitates the creation, management, and maintenance of databases. This topic describes how to use the DataGrip client to connect to a Hologres database.

Prerequisites

Procedure

To connect to Hologres from the DataGrip client, perform the following steps:

  1. Open the DataGrip client and click the Create connection icon below Database Explorer.
  2. Choose Data Source > PostgreSQL.
    Create connection
  3. In the Data Source and Drivers dialog box, set the parameters described in the following table.
    Note
    • If the missing driver files message appears, click Download to download the driver first.
    • If you use an earlier version of the DataGrip client, select Introspection using JDBC metadata in the Introspection section of the Options tab. Options tab
    Parameters
    Parameter Description Example
    Name The custom name of the connection. N/A
    Host The public endpoint of the Hologres instance. You can view the public endpoint of the Hologres instance in the Network Information section of the Instance Details page in the Hologres console. holodemo-cn-hangzhou.hologres.aliyuncs.com
    Port The public port number of the Hologres instance. You can view the port number of the Hologres instance in the Network Information section of the Instance Details page in the Hologres console. 80
    Database The name of the Hologres database to which you want to connect. To view the name of the database, go to the Instance Details page in the Hologres console and click Database Management in the left-side pane. postgres
    User The AccessKey ID of your account that is used to access the Hologres instance. You can obtain the AccessKey ID from the Security Management page. N/A
    Password The AccessKey secret of your account that is used to access the Hologres instance. You can obtain the AccessKey secret from the Security Management page. N/A
    Test Connection Click Test Connection. If the Connection Success message appears, DataGrip connects to the Hologres database. N/A
  4. Click OK.
    After DataGrip connects to the Hologres database, you can perform data development operations by using DataGrip. For more information, see DataGrip documentation.
    Hologres is typically used in the following scenarios: