Skip to main content
Version: v3

Beekeeper Studio

In this article, you can learn how to get data from Beekeeper Studio to Canner Enterprise.

Usage Restrictions

The datasets only support reading and do not support inserting, deleting, and modifying.

Set Canner Enterprise as Beekeeper Studio data source​

Step 1: Set the data source​

Once on the Beekeeper Studio page, click on Connection Type.

1_beekeeper

Select Postgres.

2_beekeeper

Step 2: Set connection information​

Set the connection information in the following window.

3_beekeeper

  • Host: Fill in the Host or IP address of Canner Enterprise
  • Port: Usually 7432, if there is a particular port setting, please pay attention to this field
  • Database: Enter the SQL Name in Workspace
  • User: canner
  • Password: Fill in Personal Access Token to create Personal Access Token Way

When setting relevant field information, you can click the Share button on the upper right for the workspace you want to connect to Beekeeper Studio in Canner Enterprise and switch to Canner Protocol to view its connection information.

pg_connect_info

Step 3: Connection completed​

Execute a Query to read data from the Canner Enterprise workspace to confirm a successful connection.

4_beekeeper