SQLAlchemy-Exasol

SQLAlchemy-Exasol is a dialect extension for SQLAlchemy, implementing support for Exasol databases.

Getting Started

1. Install the SQLAlchemy-Exasol extension

   $ pip install sqlalchemy-exasol
   

   Note

   SQLAlchemy will be installed due to the fact that it is an required dependency for SQLAlchemy-Exasol.

2. Execute queries

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

For more details on SQLAlchemy consult it’s documenation.