This topic describes how to connect SQL Workbench/J to Hologres. After SQL Workbench/J is connected to Hologres, you can use it to analyze data in Hologres in a visualized manner.

Prerequisites

Background information

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

Procedure

  1. Start SQL Workbench/J and establish a connection to Hologres.
  2. Configure the parameters listed in the following table.
    Parameter Description Example value
    Driver PostgreSQL

    Used to connect to Hologres.

    None
    URL jdbc:postgresql://endpoint:port/database
    • Endpoint: the public endpoint of the Hologres instance.

      You can view the public endpoint of the Hologres instance on the Configurations tab of the instance details page in the Hologres console.

    • Port: the public port number of the Hologres instance.

      You can view the public port number of the Hologres instance on the Configurations tab of the instance details page in the Hologres console.

    • Database: the name of the Hologres database to which you want to connect.
    jdbc:postgresql://holodemo-cn-hangzhou.aliyun.com:80/postgres

    This value is only for reference.

    Username The AccessKey ID of your account that is used to access the Hologres instance.

    You can obtain the AccessKey ID on 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 on the Security Management page.

    None
  3. Configure extended properties.
    1. Click Extended Properties. In the Edit extended properties dialog box, set SSL to true.
    2. Click OK.
  4. Click OK. SQL Workbench/J is connected to Hologres.
    You can query and analyze data of the Hologres instance in SQL Workbench/J. For more information about how to configure the driver and install SQL Workbench/J, see the SQL Workbench/J documentation on the official website.