Cannot find Oracle connection in Apache Airflow UI

Question

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.org/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!

Did you install the Oracle provider: airflow.apache.org/docs/apache-airflow-providers-oracle/stable/… — Christopher Jones
– 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
– maantarng, Commented Feb 24 at 1:23

Christopher Jones · Accepted Answer · 2025-02-28 22:25:24Z

2

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

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

answered Feb 28 at 22:25

Christopher Jones

11.1k7 gold badges32 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot find Oracle connection in Apache Airflow UI

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related