How to use Pandas Write_Frame to export results to Oracle Database in cx_Oracle How to use Pandas Write_Frame to export results to Oracle Database in cx_Oracle oracle oracle

How to use Pandas Write_Frame to export results to Oracle Database in cx_Oracle


To expand on Andy Hayden's comment: oracle is indeed not supported in pandas <= 0.13 and older (only sqlite and mysql were supported).

But the sql module got a big overhaul in 0.14 (in development at the moment). It now uses sqlalchemy under the hood, so normally oracle should now be supported through sqlalchemy. See the dev docs for more details: http://pandas-docs.github.io/pandas-docs-travis/io.html#io-sql. And indeed, if you would be able to test it with oracle and give some feedback, that would be fantastic!