The oracle2postgres package can be used to migrate data from Oracle to Postgres. It uses SQLAlchemy as an intermediary to map data types between the two database systems. The approach is hacky, but it worked for us!
For example usage, see the Jupyter Notebook at: https://github.com/MIT-LCP/oracle-to-postgres/blob/master/migration.ipynb.
pip install oracle2postgres
- Follow the instructions in the Jupyter Notebook at: https://github.com/MIT-LCP/oracle-to-postgres/blob/master/migration.ipynb.