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
.
Select Postgres
.
Step 2: Set connection information
Set the connection information in the following window.
- 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.
Step 3: Connection completed
Execute a Query to read data from the Canner Enterprise workspace to confirm a successful connection.
Usage Restrictions
Usage Restrictions
The datasets only support reading and do not support inserting, deleting, and modifying.