Try use SQLPlus, which can be used to extract data from Oracle7 directly. You could write scripts in SQLPlus to extract data, then use Python to process the exported data (e.g., CSV files).

An Example using python:

import subprocess

command = "sqlplus -S username/password@your_database @your_script.sql" subprocess.run(command, shell=True)