Connect Superset to Exasol

Help Needed
1

Hi there,

we try to connect Superset with Exasol database and are following the official documentation to install the alchemy driver within the docker image.

As a consequence Exasol appears now in the drop down list of databases which can be connected. When we enter this connection string like
exa+pyodbc://A_USER:A_PASSWORD@192.168.1.2..8:1234/my_schema?CONNECTIONLCALL=en_US.UTF-8&driver=EXAODBC we get the error ERROR: Could not load database driver: ExasolEngineSpec

Any help is appreciated, Thanks

2

Hi,

Our SQLAlchemy dialect supports pyexasol as a backend , that avoids all sorts of issues with ODBC. So, I suggest using this instead. GitHub - exasol/sqlalchemy-exasol: SQLAlchemy dialect for EXASOL.

from sqlalchemy import create_engine
url = "exa+websocket://A_USER:A_PASSWORD@192.168.1.2..8:1234/my_schema?CONNECTIONLCALL=en_US.UTF-8"
e = create_engine(url)
r = e.execute("select 42 from dual").fetchall()
3

Hi Torsten,

thanks for your reply. I’ve tested that and the connection test in Superset database connection wizard did succeed. But then I can not continue as there seem that there other settings missing and the connect button is greyed out.

Superset2
Superset2492×476 7.61 KB

Kind regards, Jörg

4

Hi @kochjoe

Unfortunately, I am not an expert in Superset and also don’t have a Superset instance setup running. This week I am quite busy, so I can’t experiment. Until then, could you expand the screenshot and show what Superset is asking for in detail? I assume it probably looks similar to the video clips in Superset’s documentation, but please share an expanded screenshot. Connecting to Databases | Superset