Overview
Canner Protocol follows the interface of PostgreSQL Wire Protocol so that different services, such as BI / ETL / ML, as long as they support PostgreSQL connector can connect to the software.
How to use
Regardless of JDBC, ODBC, or other PostgreSQL drivers, use the following parameters
Support level
Driver
| 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)
The database is connected through DBLink