Skip to main content
Version: v4

DBeaver

This article shows how to connect from DBeaver to Canner Enterprise to retrieve data.

Set up Canner Enterprise as a DBeaver data source​

Step 1: Create a data source​

Click the create data source icon in the upper-left corner.

1_dbeaver

Select PostgreSQL as the data source.

2_dbeaver

Step 2: Configure the connection​

Configure the connection in the following window.

3_dbeaver

First, copy the connection information from the Canner Enterprise workspace you want to retrieve data from (see the steps in Canner Protocol Overview), then fill it in on the DBeaver settings screen.

  • Host: The host or IP address of Canner Enterprise
  • Port: Use the port shown under the Share button in Canner Enterprise; the default is 7432
  • Database: The SQL Name of this workspace
  • User: Enter canner
  • Password: Enter a Personal Access Token. See how to create a Personal Access Token

To find these values, open the workspace you want to connect to DBeaver in Canner Enterprise, click the Share button in the upper right, and switch to Canner Protocol to see its connection information.

pg_connect_info

Step 3: Connection complete​

Once connected, the data appears in the sidebar, and you can use it for any downstream work in DBeaver.

4_dbeaver