Author: Luca.Canali@cern.ch
Related blog entries:
This folder contains example notebooks on how to use Jupyter/IPython for querying Oracle databases and integrating with Python data analysis and visualization tools.
Example notebooks:
| Notebook | Short description |
|---|---|
| Oracle from Jupyter notebooks using oracledb and Pandas | Examples of how to query Oracle from Python Notebooks using Oracldb and how to integrate with Pandas and visualization with matplotlib. |
| Oracle Histograms | Examples in a notebook on how to generate frequency histograms using Oracle SQL |
| Oracle from Jupyter notebooks using cx_Oracle and Pandas | Examples of how to query Oracle from Python notebooks using cx_Oracle and how to integrate with pandas and visualization with matplotlib. |
| Oracle and IPython SQL _magic | Examples of how to query Oracle using %sql line magic (or %%sql cell magic) and the integration with cx_Oracle and pandas. |
| Oracle sqlplus from Jupyter notebooks | Examples of how to use sqlplus inside Jupyter notebooks. It is based on the use of %%bash cell magic and here documents to wrap up sqlplus inside Jupyter cells. |
Dependencies and pointers for the test environments:
- Install Jupyter notebooks. For example use Anaconda Python.
- Install the Oracle client
- Download from https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
- When installing the client on a custom directory, also
export LD_LIBRARY_PATH={oracle client home}
- Check that the Oracle client works and all dependencies are set by running sqlplus from the Oracle client home, example:
- check client connectivity with:
sqlplus username/password@dbserver:port/service_name
- check client connectivity with:
- Install cx_Oracle, for example with
pip install cx_Oracle - Install oracledb,
pip install oracledb - Install ipython-sql, for example with
pip install ipython-sql