Exasol

[amotl]

About

Exasol could be easily unlocked using its SQLAlchemy dialect SQLAlchemy-Exasol. CrateDB Toolkit apparently can do it already using the exa+websocket:// protocol scheme, see CTK » Database » Integrations. How?

[amotl]

CTK

CrateDB Toolkit apparently can do it already [...]. How?

I see. The particular documentation snippet of CTK's Exasol => CrateDB pipeline is actually just a stub. Let's bring the Exasol adapter to omniload instead, so CTK can also consume it from here.

$ ctk load \
>     "exa+websocket://sys:exasol@127.0.0.1:8888?table=demo" \
>     "crate://crate:na@localhost:4200/testdrive/exasol"

NotImplementedError: Importing resource not implemented yet: exa+websocket://sys:exasol@127.0.0.1:8888?table=demo

[amotl]

ADBC

Using ADBC could also be an option to connect to Exasol.

dbc install exasol

References

• https://www.linkedin.com/posts/ianmcook_one-of-the-coolest-things-about-adbc-is-that-activity-7457409394734141440-qKVk
• ADBC #138