Skip to main content
Version: v2

Beekeeper Studio

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

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 PostgreSQL Wire 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

Usage Restrictions

Usage Restrictions

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