ODBC
Linux
Installation
For now soci-odbc is not available from conda-forge.
The package is available under different names depending on your Linux distribution.
For example:
sudo dnf install libaio.x86_64 soci.x86_64 soci-odbc.x86_64
sudo apt-get install libaio-dev libsoci-core4.0 libsoci-odbc4.0
Then from conda
conda install xeus-sql jupyterlab -c conda-forge
Usage
To use the ODBC driver from inside a notebook you need to connect to the compatible database with the
`LOAD` magic and the related driver.
For example:
Once the PostGreSQL driver installed
%LOAD odbc DRIVER=<path to the pgsql driver>;DBQ=<hostname>:<port>/<database>;UID=<user>;PWD=<password>
Once the Oracle driver installed
%LOAD odbc DRIVER=<path to the oracle driver>;DBQ=<hostname>:<port>/<SID>;UID=<user>;PWD=<password>
Oracle does not distribute debian based packages but the driver can be installed on any Linux distribution via the available zip archives.