Connect through PostgreSQL Wire Protocol

Canner Enterprise implements the interface of PostgreSQL Wire Protocol so that different services, such as BI / ETL / ML, as long as they support PostgreSQL connector.

How to use

Regardless of JDBC, ODBC, or other PostgreSQL drivers, use the following parameters

• Database: SQL Name of Workspace
• Port: 7432
• Username: canner
• Password: Enter Personal Access Token

Support level

Driver

Language	Driver	Support Level
Java	JDBC	Full
C# (.NET)	Npgsql	Beta
C# (.NET)	ODBC	Beta
C	libpq	Beta
Python	psycopg2	Beta
JavaScript	pg	Beta

BI & Analysis Tool

BI	Support Level
Power BI	Only Import Mode
Power BI Reporting Service	Beta
Metabase	Full
Looker Studio	Full
Qlik Analytics Services	Beta
SAS	Full
Excel	Full

Graphical user interfaces (GUIs)

GUI	Support level
DBeaver	Beta
Beekeeper Studio	Beta
TablePlus	Beta
DataGrip	Beta

Command-Line Interface (CLI)

CLI
psql

The database is connected through DBLink

Database
Oracle