Canner Protocol Overview

Canner Protocol is an interface that follows the PostgreSQL wire protocol standard, so any application or tool that supports PostgreSQL can connect to it and access data in Canner Enterprise workspaces.

How to use

Step 1: Copy the Canner Protocol connection information

Click the Share button in the upper-right corner of a workspace and select the Canner Protocol tab to view and copy the following information.

• Database (SQL Name): The SQL Name of this workspace
• Port: 7432
• Username: canner
• Password: The password for Canner Protocol connections is your Personal Access Token. See Get a Personal Access Token

Step 2: Enter the connection information in the tool you want to connect

Configure the connection according to each tool's connection method. See the setup steps for each supported tool in this chapter.

Supported tools

BI and advanced analytics tools

Tool
Tableau
Power BI
Metabase
Looker Studio
Qlik Analytics Services
SAS EG
Excel

Graphical user interfaces (GUIs)

GUI
DBeaver

ETL tools

Tool
Airflow
SSIS

Command-Line Interface (CLI) tools

Tool
psql

Development tools

Language	Driver
Java	JDBC
JavaScript	pg
C# (.NET)	Npgsql, ODBC
PHP	pg_connect
Python	psycopg2