Navicat is a multi-connection database development tool that allows you to connect multiple databases within a single application. It helps you quickly create, manage, and maintain databases. This topic describes how to connect Navicat to Hologres for data development.
Prerequisites
A Navicat client is downloaded from the Navicat official website and is installed.
A Hologres instance is purchased. For more information, see Purchase a Hologres instance.
Procedure
Establish a connection to Hologres.
Start Navicat 16 for PostgreSQL. Choose Connection > PostgreSQL in the top navigation bar.
On the Common tab of the PostgreSQL - New Connection dialog box, configure the parameters listed in the following table.
Parameter description
Parameter
Description
Example
Connection Name
The custom name of the connection.
None
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 obtain the port number of the Hologres instance in the Network Information section of the Instance Details page in the Hologres console.
80
Initial Database
The name of the Hologres database to which you want to connect.
postgres
User Name
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.
None
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.
None
Test Connection
If the Connection succeeded message appears after you click Test Connection, Navicat 16 for PostgreSQL is connected to Hologres.
None
Click OK.
Develop data in Navicat 16 for PostgreSQL.
After Navicat 16 for PostgreSQL is connected to Hologres, you can develop data in Navicat 16 for PostgreSQL. For more information, see Navicat documentation. Hologres is typically used in the following scenarios:
Accelerated query of offline data: For more information, see Create a foreign table in Hologres to accelerate queries on MaxCompute data.
Real-time data writing: For more information, see Hologres result table.