SQLAlchemy-Exasol

SQLAlchemy-Exasol is an SQLAlchemy dialect extension.

Overview

The dialect is the system SQLAlchemy uses to communicate with various types of DBAPI implementations and databases. The sections that follow contain reference documentation and notes specific to the usage of each backend, as well as notes for the various DBAPIs.

For more details have a look into the SQLAlchemy documentation.

Getting Started

1. Install the Exasol-ODBC driver

2. Add sqlalchemy-exasol as a dependency

   $ pip install sqlalchemy-exasol
   

3. 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.