Using Oracle database with Hue
You can use the Oracle database to store Hue metadata, job and query history, and account information. Learn how to install and configure the Oracle database for Hue.
- 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.
- cx_Oracle Python extension module
- The cx_Oracle module loads the Oracle Client libraries. The cx_Oracle module and the Oracle Client libraries communicate with the data over Oracle Net
Hue on CDP releases between 7.1.8 and 7.1.9 uses Python version 3.8.12 and Django version 3.2.13. The minimum compatible cx_Oracle version that you can use with Hue is 6.4.1. cx_Oracle 8.3.0 is distributed with CDP. If you are on an older version of CDP, or if you are upgrading to CDP from CDH 5.x or 6.x, then you must upgrade cx_Oracle from 5.2.1 to 6.4.1.
Hue on CDP 7.1.9 SP1 and higher uses Python version 3.10. The compatible cx_Oracle version that you can use with Hue is 8.3.0. cx_Oracle 8.3.0 is distributed with CDP. Oracle's standard client-server version interoperability allows connection to both older and newer versions of databases.
To use Oracle as a backend database for Hue, you must download and install the Oracle Instant Client library and cx_Oracle Python extension module, and then set the database parameters in Cloudera Manager Hue configurations.
You must download the Oracle Instant Client library 19.16 (both basic and SDK clients) from the Oracle website.
