Using Oracle database with Hue

You can use a customer provided external Oracle database to store Hue metadata, job and query history, and account information. In Cloudera 7.1.x, Hue supports Oracle database versions 12c and 19c.

To use an Oracle database with Hue, you need:

Oracle Instant Client library: The Oracle Instant Client connects Hue to the backend Oracle database. The Oracle Client libraries provide the necessary network connectivity and tools, such as SQL*Plus and Oracle Data Pump, to access the data.
Oracledb Python extension module: Enables Oracle database connectivity for Hue by using the oracledb Python driver in Thin or Thick operational modes.
Hue supports the oracledb Python extension module to connect to Oracle databases. The module operates in Thin mode or Thick mode. In Thick mode, the module loads the Oracle Instant Client libraries, and communication with the Oracle database occurs over Oracle Net.

Hue releases between version 7.1.8 and version 7.1.9 use Python 3.8, Python 3.9, or 3.11 depending on your operating system. These releases support the Oracle Python driver version compatible with the bundled Python runtime environment and Oracle Client libraries. If you use Thick mode deployments, you must ensure that the appropriate Oracle Instant Client libraries are installed and accessible on the host system running Hue.

For more information, see Cloudera support matrix.

oracle-instantclient19.25-basic-19.25.0.0.0-1.x86_64.rpm
oracle-instantclient19.25-devel-19.25.0.0.0-1.x86_64.rpm
oracle-instantclient19.25-sqlplus-19.25.0.0.0-1.x86_64.rpm.

Before connecting to the Oracle database, install the oracledb Python extension module on the nodes where the Hue service will run by using the appropriate package manager or Python package installer for your operating system.

For example, on RHEL-based systems:

sudo yum install python3-pip
pip3 install oracledb

For operating systems other than RHEL, use the corresponding installation method supported by your platform. Ensure that the module is installed only on the hosts running the Hue service.

If using the oracledb module in Thick mode, ensure that the required Oracle Instant Client libraries are installed and accessible on the host system.

After installing the Cloudera cluster and the Hue service, configure the required Oracle database connection properties in the Hue settings using the connection details provided by your Oracle DBA.