Connecting via PostgreSQL Wire Protocol
Accio follow https://www.postgresql.org/docs/13/protocol.html to implement postgres wire protocl, thus we can use native postgresql drivers and BI tools that support Postgresql to connect to Accio server. However, even though connecting PostgreSQL tools and client libraries is supported, the actual SQL statements have to be supported by Accio. A notable difference is that Accio doesn’t support transactions and currently not support JOIN and WITH RECURSIVE statement.
Supported PostgreSQL Drivers
| Name | Status |
|---|
| JAVA/JDBC | Beta |
| ODBC | Planning |
| Python | Planning |
Supported BI
| Name | Status |
|---|
| METABASE | WIP |
| PowerBI | Planning |
| Tableau | Planning |