SQL Workbench/J - Hologres - Alibaba Cloud Documentation Center

This topic describes how to connect Hologres to SQL Workbench/J for visual analytics.

Prerequisites

SQL Workbench/J is installed.
A Hologres instance is provisioned. For more information, see Purchase a Hologres instance.

Background information

SQL Workbench/J is a free, cross-platform SQL query and analysis tool. You can use it to connect to Hologres through a PostgreSQL driver for data development.

Procedure

Start SQL Workbench/J and create a new connection to Hologres.

Configure the connection information.

The following table describes the parameters.

Parameter	Description	Example
Driver	PostgreSQL Use the PostgreSQL driver to connect to Hologres.	None
URL	`jdbc:postgresql://endpoint:port/database` Endpoint: The public endpoint of the Hologres instance. Go to the instance details page in the Hologres console and obtain the endpoint from the Network Information tab. Port: The public port of the Hologres instance. Go to the instance details page in the Hologres console and obtain the port from the Network Information tab. Database: The name of the Hologres database to which you want to connect.	`jdbc:postgresql://holodemo-cn-hangzhou.aliyun.com:80/postgres` This example is for reference only. Replace the parameter values with your actual values.
Username	The AccessKey ID of your Alibaba Cloud account. To obtain the AccessKey ID, click AccessKey Management.	None
Password	The AccessKey secret of your Alibaba Cloud account.	None

Set extended properties.
1. Click Extended Properties and set SSL to true.
2. Click OK.
Click OK to connect Hologres to SQL Workbench/J.

You can now use SQL Workbench/J to query and analyze data in Hologres.