I am using Docker Compose to run Apache Airflow on Ubuntu 22.04. I downloaded the docker-compose.yaml file from the Airflow website(.10.5/docker-compose.yaml). The setup runs successfully, and I can access the Airflow UI.

I need to connect Airflow to an Oracle database. However, when I navigate to Airflow UI → Admin → Connections to add a new connection, Oracle does not appear in the connection type dropdown list.

Questions:

How can I enable Oracle as a connection type in the Airflow UI? Is it possible to add an Oracle connection using the Airflow CLI? If so, how can I do it? I am currently using Airflow 2.10.5 as the image version.

Thanks!

I am using Docker Compose to run Apache Airflow on Ubuntu 22.04. I downloaded the docker-compose.yaml file from the Airflow website(https://airflow.apache./docs/apache-airflow/2.10.5/docker-compose.yaml). The setup runs successfully, and I can access the Airflow UI.

I need to connect Airflow to an Oracle database. However, when I navigate to Airflow UI → Admin → Connections to add a new connection, Oracle does not appear in the connection type dropdown list.

Questions:

How can I enable Oracle as a connection type in the Airflow UI? Is it possible to add an Oracle connection using the Airflow CLI? If so, how can I do it? I am currently using Airflow 2.10.5 as the image version.

Thanks!

• docker-compose
• airflow
• airflow-api

• Did you install the Oracle provider: airflow.apache./docs/apache-airflow-providers-oracle/stable/… – Christopher Jones Commented Feb 21 at 21:11
• Yes. After I install the Oracle provider using pip, and restart the container, I can see the Oracle connection type in the airflow UI. Thanks! – maantarng Commented Feb 24 at 1:23

1 Answer 1

Install the Oracle Provider using the instructions https://airflow.apache./docs/apache-airflow-providers-oracle/stable/index.html:

pip install apache-airflow-providers-oracle[common.sql]