CODEWITHSUNDEEP
docker-composeairflowairflow-api
maantarng
maantarng

Reputation: 153

Cannot find Oracle connection in Apache Airflow UI

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!

Upvotes: 0

Views: 53

Answers (1)

Christopher Jones
Christopher Jones

Reputation: 10681

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]

Upvotes: 1

Related Questions