Navicat

Procedure

1. Create a connection to Hologres.

   In the Navicat client, choose Connection > PostgreSQL from the top menu bar.

2. In the PostgreSQL - New Connection dialog box, on the General tab, set the Connection name, Host (default: localhost), Port (default: 5432), Initial database (default: postgres), Username (default: postgres), and Password. You can select the Save password checkbox, and then click OK.

   The following table describes the parameters.

   Parameter	Description	Example
   Connection name	A custom name for your connection.	N/A
   Host	The public endpoint of the Hologres instance. In the Hologres console, find the host on the instance details page in the Network Information section.	holodemo-cn-hangzhou.hologres.aliyuncs.com
   Port	The port for the public endpoint. In the Hologres console, find the port on the instance details page in the Network Information section.	80
   Initial database	The name of the database to connect to.	postgres
   Username	The AccessKey ID of your account. Go to the AccessKey Management page to get your AccessKey ID.	N/A
   Password	Your account's AccessKey secret.	N/A
   Test connection	Click Test Connection. If a Connection succeeded message appears, the connection is successful.	N/A

3. Click OK.

4. Perform data development.

   After you connect Navicat to Hologres, you can begin data development. For more information, see the Navicat Help Documentation. Typical use cases for Hologres include:

   • Accelerate queries on offline data. For more information, see Accelerate queries on MaxCompute data by using a foreign table.

   • Write data in real time. For more information, see Hologres sink tables.