Connect Navicat to Hologres for Fast SQL Development - Hologres

Navicat is a GUI database client that lets you connect to, query, and manage multiple databases from a single interface. This topic describes how to connect Navicat for PostgreSQL to a Hologres instance and start developing data.

Prerequisites

Before you begin, make sure you have:

Downloaded and installed the Navicat client
A Hologres instance. For details, see Purchase a Hologres instance
Your Hologres instance endpoint and port. Find them on the instance page in the Hologres console, under Network Information
Your Alibaba Cloud AccessKey ID and AccessKey secret. Retrieve them from the AccessKey Management page

Connect Navicat to Hologres

In the Navicat client, click Connection on the menu bar and select PostgreSQL

In the PostgreSQL-New Connection

Parameter	Description	Example
Connection Name	A custom name for the connection	—
Host	The public endpoint of the Hologres instance	`holodemo-cn-hangzhou.hologres.aliyuncs.com`
Port	The public port of the Hologres instance	`80`
Initial database	The name of the Hologres database to connect to	`postgres`
Username	Your Alibaba Cloud AccessKey ID	—
Password	Your Alibaba Cloud AccessKey secret	—

Click Test Connection. If the Connection Successful dialog box appears, Navicat is connected to Hologres.
Click OK.

What's next

For full Navicat usage, see the Navicat documentation.

Hologres is commonly used in the following scenarios:

Accelerate offline data queries: Run fast queries on MaxCompute data using foreign tables. See Accelerate queries of MaxCompute data using foreign tables.
Write real-time data: Use Hologres as a sink for streaming pipelines. See Hologres sink tables.