SQL Workbench/J is a free, cross-platform SQL query and analysis tool. Connect it to Hologres using a PostgreSQL JDBC driver to run queries and analyze data visually.
Prerequisites
Before you begin, make sure you have:
-
SQL Workbench/J installed — Download from sql-workbench.eu.
-
A Hologres instance — See Purchase a Hologres instance.
-
An AccessKey ID and AccessKey secret — Get them from AccessKey Management. You use these as your database username and password.
Set up the connection
Step 1: Configure connection parameters
-
Start SQL Workbench/J and create a new connection.
-
Set the Driver field to PostgreSQL.
-
In the URL field, enter a JDBC URL in this format:
Placeholder Description <endpoint>The public endpoint of your Hologres instance. Find it on the Network Information tab of the instance details page in the Hologres console. <port>The public port of your Hologres instance. Find it on the Network Information tab alongside the endpoint. <database>The name of the Hologres database to connect to. jdbc:postgresql://<endpoint>:<port>/<database>Example:
jdbc:postgresql://holodemo-cn-hangzhou.aliyun.com:80/postgres
-
Set Username to your AccessKey ID and Password to your AccessKey secret.
Step 2: Enable SSL
-
Click Extended Properties.
-
Set SSL to
true. -
Click OK.
Step 3: Connect
-
Click OK to establish the connection.
-
You can now use SQL Workbench/J to query and analyze data in Hologres.
What's next
-
Use the SQL editor to query tables and analyze data in your Hologres instance.
-
To connect other SQL clients to Hologres, see the other connection guides in the Hologres documentation.