Overview

While many shops using Airflow will be on open source relational database management systems (PostgreSQL, MariaDB, MySQL), there will be established firms that have legacy Oracle systems they need to support. In addition, there are various data providers that provide their product only in Oracle or SQL Server format. Therefore, this document aims to provide some tips and tricks for Oracle shops implementing AirBnB Airflow into their production environment.

Creating an Oracle Connection through the web user interface.

Oracle users an SID to identify a unique database instance. Oracle also has an unusual definition of schema and user, wherein a schema set of objects owned by a user. Therefore, creating a connection through the Airflow web GUI can be confusing.

To create a connection. 1. Go to Admin | Connections | Create

  1. Name your connection

  2. Select connection type: Oracle

  3. Enter your hostname in the following format: NameOrIP:PORT#/SID Example(s): 10.0.0.111:1521/orcl or weshouldhaveusedpostgres.ourdomain.com:1521/dev

  4. Enter your username in both the schema and login fields

  5. Enter your password in the password field.

  6. Save and continue.

  7. Go to Data Profiling | Add Hoc Query

  8. Select your connection name in the dropdown

  9. Test:

    1. Type select * from dual in the code window
    2. Click run
  • No labels