DataGrip is a database development tool that lets you connect to multiple databases from a single application. You can use it to create, manage, and maintain databases quickly and easily. This topic describes how to connect to Hologres from DataGrip.
Prerequisites
-
The DataGrip client is installed. If not, click DataGrip to install it. This topic uses DataGrip 2024.2.1 as an example.
-
You have purchased a Hologres instance and created a database. For more information, see Purchase a Hologres instance and Create a database.
-
The public endpoint is enabled for the Hologres instance. For more information, see Instance details.
Procedure
To connect the DataGrip client to Hologres, follow these steps.
-
Open the DataGrip client and click the
icon on the Database Explorer menu bar. -
Select Data Source > PostgreSQL.
-
In the Data Sources and Drivers dialog box, configure the following parameters.
Note-
If the
missing driver filesmessage appears, click Download to download the driver files. -
For some older versions of the DataGrip client, on the Options tab, in the Introspection section, select Introspect using JDBC metadata.
Parameter
Description
Example
Name
A custom name for the connection.
None
Host
The public endpoint of the Hologres instance. Go to the Hologres console. On the Instance Details page, obtain the endpoint from the Network Information section.
holodemo-cn-hangzhou.hologres.aliyuncs.com
Port
The public port of the Hologres instance. Go to the Hologres console. On the Instance Details page, obtain the port number from the Network Information section.
80
Authentication
The authentication method. Select User & Password.
None
User
The AccessKey ID of your Alibaba Cloud account. To obtain your AccessKey ID, go to the AccessKey Management page.
None
Password
The AccessKey secret of your Alibaba Cloud account.
None
Database
The name of the Hologres database to connect to. Go to the Hologres console. On the Instances page, obtain the database name from the Database Management page.
postgres
URL
The connection URL that is automatically generated based on your configurations.
jdbc:postgresql://holodemo-cn-hangzhou.hologres.aliyuncs.com:80/postgres
Test Connection
Click Test Connection. A success message indicates that DataGrip is connected to Hologres.
None
-
-
Click OK to connect DataGrip to Hologres.
After DataGrip is connected to Hologres, you can perform data development. For more information, see the DataGrip Help document.
The following are common application scenarios for Hologres:
-
Accelerating queries of offline data. For more information, see Accelerate queries of MaxCompute data using foreign tables.
-
Writing data in real time. For more information, see Hologres sink tables.
-